Shinerse 0 Posted March 31, 2013 *Olá pessoal , é assim eu quando tento fazer Login no meu WebSite aparece este erro : Warning : mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\teste2\inc\loginbar.inc.phpon line 13 Alguém sabe o que se passa? Ou então como se arranja isso? Agradecia muito. Share this post Link to post Share on other sites
0 Nestle 382 Posted March 31, 2013 Mete ai o código todo da página... Share this post Link to post Share on other sites
0 Shinerse 0 Posted March 31, 2013 <?PHP if(isset($_POST['submit']) && ($_POST['submit']=="Anmelden" || $_POST['submit']=="Anmelden")) { if(!empty($_POST['userid']) && !empty($_POST['userpass']) && checkAnum($_POST['userid']) && checkAnum($_POST['userpass'])) { $sqlCmd = "SELECT id,login,coins,web_admin,email FROM account.account WHERE login LIKE '".mysql_real_escape_string($_POST['userid'])."' AND password=PASSWORD('".mysql_real_escape_string($_POST['userpass'])."') LIMIT 1"; $sqlQry = mysql_query($sqlCmd,$sqlServ); if(mysql_num_rows($sqlQry)>0) { $getAdmin = mysql_fetch_object($sqlQry); $_SESSION['user_id'] = $getAdmin->id; $_SESSION['user_name'] = $getAdmin->login; $_SESSION['user_admin'] = $getAdmin->web_admin; $_SESSION['user_coins'] = $getAdmin->coins; $_SESSION['user_email'] = $getAdmin->email; $updateIP = mysql_query("UPDATE account.account SET web_ip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' WHERE id='".mysql_real_escape_string($getAdmin->id)."'",$sqlServ); } } } if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) { echo'<ul style="width:80%;" class="menue">'; echo $_SESSION['user_coins']; echo ' Coins'; echo'<li><a href="index.php?s=vote">Vote 4 Coins</a></li>'; echo'<li><a href="index.php?s=itemshop">Itemshop</a></li>'; echo'<li><a href="index.php?s=spenden">Spenden</a></li>'; echo'<li><a href="index.php?s=charaktere">Charaktere</a></li>'; echo'<li><a href="index.php?s=passwort">Passwort ändern</a></li>'; echo'<li><a href="index.php?s=logout">Ausloggen</a></li>'; echo'</ul><br>'; ?> <?PHP } else { ?><form action="index.php?s=login" method="POST"> <table> <tr> <td class="tdunkel"><input type="text" class="bar" name="userid" maxlength="16" size="20"/></td> </tr> <tr> <td class="thell"><input type="password" class="bar" name="userpass" maxlength="16" size="20"/></td> </tr> <tr> <td class="topLine" style="text-align:center;" colspan="2"><input type="submit" class="btn" name="submit" value="Anmelden"/></td> </tr> </table></form> <?PHP }?> Share this post Link to post Share on other sites
0 Thavo 36 Posted April 1, 2013 ": mysql_num_rows() expects parameter 1 to be resource, boolean given in"Este erro geralmente acontece quando estas a fazer um consulta a base de dados, e não retorna qualquer valor.Verifica se a tua consulta esta a ser efetuada devidamente.Qualquer duvida apita. Share this post Link to post Share on other sites
*Olá pessoal , é assim eu quando tento fazer Login no meu WebSite aparece este erro :
Agradecia muito.
Share this post
Link to post
Share on other sites