De onderstaande file is bijvoorbeeld sql.class.php, wel moet je zelf je gegeven van je database nog invoeren.

<?
class vraag_db {
//je gegevens van de DB hier onder invullen
 var $DATABASE = '';
 var $USERNAME = '';
 var $PASSWORD = '';
 var $SERVER = 'localhost';

 // deze gegevens NIET veranderen
 var $conn='';
 var $CONNECTION='';
 var $MSG = '';
###########################################
# Function:    OpenConnection
# Description: connects to the database
###########################################
 function open_db()
  {
  $conn = @mysql_connect($this->SERVER,$this->USERNAME,$this->PASSWORD);
  if ((!$conn) || (!mysql_select_db($this->DATABASE,$conn)))
   {
   $this->MSG = "\r\n" . "Unable to connect to database - " . date('H:i:s');
   echo $this->MSG;
   return false;
   }
  else
   {
   $this->CONNECTION = $conn;
// $this->MSG = "\r\n" . "Open connection to database - " . date('H:i:s');
// echo $this->MSG;
   return true;
   }
  }
############################
# Function:  close database
############################
 function close_db ()
  {
  if(mysql_close($this->CONNECTION))
   {
   //echo"sl";
   }
  }
#######################################################
# Function: vraag (Query array[row][fieldname/fieldindex])
#######################################################
 function vraag($sql)
  {
  if(!$this->open_db())
   {
   return false;
   exit;
   }
  if ((empty($sql)))
   {
   $this->MSG = "\r\n" . "SQL Statement is <code>null</code> or not a SELECT - " . date('H:i:s');
   echo $this->MSG;
   return false;
   }
  else
   {
   $results = @mysql_db_query($this->DATABASE,$sql);
   if ((!$results) || (empty($results)))
    {
    $this->MSG = "\r\n" . mysql_error()." - " . date('H:i:s');
    echo $this->MSG;
    return false;
    }
   else
    {
    $i = 0;
    $data = array();
while($row = mysql_fetch_array($results,MYSQL_ASSOC))
{
$ii = 0;
while(list($myVariableName,$sqlFieldName)=each($row))
 {
 $data[$i][$myVariableName] = $sqlFieldName;


 }   $i++;
$ii++;
}

    mysql_free_result($results);
    $this->close_db();
    return $data;
    }
   }
  }# einde Function vraag
 }# einde class  database
?>