[phpMP-CVS] CVS: phpMP/dba mysql.dba,1.9,1.10

[Brian R. <hei...@us...>]

Update of /cvsroot/phpmp/phpMP/dba
In directory usw-pr-cvs1:/tmp/cvs-serv17457/dba

Modified Files:
	mysql.dba 
Log Message:
Updated DBA for mySQL.  Updated templating procedure.

Index: mysql.dba
===================================================================
RCS file: /cvsroot/phpmp/phpMP/dba/mysql.dba,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** mysql.dba	10 Apr 2002 21:22:02 -0000	1.9
--- mysql.dba	11 Apr 2002 04:15:39 -0000	1.10
***************
*** 44,50 ****
  class DBA{
    
    function query($query) {
      global $MPCONF;
!     if (!$db = @mysql_connect($MPCONF['DB']['host'], $MPCONF['DB']['username'], $MPCONF['DB']['password'])) {
        $result = 0;
        die("db connect error");
--- 44,64 ----
  class DBA{
    
+   function  connect() {
+     if (!$db = @mysql_connect($MPCONF['DB']['host'], $MPCONF['DB']['username'], $MPCONF['DB']['password'])) {
+       $result = 0;
+     } else {
+       $result = 1;
+     }
+     return $result;
+   }
+   
+   function close($db) {
+     @mysql_close($db);
+   }
+   
    function query($query) {
      global $MPCONF;
!     $db = $this->connect();
!     if (!$db) {
        $result = 0;
        die("db connect error");
***************
*** 52,60 ****
      else {
        // Execute query
!       @mysql_select_db($MPCONF['DB']['database']);
        $result = @mysql_query($query, $db) or die("MySQL Error: ".mysql_error($db));
      }
!     @mysql_close($db);
      return $result;
    }
  }
--- 66,82 ----
      else {
        // Execute query
!       @mysql_select_db($MPCONF['DB']['database'], $db);
        $result = @mysql_query($query, $db) or die("MySQL Error: ".mysql_error($db));
      }
!     $this->close($db);
      return $result;
+   }
+   
+   function num_rows($query) {
+     return @mysql_num_rows($query);
+   }
+   
+   function fetch_array($query) {
+     return @mysql_fetch_array($query);
    }
  }