简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Backend Development> PHP Tutorial> body text

PHP PDO encapsulated static class code sharing

WBOY
Release： 2016-07-25 08:51:51
Original
1302 people have browsed it
  2. /**
  3. * Class DB
  4. * Database operation class
  5. */
  6. class DB {
  7. /**
  8. * @var
  9. * @return CDB
  10. */
  11. private static $db;
  12. /**Get CDb class
  13. * @param $table_name table name
  14. * @param string $db_setting call database configuration item
  15. * @param array $db_config database configuration
  16. * @return CDb
  17. */
  18. public static function cdb($table_name='',$db_setting='default',$db_config=array()){
  19. if(!isset(self::$db)){
  20. $db = new CDb($table_name,$db_setting, $db_config);
  21. self::$db=$db;
  22. }else{
  23. $db=self::$db;
  24. }
  25. return $db;
  26. }
  27. /**Configuration
  28. * @param $table_name table name
  29. * @param string $db_setting Call database configuration item
  30. * @param array $db_config database configuration
  31. * @return CDb
  32. */
  33. public static function init($table_name='',$db_setting='default',$db_config=array()) {
  34. return self::cdb($table_name,$db_setting,$db_config);
  35. }
  36. /**
  37. * Execute deletion record operation
  38. * @param $table table name
  39. * @param $condition Delete data condition, not allowed to be empty. Can be an array
  40. * @return boolean
  41. * /
  42. public static function delete($table, $condition) {
  43. $db=self::cdb();
  44. $db->setTableName($table);
  45. return $db->delete($condition);
  46. }
  47. /**
  48. * Execute adding record operation
  49. * @param $table table name
  50. * @param array $data The data to be added, the parameter is an array.The array key is the field value, and the array value is the data value
  51. * @param bool $return_insert_id Whether to return the new ID number
  52. * @param bool $replace Whether to add data by replace into
  53. * @return boolean
  54. */
  55. public static function insert($table, $data, $return_insert_id = false, $replace = false) {
  56. $db=self::cdb();
  57. $db->setTableName($table);
  58. return $db-> insert($data, $return_insert_id, $replace);
  59. }
  60. /**
  61. * Get the primary key number of the last added record
  62. * @return int
  63. */
  64. public static function insertID() {
  65. $db=self::cdb();
  66. return $db->insert_id ();
  67. }
  68. /**
  69. * Execute update record operation
  70. * @param $table table name
  71. * @param $data The data content to be updated, the parameter is an array
  72. * When it is an array, the array key is the field value, and the array value is the data value
  73. * When it is an array [Example: array('name'=>'lanmps','password'=>'123456')]
  74. * Another way to use array array('name'=>'+=1', ' base'=>'-=1');The program will automatically parse as `name` = `name` + 1, `base` = `base` - 1
  75. * string, please follow the format:
  76. * string[ Example 2: array('catid=:catid AND time>=:time ',array(':catid'=>10,':time'=>'2012-02-10')) ]
  77. * @param $where conditions for updating data,
  78. * string, please follow the format:
  79. * string [Example 1: " id=1 and time>$time " ]
  80. * string [Example 2: array('catid=: catid AND time>=:time ',array(':catid'=>10,':time'=>'2012-02-10')) ]
  81. * Array [Example: array('name'= >'lanmps','password'=>'123456')]
  82. * @return boolean
  83. */ bbs.it-home.org
  84. public static function update($table, $data, $where) {
  85. $db=self::cdb();
  86. $ db->setTableName($table);
  87. return $db->update($data,$where);
  88. }
  89. /**
  90. * Get single record query
  91. * @param array $sql query condition statement
  92. * @return array/null data query result set, if it does not exist, return empty
  93. */
  94. public static function fetchFirst($sql) {
  95. $db =self::cdb();
  96. return $db->fetch($sql);
  97. }
  98. /**
  99. * Execute sql query
  100. * @param $sql query conditions
  101. * @return array Query result set array
  102. */
  103. public static function fetchAll($sql) {
  104. $db=self::cdb ();
  105. return $db->fetchAll($sql);
  106. }
  107. /**
  108. * Directly execute sql query
  109. * @param $sql Query sql statement
  110. * @return
  111. */
  112. public static function query($sql) {
  113. $db=self::cdb();
  114. return $db->exec($sql);
  115. }
  116. /**
  117. * Execute sql query
  118. * @param $table table name
  119. * @param $where query condition
  120. * String, please follow the format:
  121. * String [Example 1: " id=1 and time>$time " ]
  122. * String [Example 2: array('catid=:catid AND time>=:time ',array(':catid'=>10,':time'=>'2012-02-10')) ]
  123. * Array [Example: array('name'=>'lanmps','password'=>'123456')]
  124. * @param $fields Field values to be queried [Example `name`, `gender` ,`birthday`]
  125. * @param $limit Return result range [Example: 10 or 10,10 is empty by default]
  126. * @param $order Sorting method [Default is sorted by the database default method]
  127. * @param $group Grouping method [Default is empty]
  128. * @return array Query result set array
  129. */
  130. public static function select($table,$where = '', $fields = '*', $limit = '', $order = '', $group = '') {
  131. $db=self::cdb();
  132. $db->setTableName($table);
  133. return $db->select($where , $fields , $limit, $order, $group);
  134. }
  135. /**
  136. * Get single record query
  137. * @param $table table name
  138. * @param array $where query conditional statement
  139. * String, please follow the format:
  140. * String [Example 2: array('catid=:catid AND time> ;=:time ',array(':catid'=>10,':time'=>'2012-02-10')) ]
  141. * Array [Example: array('name'=>' lanmps','password'=>'123456')]
  142. * @param string $fields Field values to be queried [eg `name`,`gender`,`birthday`]
  143. * @param string $order Sorting method[ The default is to sort according to the database default method]
  144. * @param string $group grouping method [default is empty]
  145. * @return array/null data query result set, if it does not exist, return empty
  146. */
  147. public static function getOne($table,$where,$fields = '*', $order = '', $group = '') {
  148. $db=self::cdb();
  149. $db->setTableName($table);
  150. return $db->get_one($where , $fields,$order, $group);
  151. }
  152. /**
  153. * Query multiple pieces of data and paginate
  154. * @param $table table name
  155. * @param $where query conditions
  156. * String, please follow the format:
  157. * String [Example 1: " id=1 and time>$time " ]
  158. * String [Example 2: array('catid=:catid AND time>=:time ',array(':catid'=>10,':time'=>'2012-02-10' )) ]
  159. * Array [Example: array('name'=>'lanmps','password'=>'123456')]
  160. * @param $fields field*,id
  161. * @param $order sort id desc ,orderlist asc
  162. * @param $page page number 1
  163. * @param $pagesize number of items per page
  164. * @return array('data'=>data,'count'=>total number of records)
  165. */
  166. public static function listInfo($table,$where = '',$fields='*', $order = '', $page = 1, $pagesize = 20) {
  167. $db=self::cdb();
  168. $db->setTableName($table);
  169. $d=$db->listinfo($where,$fields, $order, $page, $pagesize);
  170. return array('data'=>$d,'count'=>self::$db->number);
  171. }
  172. /**First parameter value
  173. * @param $sql
  174. * @return mixed
  175. */
  176. public static function resultFirst($sql){
  177. $db=self::cdb();
  178. return $db->resultFirst($sql);
  179. }
  180. }
复制代码

调用方法：

DB::insert('test',array('name'=>'test'));


Related labels：
PHP PDO封装静态类代码分享
source：php.cn
Previous article：PHP watermark code, PHP translucent watermark supports png transparent background Next article：IT tutorial sharing~! PHP/Linux/html/JS/mobile game development/MySQL/etc. tutorials
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Preview of the teaching course on September 10, 2018: How to implement paging query data table and classification query for class encapsulation in PHP Preview of the teaching content of the third online class of PHP Chinese website on Septem...
From 2018-09-10 10:02:37
0
0
1043
php - 谁能分享一个封装好的PDO链接SQL server的类？ 万分感谢！！！
From 2017-04-10 15:41:04
0
2
177
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！