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);
}
