<?php
include('class/connection.php');
function display($string,$title = false) {
if ($title)
echo "<br /><b>$string</b><br />";
else
echo "$string<br />";
}
$oTest = new DBConnect("test1");
/*delete query */
display("delete all the records",1);
$oTest->setQuery('delete from test_table');
if (!$oTest->hasError())
display("table test_table is empty");
else
display("error. table test_table couldn't be emptied");
$oTest->clearError();
/*new record */
display("new record",1);
$description = "desc test";
$test_date ="2004-04-02";
$lastId = $oTest->setQuery("insert into test_table (test_date,description) values ('%s','%s')",
$test_date,$description);
if ($lastId > 1)
display("record created. the id is ".$lastId);
else
display("error. Record not created");
$oTest->clearError();
/*wrong insert query: throwing an error without crashing and diying */
display("wrong insert query: throwing an error without crashing and diying",1);
$oTest->setQuery('insert dummyfield from test_table');
if ($oTest->hasError()) {
display($oTest->getError());
}
else
display("no mistake");
$oTest->clearError();
/*updating a record: no validation, supposed to be within another class, here the SQL must be ok */
display("updating record",1);
$description = "updated desc test";
$test_date ="2000-04-06";
$test_id = $lastId;
$oTest->setQuery("update test_table set test_date='%s', description='%s' where test_id=%d",$test_date,$description,$test_id);
if (!$oTest->hasError())
display("record $test_id updated");
else
display("error. Record $test_id not updated");
$oTest->clearError();
/*select query */
display("select record",1);
$data = $oTest->getRecord("select test_id, test_date,description from test_table where test_id=%d",$test_id);
echo "id ".$data->test_id."<br />";
echo "date ".$data->test_date."<br />";
echo "description ".$data->description."<br />";
/* create another record */
display("create another record",1);
$description = "desc of another record";
$test_date ="2000-10-01";
$oTest = new DBConnect("test1"); // optional, the MySQL connection will be reused
$lastId = $oTest->setQuery("insert into test_table (test_date,description) values ('%s','%s')",
$test_date,$description);
if ($lastId > 1)
display("record created. the id is ".$lastId);
else
display("error. Record not created.");
$oTest->clearError();
/*select a list of records */
display("select list of record",1);
$result = $oTest->getResult("select test_id, test_date,description from test_table");
$i = 1;
foreach ($result as $data) {
display("select $i eme record of the list",1);
display("id ".$data->test_id);
display("date ".$data->test_date);
display("description ".$data->description);
$i++;
}
$oTest->clearError();
/*wrong select query: throwing an error without crashing and diying */
display("wrong select query: throwing an error without crashing and diying",1);
$oTest->getRecord();
if ($oTest->hasError()) {
display($oTest->getError());
}
else
display("no mistake");
$oTest->clearError();
/*delete query */
display("delete a record",1);
$oTest->setQuery('delete from test_table where test_id=%d',$data->test_id);
if (!$oTest->hasError())
display("record {$data->test_id} deleted");
else
display("error. Record {$data->test_id} not deleted");
$oTest->clearError();
?>
|