doudai8083 2019-03-30 15:19
浏览 70

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

I am having a problem on how to get the id of the selected user along with it's information while I am logged in as an another user, using mysql, the two tables is innerjoined with each other I just dont know how to get the ID of other user, and passing it on other database

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;
    }

}

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度