Not loading results non-object

Asked May 19 '16 at 19:29

Active May 19 '16 at 19:29

Viewed 15 times

I am trying to get the results of a MySQL table with the column name 'teachername' what's happening is, when I search the the name I am getting a error which states I am trying to get the property of a non-object.

Here is the code..

if (isset($_GET['teacher'])) {

 $teachername = $_GET['teacher'];

 $sql = "SELECT * FROM assignmenthandout WHERE teachername = $teachername";

  $result = $conn->query($sql);

  if ($result->num_rows > 0) {
    while($row = mysqli_fetch_array ($result)) {
      echo $row["assignmentname"]."<br />";
    }
  } else {
    echo "There are no assignments due";
  }

The line the error is reffering to is

if ($result->num_rows > 0) {

Thank you!

asked May 19 '16 at 19:29

miotk

I sincerely doubt that the teacher's name is an integer. Then again, some treat us as numbers *huh?* ;-) – Funk Forty Niner May 19 '16 at 19:30
I think you might want to take a look at Prepared statements `SELECT * FROM assignmenthandout WHERE teachername = $teachername` screams SQL injection to me. http://bobby-tables.com – Maantje May 19 '16 at 19:31
enclose $teachername in single quotes like this '$teachername' – MoniXx May 19 '16 at 19:35
@Maantje by prepared statements, what do you mean? – miotk May 19 '16 at 20:03
@MoniXx Thank you, that fixed it! – miotk May 19 '16 at 20:03
@miotk Here is a post about it http://php.net/manual/en/pdo.prepared-statements.php. – Maantje May 19 '16 at 20:06
@miotk by prepared he means this http://php.net/manual/en/mysqli.quickstart.prepared-statements.php – MoniXx May 19 '16 at 20:06
@Maantje haha beat me to it. – MoniXx May 19 '16 at 20:06
@Maantje can that be done with a SELECT? the same, other than using the select? – miotk May 19 '16 at 20:07

Not loading results non-object

0 Answers0