动态网页技术PHP通过参数来生成MYSQL语句类

  这个类可以通过具有参数的数组来构建MySQL查询语句。
  这个类可以通过指定的表和字段参数创建SELECT ,INSERT , UPDATE 和 DELETE 语句。
  这个类可以创建SQL语句的WHERE条件，像LIKE的查询语句，使用LEFT JOIN和ORDER 语句。
  例子:

   <? 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 );

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:Flash：通过一个实例学习attachMovie的用法

下一篇:详细讲解关于MYSQL DUMP工具的使用技巧