Location: PHPKode > scripts > MyLibSQLGen > mylibsqlgen/example.php
<?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>";}
?>
Return current item: MyLibSQLGen