What potential issue is the user facing with the code when trying to output names from a database?

The potential issue the user is facing is that the code may not be properly connecting to the database or querying the data correctly. To solve this issue, the user should ensure that the database connection is established before querying for names, and that the query is executed successfully to retrieve the desired data. 

<?php
// Establish database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query database for names
$sql = "SELECT name FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

SQL injection database connection mysqli_fetch_assoc error handling PHP syntax

Related Questions