Menu
Community /Pin to ProfileBookmark
@NogDogMar 09.2010 — #Here's a quick (and untested) cut at how you might approach it:
OOP Class can’t close connection
I am trying to write a function that closes the connection created in the following class:
[code=php]
class dbConnect {
function connect($dataB) {
$conn=mysql_connect(“127.0.0.1″,”username”,”password”) or die (mysql_error());
$db=mysql_select_db($dataB,$conn) or die (“Unable to connect to database1”);
}
function closeConnect($conn) {
mysql_close($conn);
}
}
to open a connection, I type:
[code=php]
$connection1-> new dbConnect();
$sql=$connection1->connect($dataB);
I know the function closeConnect() isn’t working. What will make it work?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogMar 09.2010 — #Here's a quick (and untested) cut at how you might approach it:[code=php]
<?php
class dbConnect
{
public $conn;
private $dbHost = "127.0.0.1";
private $dbUser = "username";
private $dbPassword = "password";
function connect($dataB)
{
$this->conn = mysql_connect($this->dbHost,
$this->dbUser,
$this->dbPassword);
if ($this->conn == false) {
throw new Exception(mysql_error());
}
$db = mysql_select_db($dataB, $conn);
if ($db == false) {
throw new Exception("Unable to connect to database1");
}
}
function closeConnect()
{
if (!empty($this->conn)) {
mysql_close($this->conn);
}
}
function __destruct()
{
$this->closeConnect();
}
}
[/code]