一个构造sql语句的类

1. /**
2. * @package Database Class
3. * @author injection (mail:[e-mail])
4. * @version 1.0
5. */
7. @ini_set( 'display_errors',0 );
8. class DataBase{
9. private $mDb_host,$mAb_user,$mAb_pwd,$mConn_No;
11. function DataBase( $Conn_Obj ){
12. $this->connectDb( $Conn_Obj );
13. }
15. function connectDb( $Conn_Obj ){
16. $this->mDb_host = $Conn_Obj->host;
17. $this->mAd_name = $Conn_Obj->user;
18. $this->mAd_pwd = $Conn_Obj->pwd;
19. $this->mConn_No = mysql_connect( $this->mDb_host, $this->mAd_name, $this->mAd_pwd );
20. }
22. function selectDb( $Conn_Obj ){
23. $this->mDb_name = $Conn_Obj->dbname;
24. mysql_select_db( $this->mDb_name );
25. }
26. }
28. /**
29. * @package Making Sqls Class exetends Database Class
30. * @author injection (mail:[e-mail])
31. * @version 1.0
32. */
33. class MakeSql extends DataBase{
34. private $mSql;
35. function MakeSql( $type,$arr_colum_list, $arr_sql_choice ){
36. $this->MakeSqlType( $arr_colum_list, $arr_sql_choice );
37. }
39. #switch make list
40. function MakeSqlType( $type, $arr_colum_list, $arr_sql_choice ){
41. switch( $type ){
42. case 'insert':
43. return $this->makeInsert( $arr_colum_list, $arr_sql_choice );
44. case 'select':
45. return $this->makeSelect( $arr_colum_list, $arr_sql_choice );
46. case 'update':
47. return $this->makeUpdate( $arr_colum_list, $arr_sql_choice );
48. case 'delete':
49. return $this->makeDelete( $arr_colum_list, $arr_sql_choice );
50. }
51. }
53. #make insert
54. function makeInsert( $arr_colum_list,$arr_sql_choice ){
55. $colum_key = array_keys( $arr_colum_list );
56. $colum_value = array_values( $arr_colum_list );
57. $this->mSql = "INSERT INTO ".$arr_sql_choice["tbl_name"]."( ".join( ',' , $colum_key )." ) VALUES( '".join( "','" , $colum_value )."')";
58. return $this->mSql;
59. }
61. #making select
62. function makeSelect( $arr_colum_list = '*' , $arr_sql_choice ){
63. $colum_value = array_keys( $arr_colum_list );
65. foreach( $arr_sql_choice as $sql_key => $sql_value ){
66. if( strcmp( $sql_key, 'tbl_name' ) == 0 ){
67. if( strcmp($arr_colum_list, '*' ) !== 0 )
68. $this->mSql = "SELECT ".join( ',' , $colum_value )." FROM ".$sql_value;
69. else
70. $this->mSql = "SELECT * FROM ".$sql_value;
71. }
72. else
73. if( strcmp( $sql_value, '' ) !== 0 )
74. if(strcmp( $sql_key, 'WHERE' ) === 0 && strcmp( $sql_value, 'colum' ) === 0 ){
75. foreach($arr_colum_list As $colum_key => $colum_value )
76. $this->mSql .= "$colum_key = '$colum_value' AND ";
77. $this->mSql = rtrim( $this->mSql, " AND " );
78. }
79. else
80. $this->mSql .= " $sql_key ".$sql_value;
81. }
82. return $this->mSql;
83. }
85. #making update
86. function makeUpdate( $arr_colum_list, $arr_sql_choice ){
87. $this->mSql = "UPDATE ".$arr_sql_choice['tbl_name']." SET ";
88. foreach( $arr_colum_list as $colum_key => $colum_value )
89. $this->mSql .= "$colum_key = '$colum_value',";
90. $this->mSql = rtrim( $this->mSql , ',');
91. foreach( $arr_sql_choice as $sql_key => $sql_value ){
92. if( strcmp( $sql_value, '' ) !== 0 && strcmp( $sql_key, 'tbl_name' ) !==0 && strcmp( $sql_key, 'ORDER BY' ) !== 0 )
93. $this->mSql .= " $sql_key ".$sql_value;
94. }
95. return $this->mSql;
96. }
98. #making delete
99. function makeDelete( $arr_colum_list, $arr_sql_choice ){
100. $this->mSql = "DELETE FROM ".$arr_sql_choice['tbl_name'];
101. foreach( $arr_sql_choice as $sql_key => $sql_value ){
102. if( strcmp( $sql_key, 'tbl_name' ) !== 0 && strcmp( $sql_value, '' ) !== 0 ){
103. $this->mSql .= " $sql_key ".$sql_value;
104. }
105. }
106. return $this->mSql;
107. }
108. }

复制代码