I am trying to run following command But I end up with an error

Question

I am trying to run following code :

$con=mysqli_connect("localhost","root");

mysqli_select_db($con,"hellotune");

$sql="select email,password from register where email='".$email."' and password='".$password."'";

$result=mysqli_query($con,$sql);

$record=mysqli_num_rows($result);

But following error is occured:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\wamp64\www\HelloTune\login.php on line 38

Can anyone please tell me what is wrong in this code.

Thanking You.

Answer 1

Hello Nishant,

You are getting this error because your query failed. 

So,you can use mysqli_error and echo your query to see the problem. Everywhere that you have

$query = mysqli_query($db_conx, $sql);

You should add:

$query = mysqli_query($db_conx, $sql) or trigger_error("Query Failed! SQL: $sql - Error: ".mysqli_error(db_conx), E_USER_ERROR);

You should consider switching to the OOP mysqli between, then you don't have to use the connection variable every time and if you can't resolve error then send me your file.php

Hope this works!!

Thank You!!