smsdaemon/webinterface/mysql.php

<?
$DB_HOST="localhost";
$DB_USER="torben";
$DB_PASS="nielsen";
$DB_DATABASE="sms";

if ($MYSQLDB != 1) {

  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);
    if (!$sqlresult) {
      return 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);
        return mysql_affected_rows();
  }

  $MYSQLDB = 1;
}
?>
1	<?
2	$DB_HOST="localhost";
3	$DB_USER="torben";
4	$DB_PASS="nielsen";
5	$DB_DATABASE="sms";
6
7	if ($MYSQLDB != 1) {
8
9	function query($string) {
10	global $DB_CONNECTION;
11	global $DB_DATABASE;
12	global $DB_USER;
13	global $DB_PASS;
14	global $DB_HOST;
15
16	if (!$DB_CONNECTION)
17	$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
18
19	mysql_select_db($DB_DATABASE, $DB_CONNECTION);
20	$sqlresult=mysql_query($string,$DB_CONNECTION);
21	if (!$sqlresult) {
22	return array();
23	}
24	while ($row=mysql_fetch_object($sqlresult)) {
25	$result[]=$row;
26	}
27	return $result;
28
29	}
30
31	function squery($string) {
32	global $DB_CONNECTION;
33	global $DB_DATABASE;
34	global $DB_USER;
35	global $DB_PASS;
36	global $DB_HOST;
37
38	if (!$DB_CONNECTION)
39	$DB_CONNECTION=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
40
41	mysql_select_db($DB_DATABASE, $DB_CONNECTION);
42	$sqlresult=mysql_query($string,$DB_CONNECTION);
43	return mysql_affected_rows();
44	}
45
46	$MYSQLDB = 1;
47	}
48	?>