php_library/fboprime/db.inc

<?php
//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/db.inc,v 1.3 2006/04/25 16:53:39 dashley Exp $
//--------------------------------------------------------------------------------------------------------------
//db.inc--FboPrime Database Functions
//Copyright (C) 2006  David T. Ashley
//
//This program is free software; you can redistribute it and/or
//modify it under the terms of the GNU General Public License
//as published by the Free Software Foundation; either version 2
//of the License, or (at your option) any later version.
//
//This program is distributed in the hope that it will be useful,
//but WITHOUT ANY WARRANTY; without even the implied warranty of
//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//GNU General Public License for more details.
//
//You should have received a copy of the GNU General Public License
//along with this program; if not, write to the Free Software
//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
//********************************************************************************
//This contains constants and functions used to operate on the MySQL database
//as a whole.
//--------------------------------------------------------------------------------------------------------------
require_once("confighard.inc");
require_once("global.inc");
//--------------------------------------------------------------------------------------------------------------
//Locks all MySQL database tables in write mode (effectively locking the database).  This is the only
//form of locking supported by FBO-Prime--all or nothing.
//
//Unit-tested 20060422.
//
function DB_db_lock()
   {
   global $GLOBAL_dbhandle;
   global $CONFIGHARD_DBTABLES_ARRAY;

   $c = count($CONFIGHARD_DBTABLES_ARRAY);
   $query_string = "LOCK TABLES";
   for ($i=0; $i<$c; $i++)
      {
      $query_string .= (" " . $CONFIGHARD_DBTABLES_ARRAY[$i] . " WRITE");
      if ($i < ($c-1))
         $query_string .= ",";
      }

   //echo " " . $query_string . " ";

   mysql_query($query_string, $GLOBAL_dbhandle);
   }
//
//--------------------------------------------------------------------------------------------------------------
//Unocks all MySQL database tables.
//
//Unit-tested 20060422.
//
function DB_db_unlock()
   {
   global $GLOBAL_dbhandle;

   //In the case of the UNLOCK command, things are simpler.  If the list of tables is omitted,
   //everything is unlocked.
   mysql_query("UNLOCK TABLES", $GLOBAL_dbhandle);
   }
//
//--------------------------------------------------------------------------------------------------------------
//Performs the necessary shutdown actions in the event that the PHP script shuts down abnormally.  At
//present, this consists only of unlocking the database tables.  The FBO-Prime manual contains
//more information about locking, persistent connections, etc.
//
function DB_db_shutdown_func()
   {
   global $GLOBAL_dbhandle;

   //If the global variable is FALSE, this is a signal that either the database connection
   //could not be opened, or else that the connection has already been closed.
   //
   if ($GLOBAL_dbhandle !== FALSE)
      {
      //In the case of the UNLOCK command, things are simpler.  If the list of tables is omitted,
      //everything is unlocked.
      mysql_query("UNLOCK TABLES", $GLOBAL_dbhandle);
      }
   }
//
//--------------------------------------------------------------------------------------------------------------
//End of $RCSfile: db.inc,v $.
//--------------------------------------------------------------------------------------------------------------
?>
1	<?php
2	//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/db.inc,v 1.3 2006/04/25 16:53:39 dashley Exp $
3	//--------------------------------------------------------------------------------------------------------------
4	//db.inc--FboPrime Database Functions
5	//Copyright (C) 2006 David T. Ashley
6	//
7	//This program is free software; you can redistribute it and/or
8	//modify it under the terms of the GNU General Public License
9	//as published by the Free Software Foundation; either version 2
10	//of the License, or (at your option) any later version.
11	//
12	//This program is distributed in the hope that it will be useful,
13	//but WITHOUT ANY WARRANTY; without even the implied warranty of
14	//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15	//GNU General Public License for more details.
16	//
17	//You should have received a copy of the GNU General Public License
18	//along with this program; if not, write to the Free Software
19	//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20	//********************************************************************************
21	//This contains constants and functions used to operate on the MySQL database
22	//as a whole.
23	//--------------------------------------------------------------------------------------------------------------
24	require_once("confighard.inc");
25	require_once("global.inc");
26	//--------------------------------------------------------------------------------------------------------------
27	//Locks all MySQL database tables in write mode (effectively locking the database). This is the only
28	//form of locking supported by FBO-Prime--all or nothing.
29	//
30	//Unit-tested 20060422.
31	//
32	function DB_db_lock()
33	{
34	global $GLOBAL_dbhandle;
35	global $CONFIGHARD_DBTABLES_ARRAY;
36
37	$c = count($CONFIGHARD_DBTABLES_ARRAY);
38	$query_string = "LOCK TABLES";
39	for ($i=0; $i<$c; $i++)
40	{
41	$query_string .= (" " . $CONFIGHARD_DBTABLES_ARRAY[$i] . " WRITE");
42	if ($i < ($c-1))
43	$query_string .= ",";
44	}
45
46	//echo " " . $query_string . " ";
47
48	mysql_query($query_string, $GLOBAL_dbhandle);
49	}
50	//
51	//--------------------------------------------------------------------------------------------------------------
52	//Unocks all MySQL database tables.
53	//
54	//Unit-tested 20060422.
55	//
56	function DB_db_unlock()
57	{
58	global $GLOBAL_dbhandle;
59
60	//In the case of the UNLOCK command, things are simpler. If the list of tables is omitted,
61	//everything is unlocked.
62	mysql_query("UNLOCK TABLES", $GLOBAL_dbhandle);
63	}
64	//
65	//--------------------------------------------------------------------------------------------------------------
66	//Performs the necessary shutdown actions in the event that the PHP script shuts down abnormally. At
67	//present, this consists only of unlocking the database tables. The FBO-Prime manual contains
68	//more information about locking, persistent connections, etc.
69	//
70	function DB_db_shutdown_func()
71	{
72	global $GLOBAL_dbhandle;
73
74	//If the global variable is FALSE, this is a signal that either the database connection
75	//could not be opened, or else that the connection has already been closed.
76	//
77	if ($GLOBAL_dbhandle !== FALSE)
78	{
79	//In the case of the UNLOCK command, things are simpler. If the list of tables is omitted,
80	//everything is unlocked.
81	mysql_query("UNLOCK TABLES", $GLOBAL_dbhandle);
82	}
83	}
84	//
85	//--------------------------------------------------------------------------------------------------------------
86	//End of $RCSfile: db.inc,v $.
87	//--------------------------------------------------------------------------------------------------------------
88	?>