2678777127 发表于 2018-2-11 12:12:56


            本文实例讲述了PHP实现的通过参数生成MYSQL语句类。分享给大家供大家参考,具体如下:
这个类可以通过指定的表和字段参数创建SELECT ,INSERT , UPDATE 和 DELETE 语句。
这个类可以创建SQL语句的WHERE条件,像LIKE的查询语句,使用LEFT JOIN和ORDER 语句
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 . "
" ;}
echo" Result Generate Update
" ;
$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 . "
" ;}
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 -> getDeleteSQL()){ echo$object -> Error; exit ;}
else { $sql = $object -> Result; echo$sql . "
" ;}
echo" Result Generate List
" ;
$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 . "
" ;}
echo" Result Generate List with search on all fields
" ;
$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 . "
" ;}
echo" Result Generate List with search on some fields
" ;
$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 . "
" ;}
?>
页: [1]
查看完整版本: PHP实现的通过参数生成MYSQL语句类完整实例