dongwei1234 2017-08-23 17:09
浏览 257
已采纳

PHP通过id从数据库回显

How do I echo a user's name and his specific country? Like this:

Account name: leo

Country: Germany

The account name is working.

PHP at the top of the page is:

<?php 
    session_start(); 

    if (!isset($_SESSION['username'])) {
        $_SESSION['msg'] = "You must log in first";
        header('location: login.php');
    }

    if (isset($_GET['logout'])) {
        session_destroy();
        unset($_SESSION['username']);
        header("location: login.php");
    }
?>

Connect to database (seperate file server.php):

$db = mysqli_connect('localhost', 'root', '', 'registration');

HTML:

<li class="p-li">Account name: <?php echo $_SESSION['username']; ?></li>
<li class="p-li">Country:<?php echo $_a['a']; ?> </li>

My database

  • 写回答

1条回答 默认 最新

  • dongsetan3216 2017-08-23 17:28
    关注

    You need to define $_a at the moment it doesn't appear to be referencing anything so would be blank. Forgetting that though you asked about SQL query in the comments.

    SQL Query would be

    $id = $_SESSION['username'];   
    
    "SELECT Country FROM registration WHERE username='%".id."%'"
    

    Please be aware that's just a snippet of code as you said you wanted the SQL query. I defined $id as the users username as you said you wanted to get country by username, I would though recommend you use the id column of the table as this will always be unique.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 Html备忘录页面制作
  • ¥15 黄永刚的晶体塑性子程序中输入的材料参数里的晶体取向参数是什么形式的?
  • ¥20 数学建模来解决我这个问题
  • ¥15 计算机网络ip分片偏移量计算头部是-20还是-40呀
  • ¥15 stc15f2k60s2单片机关于流水灯,时钟,定时器,矩阵键盘等方面的综合问题
  • ¥15 YOLOv8已有一个初步的检测模型,想利用这个模型对新的图片进行自动标注,生成labellmg可以识别的数据,再手动修改。如何操作?
  • ¥30 NIRfast软件使用指导
  • ¥20 matlab仿真问题,求功率谱密度
  • ¥15 求micropython modbus-RTU 从机的代码或库?
  • ¥15 django5安装失败