php 构造SQL语句的类示例

内容摘要
这篇文章主要为大家详细介绍了php 构造SQL语句的类示例，具有一定的参考价值，可以用来参考一下。

php构造sql语句的类，对此感兴趣的朋友，看看idc笔记做的技术笔记。经测试代码如
文章正文

这篇文章主要为大家详细介绍了php 构造SQL语句的类示例，具有一定的参考价值，可以用来参考一下。

php构造sql语句的类，对此感兴趣的朋友，看看idc笔记做的技术笔记。经测试代码如下：
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<code class="php">
/**
 * @package Database Class
 * @version 1.0
 * @author php教程 www.idcnote.com
 **/
@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;
 }
}
 
 
/***   代码来自php教程（www.idcnote.com）   ***/</code>

注：关于php 构造SQL语句的类示例的内容就先介绍到这里，更多相关文章的可以留意

代码注释
上一篇PHP 在字符断点处截断文字的实现方法下一篇php 根据日期显示星座的解决办法

作者：喵哥笔记

IDC笔记

学的不仅是技术，更是梦想！