Plz help.

bradmasterx

Can any one help i get the error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

<?php
			  $do=$_REQUEST['do'];
			  $user=$_REQUEST['user'];
			  $pass=$_REQUEST['pass'];
			  if($do == "login"){
			  $sql="SELECT * FROM `users` WHERE user=`$user` AND pass=`$pass`";
			  $querysql = mysqli_query($cxn, $sql);

		  $num = mysqli_num_rows($querysql);
		  if($num > 0){
		  $row = mysqli_fetch_assoc($mysqlisql);
		  ?>
		  <table width="200" border="1">
            <tr>
              <td width="71">Username:</td>
              <td width="113"><?php echo $row['user']; ?></td>
            </tr>
            <tr>
              <td>Password: (MD5)</td><?php $rowpass = md5($row['pass']); ?>
              <td><?php echo $rowpass; ?></td>
            </tr>
            <tr>
              <td>Nickname:</td>
              <td><?php echo $row['nickname']; ?></td>
            </tr>
          </table><br />
		   <p><a href="/admin/">Admin Area.</a></p>
		     <?php
		  }
		  else
		  {
		  echo "Invalid Login Details<br>";
		  include 'loginform.html';
		  }
		  }else{
		  include 'loginform.html';
		  }
		  ?>

Plz i need this sorting.

YAOMK

Your query is returning an error and therefore passing FALSE to mysqli_num_rows. If you are performing previous queries using mysqli_query() remember to free the result before proceeding with further queries or this will cause the error. Also make sure to check your db connection link represented by $cxn. Additionally I don't think you need back ticks around your php variables in the sql query string, instead use quotation marks.

bradmasterx

Same Problem, Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

<?php
include "config/settings.php";
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?php echo $title; ?></title>
<meta name="keywords" content="Oplo, Managing, Business, User, Managment" />
<meta name="description" content="Oplo a user managing freeqare program" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<script language="javascript">
function odlca(doa){
if(doa == "download"){
alert("Download link is avalible");
}
if(doa == "link"){
alert("Download Links are unavalible.");
}
}
</script>
</head>
<body>
<!-- start header -->
<div id="header">
	<div id="logo">
		<h1><a href="#"><?php echo $header; ?></a></h1>
		<p>&nbsp;</p>
	</div>
	<?php require_once("menu.html"); ?>

<!-- start content -->
<div id="content">
  <div class="post">
	  <h1 class="title"><a href="#">login</a></h1>
	  <p class="byline">&nbsp;</p>
		<div class="entry">
		  <p><?php
		  $close = mysqli_close($cxn);
		  $cxna = mysqli_connect("localhost", "root", "", "oplo") or die ("Sorry Invalid Login");
		  $do=$_REQUEST["do"];
		  $user=$_REQUEST["user"];
		  $pass=$_REQUEST["pass"];
		  if($do == "login"){
		  $sql="SELECT * FROM `users` WHERE user=`$user` AND pass=`$pass`";
		  $querysql = mysqli_query($cxna, $sql);

		  $num = mysqli_num_rows($querysql);
		  if($num > 0){
		  $row = mysqli_fetch_assoc($mysqlisql);
		  ?>
		  <table width="200" border="1">
            <tr>
              <td width="71">Username:</td>
              <td width="113"><?php echo $row["user"]; ?></td>
            </tr>
            <tr>
              <td>Password: (MD5)</td><?php $rowpass = md5($row["pass"]); ?>
              <td><?php echo $rowpass; ?></td>
            </tr>
            <tr>
              <td>Nicknme:</td>
              <td><?php echo $row["nickname"]; ?></td>
            </tr>
          </table><br /><?php $closea = mysqli_close($cxna); ?>
		   <p><a href="iframe.php?go=http://admin.%domain%">Admin Area.</a></p>
		     <?php
		  }
		  else
		  {
		  echo "Invalid Login Details<br>";
		  include "loginform.html";
		  }
		  }else{
		  include "loginform.html";
		  }
		  ?>

	      </p>
	      <p align="center">&nbsp;  </p>
		</div>
  </div>
  <div class="post">
    <div align="center"></div>
  </div>
</div>
<!-- end content -->
<?php require_once("footer.html"); ?>

</body>
</html>

Please Help PLZ

future448

You still have the backticks on your query

$sql="SELECT * FROM `users` WHERE user=`$user` AND pass=`$pass`";

Should be:

$sql="SELECT * FROM `users` WHERE user='$user' AND pass='$pass'";

YAOMK

Right...
backticks are used to avoid conflicts, between the naming of columns and mysql reserved/key words, it is a better practice to use a naming convention for your columns that avoids reserved mysql words.