A database abstraction layer function library for mysql_PHP tutorial

//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: database.php,v 1.6 2000/04/11 14:17:13 cvs Exp $
//
// /etc/local.inc includes the machine specific database connect info

function db_connect() {
global $sys_dbhost,$sys_dbuser,$sys_dbpasswd;
$conn = mysql_connect($sys_dbhost,$sys_dbuser,$sys_dbpasswd);
if (!$conn) {
echo mysql_error();
}
return $conn;
}

function db_query($qstring,$print=0) {
global $sys_dbname;
return @mysql($sys_dbname,$qstring);
}

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

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

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

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

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

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

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

function db_error() {
return "nn

".@mysql_error()."

nn";
}

?>

  

http://www.bkjia.com/PHPjc/315898.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/315898.htmlTechArticle?php // // SourceForge: Breaking Down the Barriers to Open Source Development // Copyright 1999-2000 (c) The SourceForge Crew // http://sourceforge.net // // $Id: database.php,v 1.6...