当前位置：Gxlcms > PHP教程 > 面向对象的mysql数据库操作php类

面向对象的mysql数据库操作php类

时间：2021-07-01 10:21:17 帮助过：36人阅读

  1. class database {
  3. var $host = NULL;
  4. var $username = NULL;
  5. var $password = NULL;
  6. var $databaseName = NULL;
  7. var $link = NULL;
  8. var $queries = NULL;
  9. var $errors = NULL;
  11. var $databaseExtras = NULL;
  13. function __construct($host, $username, $password, $database) {
  14. $this->database($host, $username, $password, $database);
  15. }
  17. function database($host, $username, $password, $database) {
  18. /*$this->database = array (
  19. "host" => $host,
  20. "username" => $username,
  21. "password" => $password,
  22. "database" => $database,
  23. "link" => "",
  24. "queries" => array (),
  25. "errors" => array ()
  26. );*/
  28. $this->host = $host;
  29. $this->username = $username;
  30. $this->password = $password;
  31. $this->databaseName = $database;
  32. $this->link = "";
  33. $this->queries = array ();
  34. $this->errors = array ();
  36. $this->databaseExtras = new stdClass;
  38. $this->link = mysql_connect($this->host, $this->username, $this->password) or die("Could not connect to Database");
  39. mysql_select_db($this->databaseName);
  40. }
  42. function justquery($sql) {
  43. $this->queries[] = $sql;
  44. return mysql_query($sql, $this->link);
  45. }
  47. function loadResult($sql) {
  48. if (!($cur = $this->justquery($sql))) {
  49. return null;
  50. }
  51. $ret = null;
  52. if ($row = mysql_fetch_row( $cur )) {
  53. $ret = $row[0];
  54. }
  55. mysql_free_result( $cur );
  56. return $ret;
  57. }
  59. function loadFirstRow($sql) {
  60. if (!($cur = $this->justquery($sql))) {
  61. return null;
  62. }
  63. $ret = null;
  64. if ($row = mysql_fetch_object( $cur )) {
  65. $ret = $row;
  66. }
  67. mysql_free_result( $cur );
  68. return $ret;
  69. }
  71. function insertid() {
  72. return mysql_insert_id( $this->link );
  73. }
  75. function query($sql, $key = "", $returns = true, $batch = false) {
  76. $result = array ();
  78. switch ($batch) {
  79. default:
  80. case true:
  81. foreach ($sql as $index => $query) {
  82. $this->queries[] = $query;
  83. $answer = mysql_query($query, $this->link);
  85. if (!$answer) {
  86. $this->errors[] = mysql_error($this->link);
  87. }
  88. else {
  89. if ($returns != false) {
  90. if (mysql_num_rows($answer) > 0){
  91. while ($row = mysql_fetch_object($answer)) {
  92. if ($key != ""){
  93. $result[$index][$row->$key] = $row;
  94. }
  95. else {
  96. $result[$index][] = $row;
  97. }
  98. }
  99. } else {}
  100. } else {}
  101. }
  102. }
  103. break;
  105. case false:
  106. $this->queries[] = $sql;
  107. $answer = mysql_query($sql, $this->link);
  109. if (!$answer) {
  110. $this->errors[] = mysql_error($this->link);
  111. $result = false;
  112. }
  113. else {
  114. if ($returns != false) {
  115. if (mysql_num_rows($answer) > 0){
  116. while ($row = mysql_fetch_object($answer)) {
  117. if ($key != ""){
  118. $result[$row->$key] = $row;
  119. }
  120. else {
  121. $result[] = $row;
  122. }
  123. }
  124. } else {}
  125. }
  126. else {
  127. $result = true;
  128. }
  129. }
  130. break;
  131. }
  133. return $result;
  134. }
  136. function loadObject( $sql, &$object ) {
  137. if ($object != null) {
  138. if (!($cur = $this->justquery($sql))) {
  139. return false;
  140. } else {}
  141. if ($array = mysql_fetch_assoc( $cur )) {
  142. mysql_free_result( $cur );
  143. $this->bindArrayToObject( $array, $object);
  144. return true;
  145. }
  146. else {
  147. return false;
  148. }
  149. }
  150. else {
  151. if ($cur = $this->justquery($sql)) {
  152. if ($object = mysql_fetch_object( $cur )) {
  153. mysql_free_result( $cur );
  154. return true;
  155. }
  156. else {
  157. $object = null;
  158. return false;
  159. }
  160. }
  161. else {
  162. return false;
  163. }
  164. }
  165. }
  167. function bindArrayToObject( $array, &$obj) {
  168. if (!is_array( $array ) || !is_object( $obj )) {
  169. return (false);
  170. }
  172. foreach (get_object_vars($obj) as $k => $v) {
  173. if( substr( $k, 0, 1 ) != '_' ) {
  174. $ak = $k;
  175. if (isset($array[$ak])) {
  176. $obj->$k = $array[$ak];
  177. }
  178. }
  179. }
  181. return true;
  182. }
  184. function formatCSVCell($data) {
  185. $useQuotes = false;
  187. $quotable = array (
  188. "\"" => "\"\"",
  189. "," => ",",
  190. "\n" => "\n"
  191. );
  193. foreach ($quotable as $char => $repl) {
  194. if (eregi($char, $data)) {
  195. $useQuotes = true;
  196. } else {}
  197. }
  199. if ($useQuotes == true) {
  200. foreach ($quotable as $char => $repl) {
  201. $data = str_replace($char, $repl, $data);
  202. }
  204. $data = "\"" . $data . "\"";
  205. }
  206. else {
  208. }
  210. return $data;
  211. }
  212. }
  213. ?>

面向对象, mysql, php

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！