How can the PHP code be modified to correctly display the bank names instead of showing "Resource id #5"?

The issue is caused by attempting to directly output the result of a MySQL query, which returns a resource identifier instead of the actual data. To correctly display the bank names, we need to fetch the data from the query result and then loop through the rows to display each bank name. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

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

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

// Query to fetch bank names
$sql = "SELECT bank_name FROM banks";
$result = $conn->query($sql);

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

// Close connection
$conn->close();

Keywords

mysqli_fetch_assoc mysqli_query database connection PHP bank names

Related Questions