Advanced Search

MySQL Interface Class

/ Published in: PHP
Save to your folder(s)
Every MySQL class for PHP I've seen so far has been an epic disappointment. This will not lead you to feel the same way. Enjoy!

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php
  2.  
  3. // manages mysql connection
  4. class SQL {
  5.  
  6. 	private $conn, $lastq;
  7. 	public $query_count = 0;
  8.  
  9. 	// constructor. connects upon class formation.
  10. 	function SQL ($server, $user, $pw, $db, $persist) {
  11.  
  12. 		// connect
  13. 		$this->conn = (
  14. 			$persist ? @mysql_pconnect($server, $user, $pw) :
  15. 						@mysql_connect($server, $user, $pw))
  16. 			or exit ("Error Connecting to MySQL: ".mysql_error()."\n");
  17.  
  18. 		// select db
  19. 		@mysql_select_db($db, $this->conn) or
  20. 			exit ("Error Selecting MySQL DB: ".mysql_error() . "\n");
  21.  
  22. 		return true;
  23.  
  24. 	}
  25.  
  26. 	// run a query
  27. 	function query($q) {
  28. 		// run it
  29. 		$this->lastq = @mysql_query($q, $this->conn) or
  30. 			$this->error_message ("Query Error: ".mysql_error()."\n");
  31.  
  32. 		// increment query count
  33. 		$this->query_count++;
  34.  
  35. 		// return result
  36. 		return $this->lastq;
  37. 	}
  38.  
  39. 	// run an unbuffered query. (used only a few times)
  40. 	function query_unbuff($q)
  41. 	{
  42. 		// run it
  43. 		$this->lastq = @mysql_unbuffered_query($q, $this->conn) or
  44. 			$this->error_message ("Query Error: ".mysql_error()."\n");
  45.  
  46. 		// increment query count
  47. 		$this->query_count++;
  48.  
  49. 		// return result
  50. 		return $this->lastq;
  51.  
  52. 	}
  53.  
  54. 	// free a result
  55. 	function free($r) {
  56. 		@mysql_free_result($r);
  57. 	}
  58.  
  59. 	// free last query result
  60. 	function freelast() {
  61. 		if (is_resource($this->conn) && is_resource($this->lastq))
  62. 			@mysql_free_result($this->lastq);
  63. 	}
  64.  
  65. 	// get result as a numerical array
  66. 	function fetch_row($r = null) {
  67. 		$r = @$r ? $r : $this->lastq;
  68. 		return @mysql_fetch_row($r);
  69. 	}
  70.  
  71. 	// get result as a associative array
  72. 	function fetch_assoc($r = null) {
  73. 		$r = @$r ? $r : $this->lastq;
  74. 		return @mysql_fetch_assoc($r);
  75. 	}
  76.  
  77. 	// close mysql connection
  78. 	function close() {
  79. 		if (is_resource($this->conn))
  80. 			mysql_close($this->conn);
  81. 	}
  82.  
  83. 	// escape
  84. 	function prot($s) {
  85. 		return ctype_digit($s) ? $s : mysql_real_escape_string($s, $this->conn);
  86. 	}
  87.  
  88. 	// last id
  89. 	function lastid() {
  90. 		return mysql_insert_id($this->conn);
  91. 	}
  92.  
  93. 	// rows affected by last update/replace/delete/insert
  94. 	function affected_rows() {
  95. 		return mysql_affected_rows($this->conn);
  96. 	}
  97.  
  98. 	// show error message
  99. 	function error_message() {
  100.  
  101. 		// halt whilst showing the message
  102. 		exit ("MySQL Error: \n".mysql_error($this->conn)."\n");
  103.  
  104. 	}
  105.  
  106. 	// are we connected?
  107. 	function is_connected() {
  108. 		return is_resource($this->conn);
  109. 	}
  110.  
  111. 	// return number of results
  112. 	function num($r) {
  113. 		return mysql_num_rows($r);
  114. 	}
  115. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.