db.php

   1 <?
   2
   3 require_once "config.php";
   4
   5 function db_connect($host, $user, $pass, $db) {
   6         if (DB_TYPE == "pgsql") {
   7
   8                 $string = "dbname=$db user=$user password=$pass";
   9
  10                 if ($host) {
  11                         $string .= " host=$host";
  12                 }
  13
  14                 $link = pg_connect($string);
  15
  16                 if (!$link) {
  17                         die("Connection failed: " . pg_last_error($link));
  18                 }
  19
  20                 return $link;
  21
  22         } else if (DB_TYPE == "mysql") {
  23                 $link = mysql_connect($host, $user, $pass);
  24                 if ($link) {
  25                         $result = mysql_select_db($db, $link);
  26                         if (!$result) {
  27                                 die("Can't select DB: " . mysql_error($link));
  28                         }
  29                         return $link;
  30                 } else {
  31                         die("Connection failed: " . mysql_error($link));
  32                 }
  33         }
  34 }
  35
  36 function db_escape_string($s) {
  37         if (DB_TYPE == "pgsql") {
  38                 return pg_escape_string($s);
  39         } else {
  40                 return mysql_real_escape_string($s);
  41         }
  42 }
  43
  44 function db_query($link, $query) {
  45         if (DB_TYPE == "pgsql") {
  46                 $result = pg_query($link, $query);
  47                 if (!$result) {
  48                         die("Query <i>$query</i> failed: " . pg_last_error($link));
  49                 }
  50                 return $result;
  51         } else if (DB_TYPE == "mysql") {
  52                 $result = mysql_query($query, $link);
  53                 if (!$result) {
  54                         die("Query <i>$query</i> failed: " . mysql_error($link));
  55                 }
  56                 return $result;
  57         }
  58 }
  59
  60 function db_query_2($query) {
  61         if (DB_TYPE == "pgsql") {
  62                 return pg_query($query);
  63         } else if (DB_TYPE == "mysql") {
  64                 return mysql_query($link);
  65         }
  66 }
  67
  68 function db_fetch_assoc($result) {
  69         if (DB_TYPE == "pgsql") {
  70                 return pg_fetch_assoc($result);
  71         } else if (DB_TYPE == "mysql") {
  72                 return mysql_fetch_assoc($result);
  73         }
  74 }
  75
  76
  77 function db_num_rows($result) {
  78         if (DB_TYPE == "pgsql") {
  79                 return pg_num_rows($result);
  80         } else if (DB_TYPE == "mysql") {
  81                 return mysql_num_rows($result);
  82         }
  83 }
  84
  85 function db_fetch_result($result, $row, $param) {
  86         if (DB_TYPE == "pgsql") {
  87                 return pg_fetch_result($result, $row, $param);
  88         } else if (DB_TYPE == "mysql") {
  89                 // FIXME
  90                 $line = mysql_fetch_assoc($result);
  91                 return $line[$param];
  92         }
  93 }
  94
  95 function db_close($link) {
  96         if (DB_TYPE == "pgsql") {
  97
  98                 return pg_close($link);
  99
 100         } else if (DB_TYPE == "mysql") {
 101                 return mysql_close($link);
 102         }
 103 }