Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login.php

<p>i'm getting the following error</p><p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login.php</p><p>everything else work fine... except for this !</p><p>Here's my query :</p><pre><br /><code><?php<br /><br />$inputuser = $_POST["user"];<br />$inputpass = $_POST["pass"];<br /><br />$user = "root";<br />$password = "";<br />$database = "share";<br /><br />$connect = mysql_connect("localhost:3306",$user,$password);<br />@mysql_select_db($database) or ("Database not found");<br /><br />$query = "SELECT * FROM 'users' WHERE 'username'= '$inputuser'";<br />$querypass = "SELECT * FROM 'users' WHERE 'password'= '$inputpass'";<br /><br />$result = mysql_query($query); <br />$resultpass = mysql_query($querypass); <br /><br />$row = mysql_fetch_array($result);<br />$rowpass = mysql_fetch_array($resultpass);<br /><br />$serveruser = $row['user'];<br />$serverpass = $row['password'];<br /><br />if ($serveruser && $serverpass) {<br /> if (!$result) {<br /> die ("Invalid Username/Password");<br /><br /> }<br /> header('Location: Fail.php');<br /> mysql_close();<br /><br /><br />if ($inputpass == $serverpass) {<br /><br /> header('Location: Home.php');<br /><br />} else {<br /><br /><br />}<br />}<br /><br />?><br /></code><br /></pre><br /><h2>Click here view more answers <a href="%20http://stackoverflow.com/questions/34525489/warning-mysql-fetch-array-expects-parameter-1-to-be-resource-boolean-given-i">http://ift.tt/1QXmsGN</a></h2>

Nhận xét

Bài đăng phổ biến từ blog này

Align div to bottom of the page in bootstrap

Align elements inside an tag vertically

Javascript is unable to stop page loading