Jump to content

Question

Posted

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

[CODE]
<?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.

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

Posted

[url="http://stackoverflow.com/questions/274892/how-do-you-connect-to-multiple-mysql-databases-on-a-single-webpage"]http://stackoverflow...-single-webpage[/url]

Here you go.

Although if I may suggest you should be using PDO since it's more secure and would work with future PHP versions. Since mysql_connect() is going to be removed in the future.
1 person likes this

Share this post


Link to post
Share on other sites
  • 0

Posted

I came to help but looked like the answer is already posted within the link.
1 person likes this

Share this post


Link to post
Share on other sites
  • 0

Posted

Awesome thanks for the help guys, it's working perfectly now!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.