Login   Register  
PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Fadjar Nurswanto  >  MyLibSQLGen  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: the class
Class: MyLibSQLGen
Build MySQL query statements from parameters
Author: By
Last change:
Date: 8 years ago
Size: 3,279 bytes
 

Contents

Class file image Download
<?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>";}
?>