[Openupload-svn-update] SF.net SVN: openupload:[132] trunk/lib/modules/db
Status: Beta
Brought to you by:
tsdogs
|
From: <ts...@us...> - 2008-11-07 19:09:38
|
Revision: 132
http://openupload.svn.sourceforge.net/openupload/?rev=132&view=rev
Author: tsdogs
Date: 2008-11-07 19:09:35 +0000 (Fri, 07 Nov 2008)
Log Message:
-----------
Add database connection close
Modified Paths:
--------------
trunk/lib/modules/db/mysql.inc.php
trunk/lib/modules/db/pgsql.inc.php
Modified: trunk/lib/modules/db/mysql.inc.php
===================================================================
--- trunk/lib/modules/db/mysql.inc.php 2008-11-07 19:08:56 UTC (rev 131)
+++ trunk/lib/modules/db/mysql.inc.php 2008-11-07 19:09:35 UTC (rev 132)
@@ -12,12 +12,16 @@
function init() {
/* connect to the database */
mysql_connect($this->config['host'],$this->config['user'],$this->config['password'])
- or die(tr('ERROR: connection to database failed!'));
+ or die('ERROR: connection to database failed!');
- $this->db = mysql_select_db($this->config['name']);// or die('ERROR: database could not be opened');
+ $this->db = mysql_select_db($this->config['name']) or die('ERROR: database could not be opened');
}
+ function free() {
+ mysql_close();
+ }
+
function newId($tbl,$field = 'id',$keys = array ()) {
$sql = 'SELECT max(`'.$field.'`) as newid FROM `'.$this->prefix.$tbl.'`';
if (count($keys)>0) {
Modified: trunk/lib/modules/db/pgsql.inc.php
===================================================================
--- trunk/lib/modules/db/pgsql.inc.php 2008-11-07 19:08:56 UTC (rev 131)
+++ trunk/lib/modules/db/pgsql.inc.php 2008-11-07 19:09:35 UTC (rev 132)
@@ -23,6 +23,10 @@
$this->db = pg_connect($str) or die('ERROR: connection to db failed!');
}
+ function free() {
+ pg_close($this->db);
+ }
+
function newId($tbl,$field = 'id',$keys = array ()) {
$sql = 'SELECT max("'.$field.'") as newid FROM "'.$this->prefix.$tbl.'"';
if (count($keys)>0) {
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|