php - mysqli_num_rows() boolean error -

-

while running code, shows error mysqli_num_rows() expects parameter 1 mysqli_result, boolean

please me find solution:

if(!empty($email_id) && !empty($password)){      $query="select 'email_id' 'user_details' 'email_id'='$email_id' ,    'password'= '$password'";     $con=mysqli_connect("localhost", "root", "","idukki");     $query_run = mysqli_query($con,$query);     $query_num_rows = mysqli_num_rows($query_run);      if($query_num_rows == 0)     {         echo'invalid email , password combination';     }     else if($query_num_rows == 1)     {         $user_id = mysqli_result($query_run,0,'email_id');     }  }

when type of error regarding mysql first thing should print out sql , test in phpmyadmin, if passes in phpmyadmin have error in script, if not bad sql


Comments

Post a Comment

Popular posts from this blog

My HTML document is not linking to my CSS stylesheet properly -

-
i have been copy , pasting html , css tutorials try make work, right have; page (html) <!doctype html> <html> <head> <meta charset="utf-8"> <title>title of document</title> <link rel="stylesheet" type="text/css" href="style/style.css" /> </head> <body> <h1>1this site</h1> <p>welcome site</p> </body> </html> style.css body {background-image:url(“background.png”);} h1 {font-family:arial, sans-serif;} the when load html in safari still unformatted. thanks in advance! check see if setting paths right if still have problem try use fill path : <link rel="stylesheet" type="text/css" href="http://127.0.0.1/test/style/style.css" />
Read more

php array slice every 2th rule -

-
i have array on php outputs in txt file: printing grid -- 1 values -- undef = -9.99e+08 20.2 \nprinting grid -- 1 values -- undef = -9.99e+08 102.0 \nprinting grid -- 1 values -- undef = -9.99e+08 55.1 \nprinting grid -- 1 values -- undef = -9.99e+08 -18.3 \n what point, need nummeric values @ beginning of each rule. 20.2, 102.0, 55.1, -18,3 etc... example, there can more or less in txt file. now do? have tested array slice function can't exclude rule: printing grid -- 1 values -- undef = -9.99e+08 this array slice code... $arraygood = array_slice($arraybad, 1, 4); and foreach loop create text file: $file = fopen("array.txt","w"); foreach ($arraygood $meting => $waarde) { echo fwrite($file,$waarde . '\n'); } fclose($file); thanks! as posted in comments, understanding have array of strings similar following: $lines = array( "printing grid -- 1 values -- undef = -9.99e+08", "20.2 \nprinting grid --...
Read more

node.js - Sending sockets to client side, Error: Converting circular structure to JSON -

-
i'm working in node js , i'm trying send array, clients, server every client normal emit, keeps giving me error: data = json.stringify(ev); typeerror: converting circular structure json shortly, do. var clients = new array(); io.sockets.on('connection', function(socket) { clients.push(socket); socket.on('loginuser', function(data){ io.sockets.emit("getusers", clients); }); i've seen couple of other people having problem, answers didn't work out me. looking @ bigger problem, can't send array of sockets client side. sockets objects make sense in current context/process. if want control sockets client side, instead add sort of rpc functionality.
Read more