PHP實(shí)現(xiàn)的構(gòu)造sql語句類實(shí)例
本文實(shí)例講述了PHP實(shí)現(xiàn)的構(gòu)造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; } }
更多關(guān)于PHP相關(guān)內(nèi)容感興趣的讀者可查看本站專題:《php+mysql數(shù)據(jù)庫(kù)操作入門教程》、《php防止SQL注入方法總結(jié)》、《PHP基于pdo操作數(shù)據(jù)庫(kù)技巧總結(jié)》及《php常見數(shù)據(jù)庫(kù)操作技巧匯總》
希望本文所述對(duì)大家PHP程序設(shè)計(jì)有所幫助。
相關(guān)文章
Laravel快速入門之composer介紹及安裝詳細(xì)圖文步驟
這篇文章主要介紹了Laravel快速入門之composer 介紹以及安裝詳細(xì)圖文步驟,圖文步驟講解的很清楚,有對(duì)這方面不懂的同學(xué)可以研究下2021-01-01PHP排序算法之基數(shù)排序(Radix Sort)實(shí)例詳解
這篇文章主要介紹了PHP排序算法之基數(shù)排序(Radix Sort),結(jié)合實(shí)例形式詳細(xì)分析了php基數(shù)排序算法的原理、實(shí)現(xiàn)方法與相關(guān)使用技巧,需要的朋友可以參考下2018-04-04php數(shù)值轉(zhuǎn)換時(shí)間及時(shí)間轉(zhuǎn)換數(shù)值用法示例
這篇文章主要介紹了php數(shù)值轉(zhuǎn)換時(shí)間及時(shí)間轉(zhuǎn)換數(shù)值用法,涉及php strtotime及date等函數(shù)實(shí)現(xiàn)日期的字符串格式與Unix時(shí)間戳格式轉(zhuǎn)換相關(guān)操作技巧,需要的朋友可以參考下2017-05-05關(guān)于PHP堆棧與列隊(duì)的學(xué)習(xí)
本篇文章是對(duì)PHP中的堆棧與列隊(duì)進(jìn)行了詳細(xì)的分析介紹,需要的朋友參考下2013-06-06