php - mysqli_num_rows() - Is not working -

php - mysqli_num_rows() - Is not working -

i have form takes users email , password & have script creates json object , sends object encapsulates password , email server using ajax:

$(document).ready(function(){ var email, password; $('#submit').click(function(e){ e.preventdefault(); email = $('#email').val(); password = $('#password').val(); $memberdata = { 'email' : email, 'password':password }; $memberdata = json.stringify($memberdata); login(); }); function login() { $.ajax({ url: 'scripts/processlogin.php', data: 'json='+ $memberdata, success: function(result){ var r = json.parse(result); alert(r.result); } }); } }); in processlogin.php have: include 'dbconnect.php'; $jsons = filter_input(input_get, 'json'); //get object sent file $memberdata = json_decode(stripslashes($jsons)); //convert json object string $email = mysql_real_escape_string($memberdata->email); $password = mysql_real_escape_string($memberdata->password); $query = mysql_query("select * `members` `email` = '$email' , `password` = '$password'"); $rows = mysql_num_rows($query); if($rows > 0){ $_session['email'] = $email; $result = "successfully logged in"; } else { $result = "invalid login credentials"; } $result = array("result"=>$result); echo json_encode($result);

here dbconnect.php:

<?php $dblocation = "localhost"; $dbname="database"; $dbusername="root"; $dbpassword = "root"; $connect = mysqli_connect($dblocation,$dbusername,$dbpassword,$dbname) or die("cannot connect"); mysqli_select_db($connect,$dbname) or die("cannot select db"); if (mysqli_connect_errno()) { echo "failed connect mysql: " . mysqli_connect_error(); } ?>

when run not alert @ all. tried debugging adding line line in proccesslogin.php (noob way) , assigned normal string $result(testing sake) , alert until added : $rows = mysql_num_rows($query), tried using mysqli_num_rows() did not work. know in dbconnect utilize mysqli, if utilize query not work , not work if utilize mysqli_real_escape_string() help appreciated. give thanks in advance.

i dont sure understand problem give shot.

replace this:

$connect = mysqli_connect($dblocation,$dbusername,$dbpassword,$dbname);

with this:

$connect = new mysqli($dblocation,$dbusername,$dbpassword,$dbname);

and this:

$query = mysql_query("select * `members` `email` = '$email' , `password` = '$password'"); $rows = mysql_num_rows($query);

with this:

$query = $connect->query("select * `members` `email` = '$email' , `password` = '$password'"); $rows = $query->num_rows;

php sql ajax json