在查询上查询2个数据库

Question

I want to ask, how do I make data appear on my friend's column page?

    $frnd = $conn->query("SELECT * FROM `friend` WHERE id = '".$_SESSION['uid']."' LIMIT 7");

    while($friend = mysqli_fetch_assoc($sql)){
        echo "'.$idu.'";
        echo "'.$name.'";
    }

I can't find, maybe a friend here can help me?

Answer 1

My friend you can query 2 different databases on the same query if:

1. The user/pass is the same for the 2 databases
2. The 2 databases are on the same server.

Here is an example of the query.

$query ="
SELECT
    *
FROM
    database1.databaseUser,
    database2.databaseFriend
WHERE
    database1.databaseUser.uid = database2.databaseFriend.idu
    AND database2.databaseFriend.id = '". $_SESSION['uid'] ."'
LIMIT 7
";

You have to include the databasename.table to be able to perform the query.

hope it helps.

This is your full code updated, please make the adjustment for the databases etc.

$query ="

SELECT
    *
FROM
    database1.databaseUser,
    database2.databaseFriend
WHERE
    database1.databaseUser.uid = database2.databaseFriend.idu
    AND database2.databaseFriend.id = '". $_SESSION['uid'] ."'
LIMIT 7
";

 $frnd = $conn->query($query);

    while($friend = mysqli_fetch_assoc($sql)){
        echo "'.$idu.'";
        echo "'.$name.'";
    }