Location: PHPKode > scripts > mysqlix > mysqlix/example.php
<?
	/**
	 * This file contain example how to use class mysqlix
	 */
?>
<html>
<body>
<?
	/**
	 * include class mysqlix
	 */
	include_once("mysqlix.class.php");
	
	/**
	 * Example #1 : Testing constructor mysqlix
	 * Look at class documentation to get information on optional paramaters
	 */
	echo "<p><b>Tes constructor mysqlix()</b> .... ";
	$con = new mysqlix(); //example of class contructor
	echo "</p>";
	
	/**
	 * Example #2 : Testing function drop_db
	 * Drop database specified in parameter of function drop_db()
	 */
	echo "<p><b>Tes functon drop_db()</b> ....";
	if($con->drop_db('test'))
		echo "success";
	else echo "failed";
	echo "</p>";
	
	/**
	 * Example #3 : Testing function create_db
	 * Create database with name specified in parameter of function create_db()
	 */
	echo "<p><b>Tes function create_db()</b> ...";
	if( $con->create_db('test') )
		echo "success";
	else echo "failed";
	echo "</p>";
	
	$con->select_db('test');
	
	/**
	 * Example #4 : Testing function drop_table
	 */
	echo "<p><b>Tes functon drop_table()</b> ....";
	if( $con->drop_table('hehe') && $con->drop_table('hoho'))
		echo "success";
	else echo "failed";
	echo "<br>";
	echo "<br>latest statement " . $con->statement . ", lates database $con->latestdb</p>";
	
	
	/**
	 * Example  : Testing function create_table, and add_column
	 * You can manipulate array column using function add_column
	 * In create_table, you define all parameter required
	 */
	echo "latest db : $con->latestdb<br>";
	echo "<p><b>Create tables</b>...<br>";
	$arrT = array();
	$arrT = $con->add_column($arrT, 'a', 'INT', null, false, true, true, null, 'this is integer a');
	$arrT = $con->add_column($arrT, 'b', 'VARCHAR', 22, true, false, false, 'gerogero');
	if( $con->create_tables('hehe',$arrT, 'This is comment of table 1') )
		echo "Create table 1 success...<br>";
	else
		echo "Create table 1 failed...<br>";
	echo "<br>latest statement " . $con->statement . "<br>";
	
	$arrT2 = array();
	$arrT2 = $con->add_column($arrT2, 'c', 'VARCHAR', 22, false, false, true, 'gero');
	$arrT2 = $con->add_column($arrT2, 'd', 'VARCHAR', 22, true, false, false, 'gerogero');
	if( $con->create_tables('hoho',$arrT2, 'This is comment of table 2') )
		echo "Create table 2 success...<br>";
	else
		echo "Create table 2 failed...<br>";
	echo "<br>latest statement " . $con->statement . "<br>";
	
	echo "</p>";
	
	/**
	 * Example #5 : Testing function create_trigger
	 * Creating trigger, for more information, read class documentation
	 */
	echo "<p><b>Tes function create_trigger()</b> ....";
	$arr = array("INSERT INTO `hehe` (`a`,`b`) VALUES ('dd','ss')");
	if( $con->create_trigger('triggerring','hoho',$arr,'BEFORE','UPDATE') )
		echo "Successfully creating trigger ";
	else
		echo "Creating trigger aborted. There was error(s)";
	echo "</p>";
	
	echo "latest statement " . $con->statement . "<br>";
	
	/**
	 * Example #6 : Testing function drop_trigger
	 * Drop a specified name trigger. I don't know why this trigger function can not contain IF EXISTS clause?
	 */
	echo "<p><b>Tes function drop_trigger()</b> ....";
	if( $con->drop_trigger('triggerring') )
		echo "success";
	else
		echo "failed";
	echo "</p>";
	
	/**
	 * Example #7 : Testing function table_comment
	 * Retrieve comment on a table whose name specified in the parameter of function table_comment()
	 * Actually, comment is exist on database information_schema
	 */
	echo "<p><b>Tes function table_comment()</b> ....";
	echo $con->table_comment('hehe');
	echo "<br>";
	
	/**
	 * Example #8 : Testing function table_comments
	 * Retrieve comment(s) of each table in a database whose name is specified in the parameter of function table_comments()
	 */
	echo "<p><b>Tes function table_comments()</b> ....";
	$rows = $con->table_comments('test');
	echo "<br>";
	foreach($rows as $tupple)
	{
		echo "$tupple[name] => $tupple[comment]";
		echo "<br>";
	}
	echo "</p>";
	
	/**
	 * Example #9 : Testing function secure_multi_query
	 * Secure your multi query (in array function's parameter) using combination of commit() and rollback()
	 */
	echo "<p><b>Tes function secure_multi_query()</b> ....";
	$arr = array("INSERT INTO `hehe` VALUES('hello','world')","INSERT INTO `hoho` VALUES('viva','php')");
	if($con->secure_multi_query($arr))
		echo "secure_multi_query successfully executed";
	else
		echo "There was error(s). But don't worry, the system has been rolled back";
	echo "</p>";
	echo "Latest statement " . $con->statement . "<br>";
	
	/**
	 * Example #10 : Testing function insert
	 */
	echo "<p><b>Tes function insert() ...";
	if( $con->insert('hehe', array('a' => 'gogo', 'b' =>'gigi')) )
		echo "Data successfully inserted <br>";
	else
		echo "Failed on insert <br>";
	echo "</p>";
	
	/**
	 * Example #11 : Testing function update
	 * Update database tupple
	 * Read class documentation to get more infor
	 */
	echo "<p><b>Tes function update()</b> ....";
	if( $con->update('hehe', array('b' =>'gigi'), array('a' => 'hello')) )
		echo "Data successfully updated <br>";
	else
		echo "Failed on update <br>";
	echo "</p>";

	/**
	 * Example #12 : Testing function select
	 * look at : array('a' => 'hello','b' => '')
	 * note : 'a' and 'b' is columns that you want to be retrieved,
	 * 'hello' is the value of column 'a' in where clause, because value of 'b' is '', so column 'b' doesn't included in where clause
	 */
	echo "<p><b>Tes function select()</b> ";
	//$con->query("use test");
	echo "<br>";
	$result = $con->select('hehe', array('a' => 'hello','b' => ''));
	echo $con->statement . "<br>";
	while($row = $result->fetch_row())
	{
		echo "$row[0] = $row[1]";
		echo "<br>";
	}
	echo "</p>";
	//here destructor will be called automatically
?>
</body>
</html>
Return current item: mysqlix