PHP Classes
Icontem

File: database.php


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Colin Sandy Pittendrigh  >  Site Bot  >  database.php  
File: database.php
Role: Auxiliary script
Content type: text/plain
Description: mysql connect util
Class: Site Bot
Recursive-automic site buider: static OR dynamic
 

Contents

Class file image Download
<?php

include "database_config.inc";

$dconn;

function 
dbr_connect()
{
   global 
$dconn$sys_db_host$sys_db_user$sys_db_passwd$sys_db_name;
   
   if(
$dconn == null)
   {
      
$dconn =
      
mysql_pconnect($sys_db_host,$sys_db_user,$sys_db_passwd)
        or die (
"bad connect");
      
mysql_select_db($sys_db_name);
   }
   
   if (!
$dconn)
   {
      echo 
"failed connection on ($sys_db_host,$sys_db_user,$sys_db_passwd)<br>";
      echo 
mysql_error();
   }
   return 
$dconn;
}


function 
dbr_query($qstring,$print=0)
{
   global 
$dconn$sys_db_name$sys_db_host$sys_db_user$sys_db_passwd;
   
   if (!
$dconn)
   
$dconn mysql_pconnect($sys_db_host,$sys_db_user,$sys_db_passwd);
   
   return @
mysql($sys_db_name,$qstring);
}


function 
dbr_numrows($qhandle)
{
   
// return only if qhandle exists, otherwise 0
   
if ($qhandle)
   {
      return @
mysql_numrows($qhandle);
   }
   else
   {
      return 
0;
   }
}


function 
dbr_result($qhandle,$row,$field)
{
   return @
mysql_result($qhandle,$row,$field);
}


function 
dbr_numfields($lhandle)
{
   return @
mysql_numfields($lhandle);
}


function 
dbr_fieldname($lhandle,$fnumber)
{
   return @
mysql_fieldname($lhandle,$fnumber);
}


function 
dbr_affected_rows($qhandle)
{
   return @
mysql_affected_rows();
}

function 
dbr_fetch_row($result)
{
   return @
mysql_fetch_row($result);
}

function 
dbr_fetch_array($qhandle)
{
   return @
mysql_fetch_array($qhandle);
}


function 
dbr_insertid($qhandle)
{
   return @
mysql_insert_id($qhandle);
}


function 
dbr_error()
{
   return 
"\n\n<P><B>".@mysql_error()."</B><P>\n\n";
}

function 
dbr_disconnect()
{
   global 
$dconn;
   return @
mysql_close ($dconn);
}

function 
dbr_free_result($result)
{
   return @
mysql_free_result($result);
}


?>

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products