PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Anton Rifco   mysqlix   example.php   Download  
File: example.php
Role: Example script
Content type: text/plain
Description: example how to use mysqlix class
Class: mysqlix
Manage MySQL database tables
Author: By
Last change:
Date: 16 years ago
Size: 5,881 bytes
 

Contents

Class file image Download
<?
   
/**
     * 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>