这篇文章主要为大家展示了“PHP如何构造sql语句类”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“PHP如何构造sql语句类”这篇文章吧。
具体如下：
计算
安全
数据库
网络和加速
企业服务
/**
* @package Database Class
* @author injection (mail:injection.mail@gmail.com)
* @version 1.0
*/
@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_colum_list, $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如何构造sql语句类”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
