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