[Phpgroupware-cvs] phpgwapi/inc/adodb/tests/test2.php, 1.1.2.1

[nomail]

Update of /phpgwapi/inc/adodb/tests
Added Files:
        Branch: proposed-0_9_18-branch
          test2.php

date: 2004/12/30 04:51:48;  author: skwashd;  state: Exp;  lines: +26 -0

Log Message:
switch to ADOdb
=====================================================================
<?php

// BASIC ADO test

        include_once('../adodb.inc.php');

        $db = &ADONewConnection("ado_access");
        $db->debug=1;
        $access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
        $myDSN =  'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
                . 'DATA SOURCE=' . $access . ';';
                
        echo "<p>PHP ",PHP_VERSION,"</p>";
        
        $db->Connect($myDSN) || die('fail');
        
        print_r($db->ServerInfo());
        
        try {
        $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where 
id>02xx");
        print_r($rs->fields);
        } catch(exception $e) {
        print_r($e);
        echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y');
        }
?>