PHP multi database connect

Question

<?
    $db1 = mysql_connect("localhost","root","root") or dir("can not connect Mysql Server");
    mysql_select_db("1",$db1) or dir("Can not connect to the MySQL Server.");

    $db2 = mysql_connect("localhost","root","root") or dir("can not connect Mysql Server");
    mysql_select_db("2",$db2) or dir("Can not connect to the MySQL Server.");
?>

$result = mysql_query("SELECT * FROM db1.tags WHERE db1.catalog='fresh tag' ");

If I connect from a multi database, how to make a MySQL query from db1?

Why don't you do it OO, which makes it possible for you to do $db1->query("SELECT * FROM db1.tags WHERE db1.catalog = 'fresh tag'"); instead. — Machiel
– Machiel, Commented Dec 8, 2010 at 20:30

Darryl E. Clarke · Accepted Answer · 2010-12-08 20:27:14Z

8

Specify it in the query.

$result = mysql_query($query, $db1);

If the second parameter ($db1) is omitted, it will use the last defined resource ($db2)

answered Dec 8, 2010 at 20:27

Darryl E. Clarke

7,6473 gold badges30 silver badges37 bronze badges

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

Comments

Pekka · Accepted Answer · 2010-12-08 20:26:48Z

2

Look in the manual.

resource mysql_query ( string $query [, resource $link_identifier ] )

Like you already do for mysql_select_db(), you can specify the connection as the second parameter.

answered Dec 8, 2010 at 20:26

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Comments

Brad Christie · Accepted Answer · 2010-12-08 20:27:21Z

2

The second parameter of mysql_query is the connection resource. it will query against that connection.

answered Dec 8, 2010 at 20:27

Brad Christie

102k16 gold badges160 silver badges200 bronze badges

Comments

Paul Schreiber · Accepted Answer · 2010-12-08 20:27:52Z

2

See the mysql_query documentation. You just pass in link_identifier as the second parameter.

$result = mysql_query("SELECT * FROM db1.tags WHERE db1.catalog='fresh tag'", $db1);

answered Dec 8, 2010 at 20:27

Paul Schreiber

12.6k4 gold badges44 silver badges63 bronze badges

Comments

Luis Alvarado · Accepted Answer · 2010-12-08 20:30:05Z

1

If they are both in localhost you do not need to connect 2 times. you could simply do something like this:

SELECT * FROM db2.tags WHERE id IN(SELECT id FROM db1.tags WHERE id=1)

This way you can compare between both Databases without making two connections.

Now if you do not have both in the same place then you can do something like this:

mysql_select_db(db1);
$db1Result = mysql_query("SELECT * FROM db1.tags WHERE id=1");
mysql_select_db(db2);
$db2Result = mysql_query("SELECT * FROM db2.tags WHERE id=1");

And after that compare the results from $db1Result with the ones from $db2Result.

answered Dec 8, 2010 at 20:30

Luis Alvarado

9,46612 gold badges49 silver badges63 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2011-02-16 19:55:07Z

1

Use

mysql_query($query, $db1);

or

mysql_select_db();

edited Feb 16, 2011 at 19:55

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Dec 8, 2010 at 20:29

Pradeep Singh

3,6323 gold badges33 silver badges42 bronze badges

Comments

David · Accepted Answer · 2017-05-11 07:12:27Z

0

//get my conn
include "../../database.php";
//put data in
//get data
if($_GET['attribute']!=''){
    //prepare
    $stmt=$conn->prepare('INSERT INTO databasetablename (attribute) VALUES (?)');
    //bind
    $stmt->bind_param('s',$_GET['attribute']);
    //execute
    $stmt->execute();
    $stmt->close();
}

    //print data out
    $res=$conn->query("SELECT attribute FROM databasetablename");
    if($res){
        while($hold = mysqli_fetch_array($res,MYSQL_ASSOC)){
            $record[]=$hold;
            echo $hold['attribute'];
        }
    }
    echo '<hr/>';
    //print out
        foreach($record as $cur){
            echo $cur['attribute'].<br/>;
        }

answered May 11, 2017 at 7:12

David

1

Collectives™ on Stack Overflow

PHP multi database connect

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest