Location: PHPKode > scripts > DBConnect > dbconnect/example.php
<?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();

?>
Return current item: DBConnect