PHP实现的构造sql语句类实例

前端之家收集整理的这篇文章主要介绍了PHP实现的构造sql语句类实例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

本文实例讲述了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程序设计有所帮助。

原文链接:https://www.f2er.com/php/20416.html

猜你在找的PHP相关文章