DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
A Simple PHP Mysql Class
Simple to use :
http://tournasdimitrios1.wordpress.com/2011/11/05/a-simple-php-mysql-class/#more-6911
Note : This Class implements the old Mysql extension , use it only for learning PHP's OOP-concepts . A more robust (Mysqli )extension is available for production database transactions .
According to php.net
" If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use this extension (Mysqli). "
<?php
//Simply include this file on your page
require_once("DbConnect.class.php");
//Set up all yor paramaters for connection
$db = new DbConnect("localhost","user","password","database",$error_reporting=false,$persistent=false);
//Open the connection to your database
$db->open() or die($db->error());
//Query the database now the connection has been made
$db->query("SELECT * FROM....") or die($db->error());
//You have several options on ways of fetching the data
//as an example I shall use
while($row=$db->fetcharray()) {
//do some stuff
}
//close your connection
$db->close();
#################################################################
Class DbConnect {
var $host = '';
var $user = '';
var $password = '';
var $database = '';
var $persistent = false;
var $conn = NULL;
var $result= false;
var $error_reporting = false;
/*constructor function this will run when we call the class */
function DbConnect ($host, $user, $password, $database, $error_reporting=true, $persistent=false) {
$this->host = $host;
$this->user = $user;
$this->password = $password;
$this->database = $database;
$this->persistent = $persistent;
$this->error_reporting = $error_reporting;
}
function open() {
if ($this->persistent) {
$func = 'mysql_pconnect';
} else {
$func = 'mysql_connect';
}
/* Connect to the MySQl Server */
$this->conn = $func($this->host, $this->user, $this->password);
if (!$this->conn) {
return false;
}
/* Select the requested DB */
if (@!mysql_select_db($this->database, $this->conn)) {
return false;
}
return true;
}
/*close the connection */
function close() {
return (@mysql_close($this->conn));
}
/* report error if error_reporting set to true */
function error() {
if ($this->error_reporting) {
return (mysql_error()) ;
}
}
function query($sql) {
$this->result = @mysql_query($sql, $this->conn);
return($this->result != false);
}
function affectedrows() {
return(@mysql_affected_rows($this->conn));
}
function numrows() {
return(@mysql_num_rows($this->result));
}
function fetchobject() {
return(@mysql_fetch_object($this->result, MYSQL_ASSOC));
}
function fetcharray() {
return(mysql_fetch_array($this->result));
}
function fetchassoc() {
return(@mysql_fetch_assoc($this->result));
}
function freeresult() {
return(@mysql_free_result($this->result));
}
}
?>
