1 |
<?php |
2 |
// Database connection parameters |
3 |
$db_server = "yourlibrary.edu"; |
4 |
$db_user = "libdata"; |
5 |
$db_password = "changEth1s"; |
6 |
$db_name = "libdata"; |
7 |
|
8 |
|
9 |
// 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 |
|
13 |
|
14 |
// 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 |
|
18 |
|
19 |
/********************************************************** |
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 |
|
40 |
// Database debug mode |
41 |
$db_debug = 0; |
42 |
|
43 |
// Determine whether the query was successful |
44 |
$db_resource = @mysql_query($querystring); |
45 |
|
46 |
// Success. |
47 |
if ($db_resource) { |
48 |
return $db_resource; |
49 |
} |
50 |
|
51 |
// 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 |
|
67 |
} |
68 |
?> |