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
Đăng nhận xét