本文实例讲述了PHP实现的构造sql语句类。分享给大家供大家参考,具体如下:
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;
}
}
更多关于PHP相关内容感兴趣的读者可查看本站专题:《》、《》、《》及《》
希望本文所述对大家PHP程序设计有所帮助。