Line | |
---|
1 | <?php |
---|
2 | |
---|
3 | // BASIC ADO test |
---|
4 | |
---|
5 | include_once('../adodb.inc.php'); |
---|
6 | |
---|
7 | $db = &ADONewConnection("ado_access"); |
---|
8 | $db->debug=1; |
---|
9 | $access = 'd:\inetpub\wwwroot\php\NWIND.MDB'; |
---|
10 | $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;' |
---|
11 | . 'DATA SOURCE=' . $access . ';'; |
---|
12 | |
---|
13 | echo "<p>PHP ",PHP_VERSION,"</p>"; |
---|
14 | |
---|
15 | $db->Connect($myDSN) || die('fail'); |
---|
16 | |
---|
17 | print_r($db->ServerInfo()); |
---|
18 | |
---|
19 | try { |
---|
20 | $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx"); |
---|
21 | print_r($rs->fields); |
---|
22 | } catch(exception $e) { |
---|
23 | print_r($e); |
---|
24 | echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y'); |
---|
25 | } |
---|
26 | ?> |
---|
Note: See
TracBrowser
for help on using the repository browser.