0

As a newbie in PHP, I tried to make my own site and faced 2 errors, here's the code:

<?php
$servername = "localhost";
$username = "user";
$password = "pass";
$dbname = "db name";

$conn = new mysqli($servername, $username, $password, $dbname);
$num = $_GET['id'];
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT date, point, reason, teacher, giver FROM penalty WHERE studentid=$num";
$result = $conn->query($sql);

if ($result->num_rows > 0) 
{   
    echo "<table>";
    echo "<tr>";
    echo "<td>date</td>";
    echo "<td>score</td>";
    echo "<td>reason</td>";
    echo "<td>giver</td>";
    echo "<td>teacher</td>";
    echo "</tr>";
    while($row = $result->fetch_assoc()) 
    {
        echo "<tr>";
        echo "<td>".$row["dated"]."</td>";
        echo "<td>".$row["point"]."</td>";
        echo "<td>".$row["reason"]."</td>";
        echo "<td>".$row["giver"]."</td>";
        echo "<td>".$row["teacher"]."</td>";
        echo "</tr>";
    }
    echo "</table>";
}

else if ($result->num_rows = 0)
{
    echo "0!";
}

else 
{
    echo "empty";
}

$conn->close();
?>

and the results:

Notice: Trying to get property of non-object in view.php on line 16 Warning: Creating default object from empty value in view.php on line 39 empty

What can be the problem to cause this error, and how should I fix it?

Thanks in advance

sewerx
  • 29
  • 2
  • `date` is a reserved keyword in mysql so you can't use it as a column name; change it to something else like `dateCreated` then it should work; – itzmukeshy7 Mar 23 '16 at 08:31
  • or put `` around each column name to show its a column – Matt Mar 23 '16 at 08:36

0 Answers0