branches/paul/db_connect.php

<?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" );
        }

}
?>
1	dpavlin	31	<?php
2	dpavlin	67	// Database connection parameters
3			$db_server = "yourlibrary.edu";
4			$db_user = "libdata";
5			$db_password = "changEth1s";
6			$db_name = "libdata";
7	dpavlin	31
8
9	dpavlin	67	// Establish a connection to the database server or bail out.
10			$db_link = @mysql_connect ($db_server, $db_user, $db_password)
11			or die ( "ERROR: Could not connect to the database server." );
12	dpavlin	31
13
14	dpavlin	67	// Switch to the selected database name or bail out.
15			$db_switch = @mysql_select_db ($db_name, $db_link )
16			or die ( "ERROR: Could not connect to the database." );
17	dpavlin	31
18
19	dpavlin	67	/**********************************************************
20			Function: mysql_tryquery($querystring)
21			Author: Paul Bramscher
22			Last Modified: 03.02.2004
23			***********************************************************
24			Incoming:
25			$querystring Typically an SQL statement, although
26			it can also be other mySQL directives
27			such as UNLOCK TABLES, etc.
28			***********************************************************
29			Outgoing:
30			$db_resource mySQL resource identifier for the
31			(successful) query.
32			***********************************************************
33			Purpose:
34			This function traps FALSE results for attempted mySQL
35			queries. If the $db_debug mode below is toggled on (1),
36			then additional error reporting is displayed.
37			**********************************************************/
38			function mysql_tryquery($querystring) {
39	dpavlin	31
40	dpavlin	67	// Database debug mode
41			$db_debug = 0;
42	dpavlin	31
43	dpavlin	67	// Determine whether the query was successful
44			$db_resource = @mysql_query($querystring);
45	dpavlin	31
46	dpavlin	67	// Success.
47			if ($db_resource) {
48			return $db_resource;
49			}
50	dpavlin	31
51	dpavlin	67	// Handle errors
52			else {
53
54			// Display debugging information if activated.
55			if ($db_debug == 1) {
56			printf("<hr><b>DATABASE ERROR DEBUGGING</b><br><br>\n");
57			printf("<b>mySQL error:</b><br>\n(#%s) %s<br><br>\n",
58			mysql_errno(), mysql_error());
59			printf("<b>Attempted query:</b><br>\n%s<hr>\n", $querystring);
60			}
61
62			// Gracefully end the HTML stream
63			@mysql_query ("UNLOCK TABLES");
64			die ("<br>The database is experiencing problems.</body></html>\n" );
65			}
66	dpavlin	31
67	dpavlin	67	}
68	dpavlin	31	?>