<?
$DB_HOST="localhost";
$DB_USER="root";
$DB_PASS="root";
$DB_DATABASE="horsensspejder";


  function cached_query($string, $timeout = 300) {
    $memc = new Memcache();
    $memc->addServer("localhost");
    
    $key = "sql:" . md5($string);
    $result = $memc->get($key);

    if ($result == false) {
      $result = query($string);
      $memc->set($key,$result, 0, $timeout);
    } 

    return $result;
  }

  function query($string) {
    global $DB_CONNECTION;
    global $DB_DATABASE;
    global $DB_USER;
    global $DB_PASS;
    global $DB_HOST;

    if (!$DB_CONNECTION)
      $DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);

    mysql_select_db($DB_DATABASE, $DB_CONNECTION);
    $sqlresult=mysql_query($string,$DB_CONNECTION) or die( mysql_error($DB_CONNECTION) );
    if (!$sqlresult) {
      return array();
    }
	$result = array();
    while ($row=mysql_fetch_object($sqlresult)) {
      $result[]=$row;
    }
    return $result;

}

  function squery($string) {
    global $DB_CONNECTION;
    global $DB_DATABASE;
    global $DB_USER;
    global $DB_PASS;
    global $DB_HOST;

    if (!$DB_CONNECTION)
      $DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);

    mysql_select_db($DB_DATABASE, $DB_CONNECTION);
    $sqlresult=mysql_query($string,$DB_CONNECTION) or die( mysql_error($DB_CONNECTION) );;
	return mysql_affected_rows();
  }

  function insert_id() {
    global $DB_CONNECTION;
    global $DB_DATABASE;
    global $DB_USER;
    global $DB_PASS;
    global $DB_HOST;

    if (!$DB_CONNECTION)
      $DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);

    return mysql_insert_id();     
  }

	function escape_string($string) {
    global $DB_CONNECTION;
    global $DB_DATABASE;
    global $DB_USER;
    global $DB_PASS;
    global $DB_HOST;

    if (!$DB_CONNECTION)
 		$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);

	return mysql_real_escape_string($string);
	}

?>