| 1 |
kdziedzi |
1.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 |
|
|
?> |
