/[libdata]/branches/paul_xx/db_connect.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /branches/paul_xx/db_connect.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 69 - (show annotations)
Thu Mar 18 20:01:09 2004 UTC (17 years, 10 months ago) by dpavlin
File size: 1977 byte(s)
current libdata with replaced mysql_* calls to xx_*

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 = @xx_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 = @xx_select_db ($db_name, $db_link )
16 or die ( "ERROR: Could not connect to the database." );
17
18
19 /**********************************************************
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
40 // Database debug mode
41 $db_debug = 0;
42
43 // Determine whether the query was successful
44 $db_resource = @xx_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 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
67 }
68 ?>

  ViewVC Help
Powered by ViewVC 1.1.26