Trying to get property of non-object while using num_rows

Question

I have the code that has been giving me the following error.

Trying to get property of non-object in G:\xampp\htdocs\abc\admin\delete.php on line 68

Here's the code,

<?php
    if(isset($_POST["submit"])) {
    include '../includes/db.php';

    $sql = "DELETE FROM admin WHERE aid= '".$_POST['aid']. "'";

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

    if ($count > 0) {
        echo "success";
    } else {
        echo "fail";
    }

    $conn->close();
    }
?>

db.php has the code that connects to the database.

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fgfg";

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

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

?>

It executes the query but the error message is displayed.

What is causing it?

Specifically: http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php/12769983#12769983 — deceze, Mar 30 '16 at 08:29

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

What you delete what you need to return is affected_rows. On Delete query it gives affected rows not num rows.

Use $conn->affected_rows instead of $result->num_rows

Please refer Affected_rows.

Edit: You need to pass connection string not result.

edited Jun 20 '20 at 09:12

Community

1
1

answered Mar 30 '16 at 08:27

Apb

979
1
8
25

Using `$result->affected_rows` gives the same error. – innowqhy Mar 30 '16 at 08:30
Is row deleted from table? Have you checked it? – Apb Mar 30 '16 at 08:30
Yes the row is deleted. – innowqhy Mar 30 '16 at 08:32
@innowqhy: post your database connection code – Apb Mar 30 '16 at 08:39
updated my post with db.php code. – innowqhy Mar 30 '16 at 08:43
I updated my answer. Please check – Apb Mar 30 '16 at 08:45
_You need to pass connection string not result_ I'm sorry I don't get it. – innowqhy Mar 30 '16 at 08:51
Instead of `$result->affected_rows` you need to use `$conn->affected_rows`. I updated it in answer – Apb Mar 30 '16 at 08:52

Trying to get property of non-object while using num_rows

1 Answers1