[Mysql数据库] php连mysql的工具类

最新推荐文章于 2021-03-11 16:01:09 发布

慕斯筱婕

最新推荐文章于 2021-03-11 16:01:09 发布

阅读量225

点赞数

本文链接：https://blog.csdn.net/zhuqihe02/article/details/50015951

版权

<?php
1. 1. <?php
    http://www.kmnk01.com/hxpfk/2015/jq_1124/96.html
  4. class mysql {
  6. private $defaultDB = null;
  7. private $link = null;
  8. private $sql = null;
  9. private $bindValue = null;
  10. public $num_rows = 0;
    http://www.kmnk01.com/hxpfk/2015/jq_1124/97.html
  11. public $affected_rows = 0;
  12. public $insert_id = 0;
  13. public $queries = 0;
  15. public function __construct() {
  17. if(func_num_args()) {
  18. $argv = func_get_arg(0);
  19. if(!empty($argv) && is_array($argv)) {
  20. $this->connect($argv);
    http://www.kmnk01.com/hxpfk/2015/jc_1124/98.html
  21. $argv['charset'] = isset($argv['charset']) ? $argv['charset'] : 'utf8';
  22. $this->setCharset($argv['charset']);
  23. }
  24. }
  26. }
  28. public function connect($argv, $charset = null) {
  30. if($this->link) return false;
  31. $argv = func_get_arg(0);
  32. $argv['port'] = isset($argv['port']) ? $argv['port'] : 3306;
  33. $this->link = mysqli_connect( $argv['host'], $argv['user'], $argv['password'], $argv['database'], $argv['port']);
  34. if(mysqli_connect_errno()) { echo mysqli_connect_error(); exit(0); }
  35. $this->defaultDB = $argv['database'];
  37. if($charset)
  38. $this->setCharset($charset);
  39. }
    http://www.kmnk01.com/hxpfk/2015/hzj_1124/99.html
  41. public function selectDB($database){
  43. $int = mysqli_select_db($this->link, $database);
  44. if($int) $this->defaultDB = $database;
  45. return $int;
  47. }
  49. public function query($sql) {
  51. $result = mysqli_query($this->link, $sql);
  52. if(mysqli_errno($this->link)) { echo mysqli_error($this->link); exit(0); }
  54. $this->queries++;
  56. if(preg_match('/^use\\s+(\\w+)/', $sql, $matches)) list($range, $this->defaultDB) = $matches;
  58. $pattern = array('read'=> '/(?<=select|show)(.+)$/i', 'write'=> '/(?<=alter|use|replace|insert|update|delete)(.+)$/i');
  59. if(preg_match($pattern['write'], $sql)) {
  60. $this->affected_rows = mysqli_affected_rows($this->link);
  61. }else{
  62. $this->num_rows = mysqli_num_rows($result);
  63. }
  64. http://www.kmnk01.com/hxpfk/2015/jq_1124/100.html
  65. if(preg_match('/^insert(.+)$/i', $sql)) {
  66. $this->insert_id = mysqli_insert_id($this->link);
  67. }
  69. return $result;
  71. }
  73. public function find($sql) {
  75. $collection = array();
  76. $result = $this->query($sql);
  77. while($rows = mysqli_fetch_assoc($result))
  78. array_push($collection, $rows);
  79. mysqli_free_result($result);
  80. return $collection;
  82. }
  84. public function findOne($sql) {
  86. $result = $this->query($sql);
  87. $rows = mysqli_fetch_assoc($result);
  88. mysqli_free_result($result);
  89. return $rows;
  91. }
  92. http://www.kmnk01.com/hxpfk/2015/bt_1123/92.html
  93. public function setCharset($charset) {
  95. return mysqli_set_charset($this->link, $charset);
  97. }
  99. public function prepare($sql) {
  101. $this->sql = $sql;
  103. }
  105. public function bindValue($search, $value) {
  107. $this->bindValue = array();
  108. $this->bindValue[$search] = $value;
  110. }
  112. public function execute() {
  114. if(func_num_args()) {
  115. $argv = func_get_arg(0);
  116. if(!empty($argv) && is_array($argv)) {
  117. if(!is_array($this->bindValue)) $this->bindValue = array();
  118. $this->bindValue = array_merge($this->bindValue, $argv);
  119. }
  120. }
  122. if($this->bindValue) {
  123. foreach($this->bindValue as $search => $value) {
  124. $this->sql = str_replace($search, $this->escape($value), $this->sql);
  125. }
  126. $this->bindValue = null;
  127. }
  129. $int = $this->query($this->sql);
  130. //$this->sql = null;
  131. return (boolean) $int;
  132. }
  135. public function escape($string) {
  137. return mysqli_real_escape_string($this->link, $string);
  139. }
  141. public function close() {
  142. http://www.kmnk01.com/hxpfk/2015/jq_1124/102.html
  143. return mysqli_close($this->link);
  145. }
  147. public function ping() {
  149. return mysqli_ping($this->link);
  151. }
  153. public function autoCommit($boolean) {
  155. return mysqli_autocommit($this->link, $boolean);
  157. }
  159. public function commit() {
  161. return mysqli_commit($this->link);
  163. }
  165. public function rollback() {
  167. return mysqli_rollback($this->link);
  169. }
  171. public function __destruct() {
  173. if($this->link) $this->close();
  174. unset($this->link, $this->defaultDB, $this->bindValue, $this->sql, $this->result, $this->num_rows, $this->affected_rows, $this->insert_id);
  176. }
  178. }
  181. $argv = array(
  182. 'host' => 'localhost',
  183. 'user' => 'root',
  184. 'password' => '',
  185. 'port' => 3306,
  186. 'database' => 'test',
  187. 'charset'=> 'utf8');
  190. // Using the "mysql::__construct" method to connect MySQL database
  192. $mysql = new mysql($argv);
  193. var_dump($mysql->find('select version()'));
  194. var_dump($mysql->queries);
  197. // Using the "mysql::connect" method to connect MySQL database
  199. $mysql = new mysql();
  200. $mysql->connect($argv);
  201. var_dump($mysql->find('select version()'));
  202. var_dump($mysql->queries);
  205. $mysql = new mysql();
  206. $mysql->connect($argv);
  207. $mysql->setCharset($argv['charset']);
  208. var_dump($mysql->find('select v
    http://www.kmnk01.com/hxpfk/2015/py_1124/103.html
    ersion()'));
  209. var_dump($mysql->queries);
  http://www.kmnk01.com/hxpfk/2015/jq_1124/96.html
  <?php
4. class mysql {
6. private $defaultDB = null;
7. private $link = null;
8. private $sql = null;
9. private $bindValue = null;
10. public $num_rows = 0;
11. public $affected_rows = 0;
12. public $insert_id = 0;
13. public $queries = 0;
15. public function __construct() {
17. if(func_num_args()) {
18. $argv = func_get_arg(0);
19. if(!empty($argv) && is_array($argv)) {
20. $this->connect($argv);
21. $argv['charset'] = isset($argv['charset']) ? $argv['charset'] : 'utf8';
22. $this->setCharset($argv['charset']);
23. }
24. }
26. }
28. public function connect($argv, $charset = null) {
30. if($this->link) return false;
31. $argv = func_get_arg(0);
32. $argv['port'] = isset($argv['port']) ? $argv['port'] : 3306;
33. $this->link = mysqli_connect( $argv['host'], $argv['user'], $argv['password'], $argv['database'], $argv['port']);
34. if(mysqli_connect_errno()) { echo mysqli_connect_error(); exit(0); }
35. $this->defaultDB = $argv['database'];
37. if($charset)
38. $this->setCharset($charset);
39. }
41. public function selectDB($database){
43. $int = mysqli_select_db($this->link, $database);
44. if($int) $this->defaultDB = $database;
45. return $int;
47. }
49. public function query($sql) {
51. $result = mysqli_query($this->link, $sql);
52. if(mysqli_errno($this->link)) { echo mysqli_error($this->link); exit(0); }
54. $this->queries++;
56. if(preg_match('/^use\\s+(\\w+)/', $sql, $matches)) list($range, $this->defaultDB) = $matches;
58. $pattern = array('read'=> '/(?<=select|show)(.+)$/i', 'write'=> '/(?<=alter|use|replace|insert|update|delete)(.+)$/i');
59. if(preg_match($pattern['write'], $sql)) {
60. $this->affected_rows = mysqli_affected_rows($this->link);
61. }else{
62. $this->num_rows = mysqli_num_rows($result);
63. }
65. if(preg_match('/^insert(.+)$/i', $sql)) {
66. $this->insert_id = mysqli_insert_id($this->link);
67. }
69. return $result;
71. }
73. public function find($sql) {
75. $collection = array();
76. $result = $this->query($sql);
77. while($rows = mysqli_fetch_assoc($result))
78. array_push($collection, $rows);
79. mysqli_free_result($result);
80. return $collection;
82. }
84. public function findOne($sql) {
86. $result = $this->query($sql);
87. $rows = mysqli_fetch_assoc($result);
88. mysqli_free_result($result);
89. return $rows;
91. }
93. public function setCharset($charset) {
95. return mysqli_set_charset($this->link, $charset);
97. }
98. http://www.kmnk01.com/hxpfk/2015/hzj_1124/99.html
99. public function prepare($sql) {
101. $this->sql = $sql;
103. }
105. public function bindValue($search, $value) {
107. $this->bindValue = array();
108. $this->bindValue[$search] = $value;
110. }
112. public function execute() {
114. if(func_num_args()) {
115. $argv = func_get_arg(0);
116. if(!empty($argv) && is_array($argv)) {
117. if(!is_array($this->bindValue)) $this->bindValue = array();
118. $this->bindValue = array_merge($this->bindValue, $argv);
119. }
120. }
122. if($this->bindValue) {
123. foreach($this->bindValue as $search => $value) {
124. $this->sql = str_replace($search, $this->escape($value), $this->sql);
125. }
126. $this->bindValue = null;
127. }
129. $int = $this->query($this->sql);
130. //$this->sql = null;
131. return (boolean) $int;
132. }
135. public function escape($string) {
137. return mysqli_real_escape_string($this->link, $string);
139. }
141. public function close() {
143. return mysqli_close($this->link);
145. }
147. public function ping() {
149. return mysqli_ping($this->link);
151. }
153. public function autoCommit($boolean) {
155. return mysqli_autocommit($this->link, $boolean);
157. }
159. public function commit() {
161. return mysqli_commit($this->link);
163. }
165. public function rollback() {
167. return mysqli_rollback($this->link);
169. }
171. public function __destruct() {
173. if($this->link) $this->close();
174. unset($this->link, $this->defaultDB, $this->bindValue, $this->sql, $this->result, $this->num_rows, $this->affected_rows, $this->insert_id);
176. }
178. }
181. $argv = array(
182. 'host' => 'localhost',
183. 'user' => 'root',
184. 'password' => '',
185. 'port' => 3306,
186. 'database' => 'test',
187. 'charset'=> 'utf8');
190. // Using the "mysql::__construct" method to connect MySQL database
192. $mysql = new mysql($argv);
193. var_dump($mysql->find('select version()'));
194. var_dump($mysql->queries);
197. // Using the "mysql::connect" method to connect MySQL database
199. $mysql = new mysql();
200. $mysql->connect($argv);
201. var_dump($mysql->find('select version()'));
202. var_dump($mysql->queries);
205. $mysql = new mysql();
206. $mysql->connect($argv);
207. $mysql->setCharset($argv['charset']);
208. var_dump($mysql->find('select version()'));
209. var_dump($mysql->queries);
http://www.kmnk01.com/hxpfk/2015/jq_1124/96.html
class mysql {
private $defaultDB = null;
private $link = null;
private $sql = null;
private $bindValue = null;
public $num_rows = 0;
public $affected_rows = 0;
public $insert_id = 0;
public $queries = 0;
public function __construct() {
if(func_num_args()) {
$argv = func_get_arg(0);
if(!empty($argv) && is_array($argv)) {
$this->connect($argv);
$argv['charset'] = isset($argv['charset']) ? $argv['charset'] : 'utf8';
$this->setCharset($argv['charset']);
}
}
}
public function connect($argv, $charset = null) {
if($this->link) return false;
$argv = func_get_arg(0);
$argv['port'] = isset($argv['port']) ? $argv['port'] : 3306;
$this->link = mysqli_connect( $argv['host'], $argv['user'], $argv['password'], $argv['database'], $argv['port']);
if(mysqli_connect_errno()) { echo mysqli_connect_error(); exit(0); }
$this->defaultDB = $argv['database'];
if($charset)
$this->setCharset($charset);
}
public function selectDB($database){
$int = mysqli_select_db($this->link, $database);
if($int) $this->defaultDB = $database;
return $int;
}
public function query($sql) {
$result = mysqli_query($this->link, $sql);
if(mysqli_errno($this->link)) { echo mysqli_error($this->link); exit(0); }
$this->queries++;
if(preg_match('/^use\\s+(\\w+)/', $sql, $matches)) list($range, $this->defaultDB) = $matches;
$pattern = array('read'=> '/(?<=select|show)(.+)$/i', 'write'=> '/(?<=alter|use|replace|insert|update|delete)(.+)$/i');
if(preg_match($pattern['write'], $sql)) {
$this->affected_rows = mysqli_affected_rows($this->link);
}else{
$this->num_rows = mysqli_num_rows($result);
}
if(preg_match('/^insert(.+)$/i', $sql)) {
$this->insert_id = mysqli_insert_id($this->link);
}
return $result;
}
public function find($sql) {
$collection = array();
$result = $this->query($sql);
while($rows = mysqli_fetch_assoc($result))
array_push($collection, $rows);
mysqli_free_result($result);
return $collection;
}
public function findOne($sql) {
$result = $this->query($sql);
$rows = mysqli_fetch_assoc($result);
mysqli_free_result($result);
return $rows;
}
public function setCharset($charset) {
return mysqli_set_charset($this->link, $charset);
}
public function prepare($sql) {
$this->sql = $sql;
}
public function bindValue($search, $value) {
$this->bindValue = array();
$this->bindValue[$search] = $value;
}
public function execute() {
if(func_num_args()) {
$argv = func_get_arg(0);
if(!empty($argv) && is_array($argv)) {
if(!is_array($this->bindValue)) $this->bindValue = array();
$this->bindValue = array_merge($this->bindValue, $argv);
}
}
if($this->bindValue) {
foreach($this->bindValue as $search => $value) {
$this->sql = str_replace($search, $this->escape($value), $this->sql);
}
$this->bindValue = null;
}
$int = $this->query($this->sql);
//$this->sql = null;
return (boolean) $int;
}
public function escape($string) {
return mysqli_real_escape_string($this->link, $string);
}
public function close() {
return mysqli_close($this->link);
}
public function ping() {
return mysqli_ping($this->link);
}
public function autoCommit($boolean) {
return mysqli_autocommit($this->link, $boolean);
}
public function commit() {
return mysqli_commit($this->link);
}
public function rollback() {
return mysqli_rollback($this->link);
}
public function __destruct() {
if($this->link) $this->close();
unset($this->link, $this->defaultDB, $this->bindValue, $this->sql, $this->result, $this->num_rows, $this->affected_rows, $this->insert_id);
}
}
$argv = array(
'host' => 'localhost',
'user' => 'root',
'password' => '',
'port' => 3306,
'database' => 'test',
'charset'=> 'utf8');
// Using the "mysql::__construct" method to connect MySQL database
$mysql = new mysql($argv);
var_dump($mysql->find('select version()'));
var_dump($mysql->queries);
// Using the "mysql::connect" method to connect MySQL database
$mysql = new mysql();
$mysql->connect($argv);
var_dump($mysql->find('select version()'));
var_dump($mysql->queries);
$mysql = new mysql();
$mysql->connect($argv);
$mysql->setCharset($argv['charset']);
var_dump($mysql->find('select version()'));
var_dump($mysql->queries);

<?php class mysql { private $defaultDB = null; private $link = null; private $sql = null; private $

慕斯筱婕

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
[Mysql数据库] php连mysql的工具类

<?phphttp://www.kmnk01.com/hxpfk/2015/jq_1124/96.htmlclass mysql {private $defaultDB = null;private $link = null;private $sql = null;private $bindValue = null;public
复制链接

扫一扫