SQL to HTML Table, new

Question

I can't figure out why my code isn't working? When i run it the page is blank!

This is a Harry Potter Database. I am trying to put the data within my SQL Database in a HTML Table. Sounds easy but I can't figure out why my code is not working!

<!DOCTYPE html>
<html>
<head>
    <title> Harry Potter Database </table>
</head>
<body>
<table>
    <tr>
        <th> ID </th>
        <th> Name </th>
        <th> Age </th>
        <th> Website </th>
    </tr>
<?php
ini_set('display_errors', 1); 
ini_set('display_startup_errors', 1); error_reporting(E_ALL); 
$conn = mysqli_connect("localhost", "root", "", "survey");
$sql = "SELECT * FROM result";
$res = $conn->query($sql);

if($res->num_rows > 0)
{
    while($row = $res->fetch_assoc())
    {
        echo "<tr>
        <td>". $row["ID"] . "</td>
        <td>". $row["Name"] . "</td>
        <td>". $row["Age"] . "</td>
        <td>". $row["Website"] . "</td>
        </tr>";
    }
}
else{
    echo "No RESULTS";
}
$conn->close();

?>
</table>
</body>
</html>

result is the name data within my database called survey

Undefined array key "ID" in C:\xampp\htdocs\ws5\sqlquery.php on line 26

This is the error in the source

Structure of Table

ID	WEBSITE	AGE	WEBSITE

What database engine are you using (e.g. MySQL, PostgreSQL)? — Moshe Katz
– Moshe Katz, Commented Mar 14, 2022 at 23:24

Moshe Katz · Accepted Answer · 2022-03-14 23:29:07Z

1

On Windows (where it looks like you are), MySQL stores all table and column names in lowercase by default (see the docs for "Identifier Case Sensitivity" and lower_case_table_names).

That means that instead of "ID", you should be using "id", instead of "Name" it should be "name", etc.

answered Mar 14, 2022 at 23:29

Moshe Katz

16.5k7 gold badges71 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Carlo M Over a year ago

Ok, I now have no errors in the source code. But when I run the host page I have no table whatsover?

Carlo M Over a year ago

I also made a mistake with the heading! Such a noob mistake. I put table instead of title :(

Collectives™ on Stack Overflow

SQL to HTML Table, new

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related