if (strlen($section) <= 14) { echo str_repeat(' ',(18-3-strlen($section))); } else { " "; } echo "+"; $id=0; foreach ($dataref as $k => $v) { if ($id==0) { echo " $k=$v\n"; } else { echo "+ + $k=$v\n"; } $id++; } if ($id==0) { echo "\n"; } } echo "+-----------------+-------------------------------\n"; } echo "Affected rows : ".$aql->get_affected_rows()." (".round(($b2-$b1),3)." sec)\n"; echo "Filename : ".$aql->last_query_filename."\n\n"; } } // ------------+ //3 rows in set (0.00 sec) } ?>
<?php /* * This is Test demo script for AQL */ error_reporting(E_ALL); require "../inc/aql.php"; $a = new aql(); $setok = $a->set('basedir', './'); if (!$setok) { echo __LINE__ . ' ' . $a->get_error(); } $result = $a->query("insert into t15.conf set callerid=\"\\\"99\\\" <99>\",section='" . time() . "'"); if ($result == false) { echo $a->get_error(); } else { echo 'affected_rows :' . $a->get_affected_rows() . "\n"; }
<?php /* * This is Test demo script for AQL */ error_reporting(E_ALL); require "../inc/aql.php"; $a = new aql(); $setok = $a->set('basedir', './'); if (!$setok) { echo __LINE__ . ' ' . $a->get_error(); } $query = <<<EOF select * from big.conf EOF; $result = $a->query($query); if ($result == false) { echo $a->get_error(); } else { echo "benchmark to query data from big.conf\n"; echo "AQL LANGUAGE : {$query}\n"; echo 'record sections: ' . $a->get_affected_rows(); //print_r($result); }