PHP MYSQL，两张表

Question

我有两个表，我想在每个用户登录后回显总调用计数:

登录

Firstname | Lastname | Login ID
------------------------------
Tyler     | Durden    | 3

通话次数

Name        | Call Count | Open       | GrandTotal
------------------------------
Tyler Durden| 100        |    33      | 133

我尝试过:

 <?php

 $result = mysqli_query($mysqli, "SELECT * FROM csvdata WHERE Name=".$_SESSION['firstname']. ' ' .$_SESSION['lastname']." ");

while($res = mysqli_fetch_array( $result )) {

echo $res['Open'].' Open Calls';
echo $res['GrandTotal'].' Grand Total Calls';

 } 
 mysqli_close($mysqli);
?>

但它不起作用，我想我必须连接两个表才能使其工作。你觉得怎么样？

Answer 1

假设您的 Call Count 表实际上称为 csvdata，您需要通过在 WHERE name = 部分添加单引号来稍微格式化您的 SQL 请求字符串。

<?php

    $result = mysqli_query($mysqli, "SELECT * FROM csvdata WHERE Name='".$_SESSION['firstname']. ' ' .$_SESSION['lastname']."' ");

    while($res = mysqli_fetch_array( $result )) {

        echo $res['Call Count'].' Call Count';
        echo $res['Open'].' Open Calls';
        echo $res['GrandTotal'].' Grand Total Calls';

    } 
    mysqli_close($mysqli);
?>