Need a sinple Database handler class

[hmvrulz]

Can some one provide a database handler class that can

Connect to db

query

select table

result in an array

give number of rows

disconnect

[Dathremar]

this one is nice for MySQL:

 

 

 

[attachment deleted by admin]

[hmvrulz]

this one is nice for MySQL:

 

 

 

seems to be nice... can u provide me with examples to use it.. am new to OOP

[RichardRotterdam]

PDO maybe? its comes as part of php since version 5

[Dathremar]

this is how u make object of that class:

 

// connection to database

class name_of_object extends DB_Sql {

  var $classname = "name";

  var $Host    = "host";

  var $Database = "database_name";

  var $User = "user_name";

  var $Password = "password";

 

  function haltmsg($msg) {

  echo "Database error:\\t".$msg."\\nPHP reported:\\t".$this->Error;

  exit;

  }

}

 

After this use:

 

$name_of_instance_of_object = new name_of_object;

 

and after this use :

 

$name_of_instance_of_object->query($query_string); -> for executing queries

$name_of_instance_of_object->next_record(); -> for geting the next record

$name_of_instance_of_object->nr(); -> number of rows for the result of the execution of the query.

 

These are most common used i guess. If u need more  hlp just post here.

[hmvrulz]

thanx... in case i need help i wil surely knock the door