bgui/bugs/bugs_mysql.php

   1 <?
   2 /*
   3  * bugs_mysql.php
   4  *
   5  * @(#) $Header$
   6  *
   7  */
   8
   9 class bugs_mysql_class
  10 {
  11         var $database_hostname="";
  12         var $database_user="";
  13         var $database_password="";
  14
  15         var $database_connection=0;
  16
  17         Function Connect($database_name)
  18         {
  19                 global $bugs_database_host;
  20
  21                 if($this->database_connection!=0)
  22                 {
  23                         $bugs_debug("The connection to the bugs database is already established!\n");
  24                         return(0);
  25                 }
  26                 if(($this->database_connection=mysql_pconnect($this->database_hostname,$this->$database_user,$this->$database_password))<=0)
  27                 {
  28                         $bugs_debug("It was not possible to connect to the bugs database! (".mysql_error().")\n");
  29                         return(0);
  30                 }
  31                 mysql_select_db($database_name,$this->database_connection);
  32                 return($this->database_connection);
  33         }
  34
  35         Function Query($query)
  36         {
  37                 if($this->database_connection<=0)
  38                         $bugs_debug("The connection to the bugs database is not yet established!\n");
  39                 return(mysql_query($query,$this->database_connection));
  40         }
  41
  42         Function Error()
  43         {
  44                 return(mysql_error());
  45         }
  46
  47         Function CreateDatabase($name)
  48         {
  49                 if($this->database_connection==0)
  50                 {
  51                         if(($link=mysql_Connect($this->database_hostname,$this->database_user,$this->database_password))==0)
  52                                 return(0);
  53                 }
  54                 else
  55                         $link=$this->database_connection;
  56                 $success=mysql_create_db($name,$link);
  57                 if($this->database_connection==0)
  58                         mysql_Close($link);
  59                 return($success);
  60         }
  61
  62         Function Close()
  63         {
  64                 if($this->database_connection!=0)
  65                 {
  66                         mysql_Close($this->database_connection);
  67                         $this->database_connection=0;
  68                 }
  69         }
  70
  71         Function SeparateDateTime()
  72         {
  73                 return(0);
  74         }
  75
  76         Function DateFormat()
  77         {
  78                 return("Y-m-d");
  79         }
  80
  81         Function ScanDate($date)
  82         {
  83                 $scanned_date["year"]=strtok($date,"-");
  84                 $scanned_date["month"]=strtok("-");
  85                 $scanned_date["day"]=strtok(" ");
  86                 return($scanned_date);
  87         }
  88
  89         Function TextFieldsNeedLength()
  90         {
  91                 return(0);
  92         }
  93
  94         Function SupportAutoIncrement()
  95         {
  96                 return(1);
  97         }
  98
  99         Function SupportSequences()
 100         {
 101                 return(0);
 102         }
 103
 104         Function FetchInsertId()
 105         {
 106                 return(mysql_insert_id());
 107         }
 108
 109         Function NumberOfRows($result)
 110         {
 111                 return(mysql_num_rows($result));
 112         }
 113
 114         Function FreeResult($result)
 115         {
 116                 return(mysql_free_result($result));
 117         }
 118
 119         Function FetchNextRow($result)
 120         {
 121                 return(mysql_fetch_row($result));
 122         }
 123
 124         Function NumberOfFields($result)
 125         {
 126                 return(mysql_num_fields($result));
 127         }
 128
 129         Function FetchNextField($result)
 130         {
 131                 return(mysql_fetch_field($result));
 132         }
 133
 134         Function FetchArray($result)
 135         {
 136                 return(mysql_fetch_array($result));
 137         }
 138
 139         Function FetchResult($result,$row,$field)
 140         {
 141                 return(mysql_result($result,$row,$field));
 142         }
 143 };
 144
 145 ?>