You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
42 lines
936 B
42 lines
936 B
4 months ago
|
<?php
|
||
|
|
error_reporting(E_ALL);
|
||
|
|
include('../adodb.inc.php');
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
echo "New Connection\n";
|
||
|
|
$DB = NewADOConnection('pdo');
|
||
|
|
echo "Connect\n";
|
||
|
|
$pdo_connection_string = 'odbc:nwind';
|
||
|
|
$DB->Connect($pdo_connection_string,'','') || die("CONNECT FAILED");
|
||
|
|
echo "Execute\n";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
|
||
|
|
$rs = $DB->Execute("select * from products where productid<3");
|
||
|
|
echo "e=".$DB->ErrorNo() . " ".($DB->ErrorMsg())."\n";
|
||
|
|
|
||
|
|
|
||
|
|
//print_r(get_class_methods($DB->_stmt));
|
||
|
|
|
||
|
|
if (!$rs) die("NO RS");
|
||
|
|
echo "FETCH\n";
|
||
|
|
$cnt = 0;
|
||
|
|
while (!$rs->EOF) {
|
||
|
|
print_r($rs->fields);
|
||
|
|
$rs->MoveNext();
|
||
|
|
if ($cnt++ > 1000) break;
|
||
|
|
}
|
||
|
|
|
||
|
|
echo "<br>--------------------------------------------------------<br>\n\n\n";
|
||
|
|
|
||
|
|
$stmt = $DB->PrepareStmt("select * from products");
|
||
|
|
$rs = $stmt->Execute();
|
||
|
|
echo "e=".$stmt->ErrorNo() . " ".($stmt->ErrorMsg())."\n";
|
||
|
|
while ($arr = $rs->FetchRow()) {
|
||
|
|
print_r($arr);
|
||
|
|
}
|
||
|
|
die("DONE\n");
|
||
|
|
|
||
|
|
?>
|