Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > MySQL add, delete, modify, query tool PHP class

MySQL add, delete, modify, query tool PHP class

WBOY
Release： 2016-07-25 08:43:37
Original
1150 people have browsed it
  1. In the past, the development project did not use a framework, and it was a very practical mysql tool class that was directly developed as object-oriented.
  3. header("content-type:text/html;charset=utf-8");
  4. class DBUtils{
  7. /**
  8. *General update method insert update delete operation
  9. *@param sql
  10. *@return bool true false
  11. */
  12. public function update($sql){
  13. $link = $this->getConn();
  14. mysql_query($sql);
  15. //If an error occurs
  16. if(DEBUG){
  17. echo mysql_error();
  18. }
  19. $rs = mysql_affected_rows($link);
  20. $rs = $rs > 0;
  21. mysql_close($link);
  22. return $rs;
  23. }
  25. /**
  26. *General query method select operation
  27. *@param sql
  28. *@return array
  29. */
  30. public function queryRows($sql){
  31. //Create connection, encoding , database
  32. $link = $this->getConn();
  33. //Send sql
  34. $rs = mysql_query($sql);
  35. //If an error occurs
  36. if(DEBUG){
  37. echo mysql_error();
  38. }
  41. $rows = array();
  42. while($row = mysql_fetch_array($rs)){
  43. $rows[] = $row;//pdemo7.php
  44. }
  45. //
  46. mysql_free_result($rs);
  47. mysql_close($link);
  48. return $rows;
  49. }
  52. /**
  53. *General query method select operation query result one row of data
  54. *@param sql
  55. *@return array Return false if failed;
  56. */
  57. public function queryRow($sql){
  58. $rs = $this->queryRows($sql);
  59. if (!empty($rs[0])){
  60. return $rs[0];
  61. }
  62. return false;
  63. }
  65. /**
  66. *General query method select operation Query result is one data
  67. *@param sql
  68. *@return array Return false if failed;
  69. * Example: select count(*) from user;
  70. */
  71. public function queryObj($sql){
  72. $rs = $this->queryRows($sql);
  73. //var_dump($rs);
  74. if(!empty($rs[0][0])){
  75. return $rs[0][0];
  76. }
  77. return false;
  78. }
  81. private function getConn(){
  82. $link = mysql_connect('127.0.0.1','root','');
  83. mysql_query("set names utf8");
  84. mysql_select_db(" news");
  85. return $link;
  86. }
  88. }
Copy code

MySQL, PHP


Related labels：
MySQL增删改查工具PHP类
source：php.cn
Previous article：Implement a function that can return multiple values ​​in php Next article：Best Practices Series - Talking about PHP components, frameworks, and Composer
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
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2308
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2437
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2057
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1941
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2006
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