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变量的引用赋值与传值赋值的详细介绍（代码