脚本宝典收集整理的这篇文章主要介绍了PHP实现的通过参数生成MYSQL语句类完整实例,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
本文实例讲述了PHP实现的通过参数生成MysqL语句类。分享给大家供大家参考,具体如下:
这个类可以通过指定的表和字段参数创建SELECT,INSERT,UPDATE 和 DELETE 语句。
这个类可以创建sql语句的WHERE条件,像LIKE的查询语句,使用LEFT JOIN和ORDER 语句
<
PRe class="
brush:
PHp;">
<>
PHP
/* *******************************************************************
Ex
ample file
This example shows how to use the MyLib
sqlGen class
The example is based on the following
MysqL table:
CREATE TABLE customer (
id int(10) unsigned NOT NULL auto_increment,name v
Archar(60) NOT NULL default '',address
VARchar(60) NOT NULL default '',c
ITy varchar(60) NOT NULL default '',
Primary KEY (cust_id)
) TY
PE=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 "
Result Generate Insert " ;
$object = new MyLib
sqlGen();
$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 -> getInsert
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
echo "
Result Generate Update " ;
$fields = Array ( " name "," 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 -> getUpdate
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
echo "
Result Generate Delete " ;
$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 -> getDelete
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
echo "
Result Generate List " ;
$fields = Array ( " id "," name "," 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 -> getQuery
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
echo "
Result Generate List with search on all fields " ;
$fields = Array ( " id "," city " );
$tables = Array ( " customer " );
$id = 1 ;
$search = " Fadjar Nurswanto " ;
$object -> clear_all_assign();
$object -> setFields( $fields );
$object -> setTables( $tables );
$object -> setSearch( $search );
if ( ! $object -> getQuery
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
echo "
Result Generate List with search on some fields " ;
$fields = Array ( " id "," 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 -> getQuery
sql()){ echo $object -> Error; exit ;}
else { $
sql = $object -> Result; echo $
sql . "
" ;}
?>
脚本宝典总结
以上是脚本宝典为你收集整理的PHP实现的通过参数生成MYSQL语句类完整实例全部内容,希望文章能够帮你解决PHP实现的通过参数生成MYSQL语句类完整实例所遇到的问题。
如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。