Class connection
Posted: Mon Jun 25, 2007 12:25 am
I want to create a class for connecting to database
i am trying to connect in two databases:
but it has an error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\web\htdocs\websites\angel_test\angel.php on line 70
what's wrong with my code?.
anyone can help.
thanks.
i am trying to connect in two databases:
but it has an error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\web\htdocs\websites\angel_test\angel.php on line 70
what's wrong with my code?.
anyone can help.
thanks.
Code: Select all
<?php
class DBConnection
{
public $db;
public $username;
public $password;
public $host;
/**
* Constructor
*
* @param string $username
* @param string $password
* @param string $host
*/
public function __construct($host, $username, $password)
{
$this->host = $host;
$this->username = $username;
$this->password = $password;
}
/**
* Connect to database if database exist
*
* @return string connection
*/
public function connectToDatabase()
{
$this->connect = @mysql_connect($this->host, $this->username, $this->password)or
trigger_error("Unexpected connection, try setting details first.", E_USER_ERROR);
return $this->connect;
}
/**
* Select database persistent
*
* @param string $db
* @return database
*/
public function selectDatabase($db)
{
return mysql_select_db($db, $this->connect)or die('could not select db');
}
/**
* Close connection
*
* @return unset connection
*/
public function closeConnection()
{
return mysql_close($this->connect);
}
}
//usage
$db1 = new DBConnection("localhost", "root", "");
//connection 1
$con1 = $db1->connectToDatabase();
$d1 = $db1->selectDatabase("sample1");
//connection 2
$con2 = $db1->connectToDatabase();
$d2 = $db1->selectDatabase("sample2");
$result = mysql_query("select * from tbl_sample1",$con1);
$row = mysql_fetch_object($result);
echo $row->address;
?>