<?php /******************************************************************** Example file This example shows how to use the MyLibSQLGen class
The example is based on the following MySQL table:
CREATE TABLE customer ( id int(10) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', address varchar(60) NOT NULL default '', city varchar(60) NOT NULL default '', PRIMARY KEY (cust_id) ) TYPE=MyISAM;
********************************************************************/
require_once("class_mylib_SQLGen-1.0.php");
$fields=Array("name","address","city"); $values=Array("Fadjar","Resultmang Raya Street","Jakarta"); $tables=Array("customer");
echo "<b>Result Generate Insert</b><br>"; $object=new MyLibSQLGen(); $object->clear_all_assign(); //to refresh all property but it no need when first time execute $object->setFields($fields); $object->setValues($values); $object->setTables($tables);
if(!$object->getInsertSQL()){echo $object->Error;exit;} else{$sql=$object->Result;echo $sql."<br>";}
echo "<b>Result Generate Update</b><br>"; $fields=Array("name","address","city"); $values=Array("Fadjar","Resultmang Raya Street","Jakarta"); $tables=Array("customer"); $id=1; $conditions[0]["condition"]="id='$id'"; $conditions[0]["connection"]="";
$object->clear_all_assign(); $object->setFields($fields); $object->setValues($values); $object->setTables($tables); $object->setConditions($conditions);
if(!$object->getUpdateSQL()){echo $object->Error;exit;} else{$sql=$object->Result; echo $sql."<br>";}
echo "<b>Result Generate Delete</b><br>"; $tables=Array("customer"); $conditions[0]["condition"]="id='1'"; $conditions[0]["connection"]="OR"; $conditions[1]["condition"]="id='2'"; $conditions[1]["connection"]="OR"; $conditions[2]["condition"]="id='4'"; $conditions[2]["connection"]="";
$object->clear_all_assign(); $object->setTables($tables); $object->setConditions($conditions);
if(!$object->getDeleteSQL()){echo $object->Error;exit;} else{$sql=$object->Result; echo $sql."<br>";}
echo "<b>Result Generate List</b><br>"; $fields=Array("id","name","address","city"); $tables=Array("customer"); $id=1; $conditions[0]["condition"]="id='$id'"; $conditions[0]["connection"]="";
$object->clear_all_assign(); $object->setFields($fields); $object->setTables($tables); $object->setConditions($conditions);
if(!$object->getQuerySQL()){echo $object->Error;exit;} else{$sql=$object->Result; echo $sql."<br>";}
echo "<b>Result Generate List with search on all fields</b><br>"; $fields=Array("id","name","address","city"); $tables=Array("customer"); $id=1; $search="Fadjar Nurswanto"; $object->clear_all_assign(); $object->setFields($fields); $object->setTables($tables); $object->setSearch($search);
if(!$object->getQuerySQL()){echo $object->Error;exit;} else{$sql=$object->Result; echo $sql."<br>";}
echo "<b>Result Generate List with search on some fields</b><br>"; $fields=Array("id","name","address","city"); $tables=Array("customer"); $id=1; $search=Array( "name"=>"Fadjar Nurswanto", "address"=>"Tomang Raya" );
$object->clear_all_assign(); $object->setFields($fields); $object->setTables($tables); $object->setSearch($search);
if(!$object->getQuerySQL()){echo $object->Error;exit;} else{$sql=$object->Result; echo $sql."<br>";} ?>
|