• 0

PHP Multiple Database Connections causing issues


Question

Okay, so I am working on a website that will use 2 database connections. The connection class looks like:


<?php
class connection {
// variables to store the database information
private $host;// = "localhost";
private $username;// = "root";
private $password;// = "";
private $database;// = "";

//variables to store database connection
private $link;
private $result;
public $query;


//constructer
function __construct($db, $server = "localhost",$user = "root",$pass="")
{
$this->host = $server;
$this->username = $user;
$this->password = $pass;
$this->database = $db;

$this->link = mysql_connect($this->host,$this->username, $this->password);
mysql_select_db($this->database,$this->link);
return $this->link;
}
function Query($query)
{
if(!empty($query)) {
$this->query = $query;
$this->result = mysql_query($this->query,$this->link);
return $this->result;
}else {
return false;
}
}

function Fetch($result="")
{
if (empty($result)) {$result = $this->result;}
return mysql_fetch_assoc($result);
}

}
?>
[/CODE]

I create two objects in my index.php file:

[CODE]
<?php
session_start();

include('website/includes/connection.php');
$progdb = new connection("progdb");
$coredb = new connection("coredb");
?>
[/CODE]

If I do something like:

[CODE]
$query = "SELECT Count(skuID) FROM sku";
$result = $coredb->Query($query);
if ($result & mysql_num_rows($result) > 0)
{
//CODE
}
[/CODE]

It works, however doing the same with the progdb (with proper tables) does not, the Query function returns false.

BUT... if I swap the order in which they are created (so $coredb before $progdb) then the opposite is true, the progdb queries work but the coredb queries fail.

What am I doing wrong? I hope I have provided enough information. I am stumped.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.