PHP实现的构造sql语句类实例
发布:smiling 来源: PHP粉丝网 添加日期:2021-07-08 09:18:54 浏览: 评论:0
这篇文章主要介绍了PHP实现的构造sql语句类,结合实例形式分析了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;
- }
- }
Tags: 构造sql语句
- 上一篇:PHP快速生成各种信息提示框的方法
- 下一篇:PHP简单处理表单输入的特殊字符的方法
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)