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]; } ?>
|
|
|