1 |
dpavlin |
31 |
<?php |
2 |
dpavlin |
76 |
// Database connection parameters |
3 |
dpavlin |
77 |
$db_server = "localhost"; |
4 |
dpavlin |
76 |
$db_user = "libdata"; |
5 |
dpavlin |
77 |
$db_password = "libdatapw"; |
6 |
dpavlin |
76 |
$db_name = "libdata"; |
7 |
dpavlin |
31 |
|
8 |
|
|
|
9 |
dpavlin |
76 |
// Establish a connection to the database server or bail out. |
10 |
|
|
$db_link = @xx_connect ($db_server, $db_user, $db_password) |
11 |
|
|
or die ( "ERROR: Could not connect to the database server." ); |
12 |
dpavlin |
31 |
|
13 |
|
|
|
14 |
dpavlin |
76 |
// Switch to the selected database name or bail out. |
15 |
|
|
$db_switch = @xx_select_db ($db_name, $db_link ) |
16 |
|
|
or die ( "ERROR: Could not connect to the database." ); |
17 |
dpavlin |
31 |
|
18 |
|
|
|
19 |
dpavlin |
76 |
/********************************************************** |
20 |
|
|
Function: xx_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 xx_tryquery($querystring) { |
39 |
dpavlin |
31 |
|
40 |
dpavlin |
76 |
// Database debug mode |
41 |
|
|
$db_debug = 0; |
42 |
dpavlin |
31 |
|
43 |
dpavlin |
76 |
// Determine whether the query was successful |
44 |
|
|
$db_resource = @xx_query($querystring); |
45 |
dpavlin |
31 |
|
46 |
dpavlin |
76 |
// Success. |
47 |
|
|
if ($db_resource) { |
48 |
|
|
return $db_resource; |
49 |
|
|
} |
50 |
dpavlin |
31 |
|
51 |
dpavlin |
76 |
// 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 |
|
|
xx_errno(), xx_error()); |
59 |
|
|
printf("<b>Attempted query:</b><br>\n%s<hr>\n", $querystring); |
60 |
|
|
} |
61 |
|
|
|
62 |
|
|
// Gracefully end the HTML stream |
63 |
|
|
@xx_query ("UNLOCK TABLES"); |
64 |
|
|
die ("<br>The database is experiencing problems.</body></html>\n" ); |
65 |
|
|
} |
66 |
dpavlin |
31 |
|
67 |
dpavlin |
76 |
} |
68 |
dpavlin |
31 |
?> |