--- branches/paul/db_connect.php	2004/03/04 21:19:42	32
+++ branches/paul/db_connect.php	2004/03/18 19:24:54	67
@@ -1,42 +1,68 @@
 <?php
+// Database connection parameters
+$db_server      = "yourlibrary.edu";
+$db_user        = "libdata";
+$db_password    = "changEth1s";
+$db_name        = "libdata";
+
+
+// Establish a connection to the database server or bail out.
+$db_link = @mysql_connect ($db_server, $db_user, $db_password)
+or die ( "ERROR: Could not connect to the database server." );
+
+
+// Switch to the selected database name or bail out.
+$db_switch = @mysql_select_db ($db_name, $db_link )
+or die ( "ERROR: Could not connect to the database." );
+
+
+/**********************************************************
+Function: mysql_tryquery($querystring)
+Author: Paul Bramscher
+Last Modified: 03.02.2004
+***********************************************************
+Incoming:
+$querystring		Typically an SQL statement, although
+			it can also be other mySQL directives
+			such as UNLOCK TABLES, etc.
+***********************************************************
+Outgoing:
+$db_resource		mySQL resource identifier for the
+			(successful) query.
+***********************************************************
+Purpose:
+This function traps FALSE results for attempted mySQL
+queries.  If the $db_debug mode below is toggled on (1),
+then additional error reporting is displayed.
+**********************************************************/
+function mysql_tryquery($querystring) {
+
+	// Database debug mode
+	$db_debug = 0;
+
+	// Determine whether the query was successful
+	$db_resource = @mysql_query($querystring);
+
+	// Success.
+	if ($db_resource) {
+		return $db_resource;
+	}
+
+	// Handle errors
+	else {
+	
+		// Display debugging information if activated.
+		if ($db_debug == 1) {
+			printf("<hr><b>DATABASE ERROR DEBUGGING</b><br><br>\n");
+			printf("<b>mySQL error:</b><br>\n(#%s) %s<br><br>\n",
+				mysql_errno(), mysql_error());
+			printf("<b>Attempted query:</b><br>\n%s<hr>\n", $querystring);
+		}
+		
+		// Gracefully end the HTML stream
+		@mysql_query ("UNLOCK TABLES");
+		die ("<br>The database is experiencing problems.</body></html>\n" );
+	}
 
-    /****************************************************************/
-
-    /* constants */
-    $DEBUG = 0; 
-
-    /****************************************************************/
-
-	/* database parameters */
-	$db_nam = "libdata";
-	$db_srv = "localhost";
-	$db_usr = "libdata";
-	$db_pwd = "libdatapw";
-
-    /****************************************************************/
-
-    /* establish a connection to the database or bailout */
-    $con = mysql_connect ( $db_srv, $db_usr, $db_pwd )
-        or die ( "ERROR: Could not connect to database server!" );
-    $result = mysql_select_db ( $db_nam, $con )
-        or die ( "ERROR: Could not connect to database!" );
-
-    /****************************************************************/
-
-
-    /* some useful functions */
-
-    /* return an error message from a failed sql query */
-    function sql_err ( $p_sql ) {
-        printf ( "ERROR: Query failed.<br>%s<br>%s: %s<br>\n",
-                 $p_sql, mysql_errno(), mysql_error() );
-        return 1;
-    }
-
-    /* finish off the html stream and die */
-    function bailout() {
-        die ( "Bailing Out!<br>\n</body></html>\n" );
-    }
-
-
+}
 ?>