/[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

Annotation of /branches/paul_xx/db_connect.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 67 - (hide annotations)
Thu Mar 18 19:24:54 2004 UTC (18 years, 2 months ago) by dpavlin
Original Path: branches/paul/db_connect.php
File size: 2001 byte(s)
updated to libdata 2.00

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 ?>

  ViewVC Help
Powered by ViewVC 1.1.26