1
2//
3// SourceForge: Breaking Down the Barriers to Open Source Development
4// Copyright 1999-2000 (c) The SourceForge Crew
5// http://sourceforge.net
6//
7// $Id: database.php,v 1.6 2000/04/11 14:17:13 cvs Exp $
8//
9// /etc/local.inc includes the machine specific database connect info
10
11function db_connect() {
12global $sys_dbhost,$sys_dbuser,$sys_dbpasswd;
13$conn = mysql_connect($sys_dbhost,$sys_dbuser,$sys_dbpasswd);
14if (!$conn) {
15echo mysql_error();
16}
17return $conn;
18}
19
20function db_query($qstring,$print=0) {
21global $sys_dbname;
22return @mysql($sys_dbname,$qstring);
23}
24
25function db_numrows($qhandle) {
26// return only if qhandle exists, otherwise 0
27if ($qhandle) {
28return @mysql_numrows($qhandle);
29} else {
30return 0;
31}
32}
33
34function db_result($qhandle,$row,$field) {
35return @mysql_result($qhandle,$row,$field);
36}
37
38function db_numfields($lhandle) {
39return @mysql_numfields($lhandle);
40}
41
42function db_fieldname($lhandle,$fnumber) {
43return @mysql_fieldname($lhandle,$fnumber);
44}
45
46function db_affected_rows($qhandle) {
47return @mysql_affected_rows();
48}
49
50function db_fetch_array($qhandle) {
51return @mysql_fetch_array($qhandle);
52}
53
54function db_insertid($qhandle) {
55return @mysql_insert_id($qhandle);
56}
57
58function db_error() {
59return "\n\n
<p><b>".@mysql_error()."</b><p>\n\n";
}