Location: PHPKode > scripts > DBMaster > dbmaster/dbmasterExample.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<TITLE>DBMaster Test</TITLE>
<!-- Will be used in makeTable -->
<style>
th {
	background: blue;
	color: white;
	font-family: Verdana,Arial;
}
.odd {
	background: #EEDDDD;
	font-family: Verdana,Arial;
}
.even {
	background: #DDDDEE;
	font-family: Verdana,Arial;
}
</style>
</HEAD>
<BODY>
<?
//The first form to configure your DBMaster instace is through defines
define('DBMASTER_DB','myDB');				//Database to be selected is 'myDB'
define('DBMASTER_DEBUG',1);					//Set debug mode ON
define('DBMASTER_REDIRECT','error.html');	//Redirects to 'error.html' on error

include('dbmaster.php'); 					//Includes the class file

$db = new DBMaster(); 						//Create a DBMaster instance

//You can also configure it by simply changing its properties
$db->logfile = 'myLogFile.txt';				//Logs queries to 'myLogFile.txt'
$db->mailto = 'hide@address.com';				//Send errors to 'hide@address.com'

$db->listTables();							//Stores list of tables from 'myDB'
echo $db->makeTable('','','','even','odd');	//Outputs a html table with different classes for even and odd rows (from above CSS)
$db->listFields('myTable');					//Stores fields from 'myTable'
echo $db->makeTable('','','','even','odd'); //Outputs a html table...
echo $db->dump(true);						//Outputs SQL CREATE script for tables in 'myDB'
$db->dumpToFile('myDump.txt');				//Outputs SQL CREATE script for tables in 'myDB' to 'myDump.txt'
$db->select('MyTable','My_Field');			//'SELECT My_Field FROM MyTable'
echo $db->makeList();						//List values from last query
?>
</BODY>
</HTML>
Return current item: DBMaster