OA4QRY.DLL Extension to connect to OA II/III/IV databases via PHPVERSION HISTORY
Current build of OA4QRY.DLL from 17-10-2008 12:29 is BETA STABLE
|
|  | Sample PHP code as we use for the demos...
<?PHP
/* Simply add in php.ini the extension
extension=php_oa4qry.dll
*/
include ("oa4db.php.inc");
try {
$myquery = new oa4_query ($directory, "FIELD1",...);
} catch (Exception $e) {
echo "Datenbankfehler: ".$e->getMessage();
}
$myquery->Limit(0, 20);
$myquery->GetFileVersion();
$myquery->AddConstraint ("FIELD2", $value2, '~');
$myquery->AddConstraint ("FIELD3", $value3, '>');
$myquery->OrConstraint();
$myquery->AddConstraint ("FIELD3", $value4, '~');
$arr = $myquery->FetchResults();
$myquery->__destruct();
$total = $myquery->GetNumRows();
if ($total > 0){
$myquery->Sort ($arr, "FIELD4");
}
$result = $arr[0];
foreach ($arr as $result){
$val_of_f1 = $result[0];
$val_of_f2 = $result[1];
}
?>
|
|
|
