Author Topic: Database class for PHP 5+ and MySQL (Help)  (Read 568 times)

Offline Karlos

  • Level 7
  • *
  • Posts: 31
  • Reputation: +2/-0
    • View Profile
Database class for PHP 5+ and MySQL (Help)
« on: July 23, 2009, 06:49:06 AM »
Well I a total noice when it comes to OOP, so I was wondering if anyone could give me any tips, idea's or constructive critism.
Code: [Select]
<?php
if (!defined('Access')) { die('Forbidden Access.'); }

Class 
Database {
 protected 
$Connect$ConnectStatus false;
 public 
$TotalQueries$Affected null;
 
 public function 
__construct($Host$User$Pass$Database) {
  
$this->Connect = @mysql_connect($Host$User$Pass);
  if (!
is_resource($this->Connect)) {
   
$this->ConnectStatus false;
   die(
'Cannot Connect To The MySQL Server.');
  } else if (!@
mysql_select_db($Database$this->Connect)) {
   
mysql_close($this->Connect);
   
$this->ConnectStatus false;
   die(
'Cannot Select The Defined MySQL Database.');
  } else {
   
$this->ConnectStatus true;
  }
 }
 
 public function 
isConnected() {
  return 
$this->ConnectStatus;
 }
 
 public function 
doEscape($Var) {
  if (
get_magic_quotes_gpc()) {
   
$Var stripslashes($Var);
  }
  return 
mysql_real_escape_string($Var$this->Connect);
 }
 
 public function 
doQuery($Sql) {
  
$Query = @mysql_query($Sql$this->Connect);
  if (
$Query === false) { 
   return 
$this->raiseError();
  }
  ++
$this->TotalQueries;
  
$this->Affected = @mysql_affected_rows($this->Connect);
  return 
$Query;
 }
 
 public function 
affectedRows() {
  return 
mysql_affected_rows($this->Connect);
 } 
 
 public function 
numRows($Sql){
  return 
mysql_num_rows($Sql);
 }
 
 public function 
insertId() {
  return 
mysql_insert_id($this->Connect);
 }
   
 public function 
doDisconnect() {
  
$this->ConnectStatus false;
  return 
mysql_close($this->Connect);
 } 
 
}

?>

 


SimplePortal 2.3.3 © 2008-2010, SimplePortal