php - 从数据库中获取一个值

Question

我目前正在尝试从数据库中获取名称并将其打印在页面上。该名称与用户名一起在数据库表中。用户名可从 session 访问。我正在尝试这样:

<?php

include('checksession.php');
require('db-connection.php');

function getUsername(){
    $username = $_SESSION['username'];


    $sql = "SELECT NAME FROM benutzer WHERE BENUTZERNAME LIKE '" . $username . "'";
    $res = mysqli_query($con, $sql);

    echo "<p>" $res "</p>";
}

?>

Answer 1

使用:

$sql = "SELECT NAME FROM benutzer WHERE BENUTZERNAME = '" . $username . "'";

相反:

$sql = "SELECT NAME FROM benutzer WHERE BENUTZERNAME LIKE '" . $username . "'";

如果您想检索确切的用户名。