php error on my error_log while posting

Question

this is my php codes getting Post Successfully response when true but when it failed for some reason. i got this error.

mysqli_error() expects parameter 1 to be mysqli, null given

$result = mysqli_query($connection, $query) ;
    if($result){$response["msg"] = "Post Successfully";
echo json_encode($response);} else {$response["msg"] = "failed ".mysqli_error($con);
echo json_encode($response);
    }
    mysqli_close($connection);
}

`mysqli_error($con)` should be `mysqli_error($connection)` – devpro Oct 13 '16 at 07:30 — devpro, Oct 13 '16 at 07:30

score 1 · Answer 1 · answered Oct 13 '16 at 07:31

1

$con is null

mysqli_error($con); should be mysqli_error($connection); as you have declared connection as $connection.

answered Oct 13 '16 at 07:31

Danyal Sandeelo

12,196
10
47
78

score 1 · Answer 2 · answered Oct 13 '16 at 07:32

1

According to this line:

mysqli_query($connection, $query)

You are using variable $connection for link identifier, and in mysqli_error($con) you are using $con variable which is undefined or NULL, this should be:

mysqli_error($connection)

answered Oct 13 '16 at 07:32

devpro

16,184
3
27
38

php error on my error_log while posting

2 Answers2