Note: This is intended for my personal use only just incase I will for get this things during my PHP Test. However, I you find this helpful to you, feel free to copy the code. This set of code is base from what I learned from lynda tutorial beyond the basic. The video has been really useful to me and learn alot of things from it.
//Config.php
defined('DB_SERVER') ? null : define("DB_SERVER", "localhost");
defined('DB_USER') ? null : define("DB_USER", "root");
defined('DB_PASS') ? null : define("DB_PASS", "admin");
defined('DB_NAME') ? null : define("DB_NAME", "photo_gallery");
?>
//Database.php
require_once("config.php");
class MysqlDatabase{
private $connection;
public $last_query;
private $magic_qoutes_active;
private $new_enough_php;
function __construct(){
$this->open_connection();
$this->magic_quotes_active = get_magic_quotes_gpc();
$this->new_enough_php = function_exists( "mysql_real_escape_string" ); // i.e. PHP >= v4.3.0
}
public function open_connection(){
$this->connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);
if(!$this->connection){
die("Database connection failed:" .mysql_error());
}
else{
$db_select = mysql_select_db(DB_NAME, $this->connection);
if(!$db_select){
die("Database selection failed:". msql_error());
}
}
}
public function close_connection(){
if(isset($this->connection)){
mysql_close($this->connection);
unset($this->connection);
}
}
public function query($sql){
$this->last_query = $sql;
$result = mysql_query($sql,$this->connection);
$this->confirm_query($result);
return $result;
}
//Database Neutral Methods
public function insert_id(){
return mysql_insert_id($this->connection);
}
public function fetch_array($result){
return mysql_fetch_array($result);
}
public function affected_rows(){
return mysql_affected_rows ($result);
}
public function num_rows($result){
return mysql_num_rows($result);
}
private function confirm_query($result){
if(!$result){
$output = "Database query failed:". mysql_error()."
";
// $output .= "Last SQL Query: ".$this->last_query;
die($output);
}
}
public function escape_value( $value ) {
if( $this->new_enough_php ) { // PHP v4.3.0 or higher
// undo any magic quote effects so mysql_real_escape_string can do the work
if($this->magic_quotes_active ) { $value = stripslashes( $value ); }
$value = mysql_real_escape_string( $value );
} else { // before PHP v4.3.0
// if magic quotes aren't already on then add slashes manually
if( !$this->magic_quotes_active ) { $value = addslashes( $value ); }
// if magic quotes are active, then the slashes already exist
}
return $value;
}
}
$database = new MysqlDatabase();
$db = & $database;
?>
//Functions.php
function strip_zeros($marked_string=""){
$no_zeros = str_replace('*0','',$marked_string);
$clean_string = str_replace ('*','',$no_zeros);
return $clean_string;
}
function redirect_to($location = NULL){
if($location != NULL){
header ("Location: {$location}");
exit;
}
}
function output_message($message=""){
if(!empty($message)){
return "
{$message}
";
}
else
return "";
}
?>
//User.php
require_once('database.php');
class User{
public $id;
public $username;
public $password;
public $first_name;
public $last_name;
public static function find_all()
{
global $database;
return self::find_by_sql("Select * FROM users");
}
public static function find_by_id($id=0)
{
global $database;
$result_set = $database->query("SELECT * FROM users WHERE id={$id}");
$found = $database->fetch_array($result_set);
return $found;
}
public static function find_by_sql($sql=""){
global $database;
$result_set = $database->query($sql);
return $result_set;
}
public function full_name(){
if(isset($this->first_name) && isset($this->last_name)){
return $this->first_name." ".$this->last_name;
}
}
private static function instantiate($result){
$object = new self;
//$object->id = $record['id'];
//$object->username = $record['username'];
//$object->password = $record['password'];
//$object->first_name = $record['first_name'];
//$object->last_name = $record['last_name'];
foreach($record as $attribute=>$value){
if($object->has_attribute($attribute)){
$object->$attribute = $value;
}
}
return $object;
}
private function has_attribute($attribute){
// get_object_vars returns an associative array with all attributes
// (incl. private ones!) as the keys and their current values as the value
$object_vars = get_object_vars($this);
// We don't care about the value, we just want to know if the key exists
// Will return true or false
return array_key_exists($attribute, $object_vars);
}
}
?>
//Index.php
require_once("../includes/database.php");
require_once("../includes/user.php");
$record = User::find_by_id(1);
echo $user->username;
echo "
";
echo $user->full_name();
?>
