php - 获取其他用户的 ID 及其在数据库中的信息，

Question

当我以另一个用户身份使用mysql登录时，我在如何获取所选用户的ID及其信息时遇到问题，这两个表是相互连接的，我只是不知道如何获取ID其他用户，并将其传递给其他数据库

if(isset($_POST['send'])) {

$query =  "SELECT * FROM tblmessage INNER JOIN tblusers ON tblmessage.userid=tblusers.userid";
$res = mysqli_query($con,$query);

while ($row = mysqli_fetch_assoc($res)) 
{
    $receiverID = $row['userid'];
}

    $sender = $_SESSION['Email'];
    $receiver = $_POST['email'];
    $message = $_POST['textmessages'];
    $date = date("Y-m-d h:i:sa");

    $q = 'INSERT INTO `tblmessage`(`id`,`sender_name`,`receiver_name`,`receiver_id`,`message_text`,`date_time`,`userid`)
       VALUES("","'.$sender.'","'.$receiver.'","'.$receiverID.'","'.$message.'","'.$date.'","'.$user_id.'")';
    $r = mysqli_query($con, $q);

    if($r)
    {
            echo"<script>alert('Message Sent')</script>
                <script>window.location.href='messages.php?id=$receiverID';</script>";
    }   
    else
    {
        echo $q;
    }

}

标签： phphtmlmysql