PHP multiple MySQL connection though classes/objects?

Question

Here's the code I'm trying to make work:

<?php

class database {
    var $connection;
    function database($host,$username,$password,$database){
        $this->connection = mysql_connect($host, $username, $password);
        mysql_select_db($database,$this->connection);
    }
    function query($query){
        $query = mysql_query($query,$this->connection);
        return $query;
    }
}

$db = new database("localhost","root","password","database1");
$db2 = new database("SERVER2","root","password","database2");

$sql = $db->query("SELECT * FROM users WHERE name = 'Yifan' LIMIT 1");
$row = mysql_fetch_assoc($sql);

var_dump($row);

$sql = $db2->query("SELECT * FROM users WHERE name = 'Yifan' LIMIT 1");
$row = mysql_fetch_assoc($sql);

var_dump($row);

?>

So, in case you didn't understand that, I want to have two or more connections to mysql using objects, but the problem is, I get "bool(false)" as the first result, and the correct response for the second one. Any idea on what I'm doing wrong, or if it is even possible? Thanks.

You might want to consider migrating to mysqli, which is newer and more developed. — Itay Moav -Malimovka
– Itay Moav -Malimovka, Commented May 23, 2009 at 1:35
Thank you, one of the reason I'm doing classes for SQL connections is to support multiple servers. So class mysqlDB extends Database, class mysqliDB extends Database, and so on. — Yifan
– Yifan, Commented May 24, 2009 at 14:49

great_llama · Accepted Answer · 2009-05-23 00:31:54Z

7

The next parameter to mysql_connect is $new_link, can you try sending in a true there and see if it helps?

$this->connection = mysql_connect($host, $username, $password, true);

answered May 23, 2009 at 0:31

great_llama

11.7k4 gold badges36 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP multiple MySQL connection though classes/objects?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related