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                 return pg_connect("host=$host dbname=$db user=$user password=$pass");
   9
  10         } else if (DB_TYPE == "mysql") {
  11                 $link = mysql_connect($host, $user, $pass);
  12                 if ($link) {
  13                         mysql_select_db($db, $link);
  14                 }
  15                 return $link;
  16         }
  17 }
  18
  19 function db_escape_string($s) {
  20         if (DB_TYPE == "pgsql") {
  21                 return pg_escape_string($s);
  22         } else {
  23                 return mysql_real_escape_string($s);
  24         }
  25 }
  26
  27 function db_query($link, $query) {
  28         if (DB_TYPE == "pgsql") {
  29                 return pg_query($link, $query);
  30         } else if (DB_TYPE == "mysql") {
  31                 return mysql_query($query, $link);
  32         }
  33 }
  34
  35 function db_query_2($query) {
  36         if (DB_TYPE == "pgsql") {
  37                 return pg_query($query);
  38         } else if (DB_TYPE == "mysql") {
  39                 return mysql_query($link);
  40         }
  41 }
  42
  43 function db_fetch_assoc($result) {
  44         if (DB_TYPE == "pgsql") {
  45                 return pg_fetch_assoc($result);
  46         } else if (DB_TYPE == "mysql") {
  47                 return mysql_fetch_assoc($result);
  48         }
  49 }
  50
  51
  52 function db_num_rows($result) {
  53         if (DB_TYPE == "pgsql") {
  54                 return pg_num_rows($result);
  55         } else if (DB_TYPE == "mysql") {
  56                 return mysql_num_rows($result);
  57         }
  58 }
  59
  60 function db_fetch_result($result, $row, $param) {
  61         if (DB_TYPE == "pgsql") {
  62                 return pg_fetch_result($result, $row, $param);
  63         } else if (DB_TYPE == "mysql") {
  64                 // FIXME
  65                 $line = mysql_fetch_assoc($result);
  66                 return $line[$param];
  67         }
  68 }
  69
  70 function db_close($link) {
  71         if (DB_TYPE == "pgsql") {
  72
  73                 return pg_close($link);
  74
  75         } else if (DB_TYPE == "mysql") {
  76                 return mysql_close($link);
  77         }
  78 }