topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

server-php-micro-db-manager-DBManager.class.php / php



  <?php
This is a MySQL handler class
version: 1.0
author: PhpToys @copyright PhpToys 2007 

  
  class DBManager{
          
          var connection   = '';
          var queryCounter = 0;
          var totalTime    = 0;        
          var errorCode    = 0;
          var errorMsg     = '';
          var resultSet    = '';
Constuctor of the class. Connects to the server and selects the database.
parameter: string host
parameter: string user
parameter: string pass
parameter: string db
returns: DBManager 

  
          function DBManager(host, user, pass, db){
                  startTime = this->getMicroTime();
                  
                  // Try to make a connection to the server
                  if (!this->connection = @mysql_connect(host,user,pass,true)){
                          this->errorCode = mysql_errno();
                          this->errorMsg  = mysql_error();
                          return false;
                  }
                  
                  // Now select the database
                  if (!@mysql_select_db(db,this->connection)){
                          this->errorCode = mysql_errno();
                          this->errorMsg  = mysql_error();
                          @mysql_close(this->connection);
                          return false;
                  }
  
                  this->totalTime += this->getMicroTime() - startTime;
                          
                  return true;
          }
Execute the sql statement and returns with the result set.
parameter: string sql
returns: unknown 

  
          function executeQuery(sql){
                  startTime = this->getMicroTime();
  
                  ++this->queryCounter;
                  
                  if(!this->resultSet = @mysql_query(sql,this->connection)){
                          this->errorCode = mysql_errno();
                          this->errorMsg  = mysql_error();
                          this->totalTime = this->getMicroTime() - startTime;
                          return false;
                  }
                  
                  this->totalTime += this->getMicroTime() - startTime;
  
                  return this->resultSet;
          }
This function loads the previous query result into an array.
returns: array 

  
          function loadResult() {
                  array = array();
                  while (row = mysql_fetch_object( this->resultSet )) {
                          array[] = row;
                  }
                  mysql_free_result( this->resultSet );
  
                  return array;
          }
Returns with the number of selected rows in the previous sql statement.
returns: int 

  
          function getSelectedRows()
          {
                  return @mysql_num_rows(this->resultSet);
          }
Returns with the number of the affected rows in the previous sql statement.
returns: int 

  
          function getAffectedRows()
          {
                  return @mysql_affected_rows(this->connection);
          }
Get the ID generated from the previous INSERT operation
returns: int 

  
          function getInsertId(){
                  return @mysql_insert_id(this->connection);
          }
Return the total time spended in this class
returns: float 

  
          function getDBTime(){
                  return round(this->totalTime,6);
          }
          
          function getSqlCount(){
                  return this->queryCounter;
          }
          
          function getErrrorCode(){
                  return this->errorCode;
          }
          
          function getErrorMessage(){
                  return this->errorMsg;
          }
          
          
            function getMicroTime() {
              list(usec, sec) = explode(" ",microtime());
              return ((float)usec + (float)sec);
      }
  }
  
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.