horsensspejder-web/inc/mysql.php

<?
$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);
        }

?>
1	torben	2125	<?
2			$DB_HOST="localhost";
3			$DB_USER="root";
4			$DB_PASS="root";
5			$DB_DATABASE="horsensspejder";
6
7
8			function cached_query($string, $timeout = 300) {
9			$memc = new Memcache();
10			$memc->addServer("localhost");
11
12			$key = "sql:" . md5($string);
13			$result = $memc->get($key);
14
15			if ($result == false) {
16			$result = query($string);
17			$memc->set($key,$result, 0, $timeout);
18			}
19
20			return $result;
21			}
22
23			function query($string) {
24			global $DB_CONNECTION;
25			global $DB_DATABASE;
26			global $DB_USER;
27			global $DB_PASS;
28			global $DB_HOST;
29
30			if (!$DB_CONNECTION)
31			$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
32
33			mysql_select_db($DB_DATABASE, $DB_CONNECTION);
34			$sqlresult=mysql_query($string,$DB_CONNECTION) or die( mysql_error($DB_CONNECTION) );
35			if (!$sqlresult) {
36			return array();
37			}
38			$result = array();
39			while ($row=mysql_fetch_object($sqlresult)) {
40			$result[]=$row;
41			}
42			return $result;
43
44			}
45
46			function squery($string) {
47			global $DB_CONNECTION;
48			global $DB_DATABASE;
49			global $DB_USER;
50			global $DB_PASS;
51			global $DB_HOST;
52
53			if (!$DB_CONNECTION)
54			$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
55
56			mysql_select_db($DB_DATABASE, $DB_CONNECTION);
57			$sqlresult=mysql_query($string,$DB_CONNECTION) or die( mysql_error($DB_CONNECTION) );;
58			return mysql_affected_rows();
59			}
60
61			function insert_id() {
62			global $DB_CONNECTION;
63			global $DB_DATABASE;
64			global $DB_USER;
65			global $DB_PASS;
66			global $DB_HOST;
67
68			if (!$DB_CONNECTION)
69			$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
70
71			return mysql_insert_id();
72			}
73
74			function escape_string($string) {
75			global $DB_CONNECTION;
76			global $DB_DATABASE;
77			global $DB_USER;
78			global $DB_PASS;
79			global $DB_HOST;
80
81			if (!$DB_CONNECTION)
82			$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
83
84			return mysql_real_escape_string($string);
85			}
86
87			?>