php 构造SQL语句的类示例

前端之家收集整理的这篇文章主要介绍了php 构造SQL语句的类示例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
PHP构造sql语句的类,感兴趣的小伙伴,下面一起跟随编程之家 jb51.cc的小编来看看吧。
经测试代码如下:

/**
 * @package Database Class
 * @version 1.0
 * @author 编程之家 jb51.cc jb51.cc
 **/
@ini_set( 'display_errors',0 );
class DataBase{
 private $mDb_host,$mAb_user,$mAb_pwd,$mConn_No;
 
 function DataBase( $Conn_Obj ){
  $this->connectDb( $Conn_Obj );
 }
 
 function connectDb( $Conn_Obj ){
  $this->mDb_host = $Conn_Obj->host;
  $this->mAd_name = $Conn_Obj->user;
  $this->mAd_pwd = $Conn_Obj->pwd;
  $this->mConn_No = MysqL_connect( $this->mDb_host,$this->mAd_name,$this->mAd_pwd );
 }
 
 function selectDb( $Conn_Obj ){
  $this->mDb_name = $Conn_Obj->dbname;
  MysqL_select_db( $this->mDb_name );
 }
}
/**
* @package Making sqls Class exetends Database Class
* @author injection (mail:injection.mail@gmail.com)
* @version 1.0
*/
class Makesql extends DataBase{
 private $msql;
 function Makesql( $type,$arr_colum_list,$arr_sql_choice ){
   $this->MakesqlType( $arr_colum_list,$arr_sql_choice );
 }
 
 #switch make list
 function MakesqlType( $type,$arr_sql_choice ){
  switch( $type ){
   case 'insert':
    return $this->makeInsert(  $arr_colum_list,$arr_sql_choice );
   case 'select':
    return $this->makeSelect(  $arr_colum_list,$arr_sql_choice );
   case 'update':
    return $this->makeUpdate(  $arr_colum_list,$arr_sql_choice );
   case 'delete':
    return $this->makeDelete(  $arr_colum_list,$arr_sql_choice );
  }
 }
 
 #make insert
 function makeInsert( $arr_colum_list,$arr_sql_choice ){
  $colum_key = array_keys( $arr_colum_list );
  $colum_value = array_values( $arr_colum_list );
  $this->msql = "INSERT INTO ".$arr_sql_choice["tbl_name"]."( ".join( ',',$colum_key )." ) VALUES( '".join( "','",$colum_value )."')";
  return $this->msql;
 }
 
 #making select
 function makeSelect( $arr_colum_list = '*',$arr_sql_choice ){
  $colum_value = array_keys( $arr_colum_list );
   
  foreach( $arr_sql_choice as $sql_key => $sql_value ){
   if( strcmp( $sql_key,'tbl_name' ) == 0 ){
    if( strcmp($arr_colum_list,'*' ) !== 0 )
     $this->msql = "SELECT ".join( ',$colum_value )." FROM ".$sql_value;
    else
     $this->msql = "SELECT * FROM ".$sql_value;
   }
   else
    if( strcmp( $sql_value,'' ) !== 0 )
     if(strcmp( $sql_key,'WHERE' ) === 0 && strcmp( $sql_value,'colum' ) === 0 ){
      foreach($arr_colum_list As $colum_key => $colum_value )
       $this->msql .= "$colum_key = '$colum_value' AND ";
     $this->msql = rtrim( $this->msql," AND " );
     }
     else
     $this->msql .= " $sql_key ".$sql_value;
  }
  return $this->msql; 
 }
 
 #making update 
 function makeUpdate( $arr_colum_list,$arr_sql_choice ){
  $this->msql = "UPDATE ".$arr_sql_choice['tbl_name']." SET ";
  foreach( $arr_colum_list as $colum_key => $colum_value )
   $this->msql .= "$colum_key = '$colum_value',";
  $this->msql = rtrim( $this->msql,');
  foreach( $arr_sql_choice as $sql_key => $sql_value ){
   if( strcmp( $sql_value,'' ) !== 0 && strcmp( $sql_key,'tbl_name' ) !==0 && strcmp( $sql_key,'ORDER BY' ) !== 0 )
     $this->msql .= " $sql_key ".$sql_value;
  }
  return $this->msql;
 }
 
 #making delete
 function makeDelete( $arr_colum_list,$arr_sql_choice ){
  $this->msql = "DELETE FROM ".$arr_sql_choice['tbl_name'];
  foreach( $arr_sql_choice as $sql_key => $sql_value ){
   if( strcmp( $sql_key,'tbl_name' ) !== 0 && strcmp( $sql_value,'' ) !== 0 ){
    $this->msql .= " $sql_key ".$sql_value;
   }
  }
  return $this->msql;
 }
}


/***   代码来自编程之家 jb51.cc(jb51.cc)   ***/

猜你在找的PHP相关文章