一个用于mysql的数据库抽象层函数库
程序员文章站
2022-06-22 15:32:07
<?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 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 "\n\n<p><b>".@mysql_error()."</b><p>\n\n";
}
?>
//
// 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 "\n\n<p><b>".@mysql_error()."</b><p>\n\n";
}
?>
上一篇: PHP网上调查系统
下一篇: 动态新闻发布的实现及其技巧