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