首页 / PHP / 一个构造sql语句的类

一个构造sql语句的类

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了一个构造sql语句的类，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3260字，纯文字阅读大概需要5分钟。

内容图文

<无详细内容>
  1. /**
  2. * @package Database Class
  3. * @author injection (mail:injection.mail@gmail.com)
  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:injection.mail@gmail.com)
  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. }

内容总结

以上是互联网集市为您收集整理的一个构造sql语句的类全部内容，希望文章能够帮你解决一个构造sql语句的类所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/161111.html

来源：【匿名】