Advanced Search

sqlDataObj in PHP5

/ Published in: PHP
Save to your folder(s)
Pretty straight forward implementation of mysql instantiation using php5 oop. Example usage at the bottom. The database in the example is named 'example_database' and has 1 table, 'newstable'. This table has three columns: 'id,heading,message'.

By bakkelun

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. -- mysql connection handler --
  2.  
  3. <?
  4.  
  5. class mysql {
  6. 	var $dbase;
  7. 	var $dbcon;     
  8.         var $db_user;
  9.         var $db_pw;
  10.  
  11.         /* Constructor */
  12. 	function __construct($base,$user,$pw) {
  13.  
  14. 	$this->dbase = $base;
  15. 	$this->db_user = $user;
  16. 	$this->db_pw = $pw;        
  17.  
  18. 	$this->dbcon = mysql_connect("url-to-your-db",$this->db_user,$this->db_pw); 
  19. 	if (!$this->dbcon)  {  
  20. 		die( "<p>Unable to connect to the database server at this time.</p>" );
  21. 		} else { 
  22. 			if (!@mysql_select_db($this->dbase,$this->dbcon))  {
  23. 			die( "<p>Could not choose this database: ".$this->dbase." Please try again later.</p>" );
  24. 			}
  25. 		}
  26. 	} // connect end
  27.  
  28.  
  29. 	function closeconnection() {
  30. 	  mysql_free_result();
  31. 	  mysql_close($this->dbcon);
  32. 	} // closeconnection end
  33.  
  34. }
  35. ?>
  36.  
  37.  
  38. --- sql data object ---
  39.  
  40. <? 
  41. require('path to the above mysql class file');
  42.  
  43. class sqlDataObject extends mysql {
  44.  
  45. 	var $resultSet;
  46. 	var $update_string;
  47.  
  48.         /**
  49. 	* Gets SQL data. Default limit is 10 (if no param passed) to avoid erronous and SERVER-heavy loads.
  50. 	*
  51. 	*/
  52. 	function getData($table,$what_to_get,$where,$orderby,$sortorder='DESC',$offset='0',$limit='10',$outputArray='0') {
  53.  
  54. 	if (!empty($where)) { $where = 'WHERE '.$where; }
  55.  
  56. 	if (!empty($orderby)) { $orderby = 'ORDER BY '.$orderby; }
  57.  
  58. 	if (!empty($limit)) { $limit = 'LIMIT '.$offset.','.$limit; }
  59.  
  60. 	$query = mysql_query("SELECT $what_to_get FROM $table $where $orderby $sortorder $limit");
  61. 	if (!$query) {
  62. 		$this->errorHandler(mysql_error());
  63. 	}
  64.  
  65. 	// Output as array
  66. 	if ($outputArray=='1') {
  67. 		while ($query_row = mysql_fetch_assoc($query)) {
  68. 			$this->resultSet[] = $query_row;
  69. 		}
  70.  
  71. 	// Output as mysql-resource. Useful if you have existing code logic that depends on a query resource result
  72. 	} else {
  73. 		$this->resultSet = $query;
  74. 	}
  75.     }
  76.  
  77.      /* Handle potensially dangerous input */
  78. 	function safevalue ($value) {
  79. 		return mysql_real_escape_string(strip_slashes(trim($value)));
  80. 	}
  81.  
  82. }
  83. ?>
  84.  
  85. ---- EXAMPLE USAGE ----
  86.  
  87. Let's say we want to output all the info in our 'newstable' from our database 'example-database'. Here's how:
  88.  
  89. <?
  90. require('path-to-the-sql-data-object-file.php');
  91.  
  92. $sqlData = new sqlDataObject('example_database','username','password');
  93.  
  94.  
  95.  
  96.  
  97. /* Get all news info where the id is less than 10 and ordr by the id. */
  98.  
  99. /* In this example let's say the database has only three columns: id, heading, message */
  100.  
  101. $some_news_output = $sqlData->getData('newstable','*','id<10','id');
  102.  
  103. while ($news_row = mysql_fetch_array($some_news_output)) {
  104.    echo('<h1>'.$news_row['heading'].'</h1>'.
  105.     $news_row['message'].'
  106.    <p><a href="?page=news&amp;id="'.$news_row['id'].'">Read more about this</a></p>');
  107. }
  108. ?>

URL: http://www.dosspirit.net

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.