Development ≫ PHP | 2009-07-09 03:22:13

MySQL Connection Class

A Long time ago, i wrote a Class, that makes ৺SQL-Querys easier:

<?php
class SQL{
     var $Result;
     
     var $Server = "localhost";
     var $User = "user";
     var $Password = "password";
     var $Database = "general";
     
     var $LastInsertId = 0;
     var $LastErrorMsg = "";
     
     function SQL($Database=""){
       if ($Database) $this->Database = $Database;
     }
     
     function Query($Query){
       $db_conn = @mysql_connect($this->Server,$this->User,$this->Password);
       @mysql_select_db($this->Database,$db_conn);
       $this->Result = mysql_query($Query);
       
       $this->LastInsertId = @mysql_insert_id($db_conn);
       $this->LastErrorMsg = array("Status" => mysql_errno($db_conn),"Msg" => mysql_error($db_conn), "Query" => $Query);
     }
     
      function GetResultRow($Mode = MYSQL_ASSOC){
       return mysql_fetch_array($this->Result, $Mode);
     }
     
     function GetLastInsertId(){
       return $this->LastInsertId;
     }
     
     function Status(){
       if ($this->LastErrorMsg["Status"] != 0) return false;
       else return true;
     }
     
     function GetLastErrorId(){
       return $this->LastErrorMsg["Status"];
     }
     
     function GetLastErrorMsg(){
       return $this->LastErrorMsg["Msg"];
     }
     
     function GetLastErrorQuery(){
       return $this->LastErrorMsg["Query"];
     }
    
     function GetCount(){
       return mysql_num_rows($this->Result);
     }
}
?>

The usage is very Simple:

First, there is the Constructor. If "no" Value passed, the defined ৺Database will be used - else the one specified will be used to establish the connection:

$mySQL = new SQL("DataBaseName");

Now you can build your query in a string -or simple use the command direct:

$mySQL->Query("SELECT column1,column2 FROM table ORDER BY column1");

To loop through the result, you simple can use the line:

While ($Row = $mySQL->GetResultRow($Option)){
 //Do Some Stuff with lines
}

Where Option is MYSQL_NUM or MYSQL_ASSOC (default).
To make error handling possible, i added the functions, explained bellow:

$mySQL->Status()

returns true if everything is fine, and false if something has gone wrong...
To gather information about what's going wrong, you can use

$mySQL->GetLastErrorMsg();
$mySQL->GetLastErrorId();
$mySQL->GetLastErrorQuery();

ErrorMsg will be the error string as known from ৺MySQL.
ErrorId will be the related number.
ErrorQuery will return the query, that causes this error. (For logging, debuging, ...)

$mySQL->Count();

returns the number of rows, the select query has matched.

$mySQL->GetLastInsertId();

returns the id, associated with the Entry, the last insert query has created.

Related Tags:

৺MySQL
৺SQL
৺Database

Stay tuned:

Top 25 Tag-Cloud (last 14 days):

bimmer bitmapimage bitmapsource contact dog.net ftp hotlinking interaction linkphonebook listview mesh networking php planetary reaktions robotics share sql synchronisation to tyrannis vb vb.net worksheet xda

Comments on this post:

Not yet a comment...

Donate!

Like my stuff? Feel free to donate!

Development ≫ PHP | 2009-10-14 02:08:39

ImageCopyMergeAlpha

The GD-Lib is a very powerfull extension for PHP.

but in one case, it really fails.

read more...

Development ≫ PHP | 2009-08-26 16:35:21

rand or mt_rand?

Random numbers are often useful - but those are these pseudo random numbers really random?

read more...

Development ≫ PHP | 2009-08-19 23:27:25

Easy Permission Management System

Heres a sample of a easy ৺permission management system.

read more...

Development ≫ PHP | 2009-07-12 02:30:50

Captcha With Real Tff And Background

Here you can find a ৺captcha code, that uses real tiff fonts as well as random background images. This is a improved version of my older ৺captcha, which completly was made by colors, default fonts and shapes.

read more...

Development ≫ PHP | 2009-07-09 03:22:05

MakeNiceSize

This is the php function, i use to create user friendly file size strings. Sizes like 215742435 byte or 0,00000000023 GB are NOT user friendly.

read more...

Share this: