Location: PHPKode > scripts > OoMySql > testcenter.php
<?
// some examples....
require_once("init.inc.php");
// create a new sql object
$sql = new MySql("dbhost","dbuser","dbpass",true);
// get some info on mysql server
$server_info = $sql->getServerInfo();
// create a database and receive databaseObj
$dbObject = $sql->createDB('testDatabase');
// and get a list of databases
$result = $sql->listDBs();
while ($row = mysql_fetch_row($result)) {
        print "Database: $row[0]<br>\n";
 }
print "------------------------------------------<br>\n";
// drop this newly created table
$dbObject->drop();
// and get a list of databases
$result = $sql->listDBs();
while ($row = mysql_fetch_row($result)) {
        print "Database: $row[0]<br>\n";
 }
print "------------------------------------------<br>\n";
// select a database
$dbObject = $sql->selectDB("anotherDB");
// and get a list of tables in this DB
$result = $dbObject->listTables();
while ($row = mysql_fetch_row($result)) {
        print "Table in ".$dbObject->getName().": $row[0]<br>\n";
 }
 print "------------------------------------------<br>\n";
 //	and create a table object linked to this DB table
 $tableObj = $dbObject->selectTable("someTable");
 // turn debug messages for queries to this table on
 $tableObj->debug= true;
 // insert a value
 $result = $tableObj->insert("someColumn","'someString'");
 // get some meta infos
 print "AffectedRows:".$tableObj->getAffectedRows()."<br>\n";
 // get all data in this table
 $result = $tableObj->select("*");
 // and print out number of hits
 print "NumRows:".$tableObj->getNumRows()."<br>\n";
?>
Return current item: OoMySql