<?php
/*
  File name        : database.php
  Projet           : BackupMX
  Date of creation : 25/3/2009
  Version          : 1.0
  Copyright        : Soft'N'Design
  Author           : Laurent Mazet <mazet@softndesign.fr>

  Description      :

  History          :
  - 25/3/9 inital version
 */

/* Library of functions relevant to MySQL database */

/* Open connection to database */
function dbconnect($config) {
  
  /* Make sure that we have MySQL support, try loading it */
  if (!extension_loaded('mysql') && !dl('mysql.so'))
    return 0;

  if (empty($config["user"]))
    $db = @mysql_connect();
  else
    $db = @mysql_connect($config["host"], $config["user"], $config["pwd"]);
  
  if ((!$db) || (!@mysql_select_db($config["db"], $db))) {
    @mysql_close($db);
    return -1;
  }
  
  /* When the script exits, we close the connection to the DB */
  register_shutdown_function('dbclose', $db);
  
  return $db;
}

/* Close connection to database */
function dbclose($db) {
  mysql_close($db);
}

/* Execute a database query */
function dbquery($db, $query) {
    global $debug;

    if (empty($query))
        return;

    $res = mysql_query($query . ";", $db);
    debugger (($debug > 3), $res);
  
    return $res;
}

/* Get database error */
function dberror($db) {
  if (!$res)
    return ($db) ? mysql_error($db) : mysql_error();
  
  return "";
}

/* Fetch an array from a query result */
function dbfetch ($res) {
    return empty ($res) ? null : mysql_fetch_row($res);
}