PHP實現的構造sql語句類實例

2020-03-24 18:57:25

字體：大中小

來源：轉載

供稿：網友

$this- mAd_pwd = $Conn_Obj- $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.0html' target='_blank'>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相關內容感興趣的讀者可查看本站專題：《php+mysql數據庫操作入門教程》、《php防止SQL注入方法總結》、《PHP基于pdo操作數據庫技巧總結》及《php常見數據庫操作技巧匯總》希望本文所述對大家PHP程序設計有所幫助。PHP教程

鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。

上一篇：php將時間差轉換為字符串的實現

下一篇：php變量的引用賦值與傳值賦值的詳細介紹（代碼