PHP - I've Got A Problem With Mysql_num_rows()

 MYSQL Client server version 5.0.45




Hi All!

Got a little irritating problem going on when trying to allow a user to log on with their credentials.
I've created the relevant tables, defined connection correctly etc but every time I enter in the correct user account details , it always displays the message I created for when the user account details are wrong.

Here is the code:

<?php

...
...

$find_user_sql = "SELECT `ad_aid`, `ad_aus` FROM `ad_users` WHERE `ad_aus` = '" . $find_user_usr . "' AND `ad_apa` = '" . $find_user_pas . "'";
$find_user_res = mysql_query($find_user_sql);



if(mysql_num_rows($find_user_res) > 1|| mysql_num_rows($find_user_res) < 1){



?>


<div id="loginbox">
<div id="loginbox-logo">&nbsp;</div>
<div id="loginbox-content">
<div id="content-error">

<p>The details you entered were incorrect.</p>

</div>

<form action="login.php" method="post">
<p>Admin Username:<br />
<input type="text" name="ad_user" autocomplete="off" />
</p>
<p>Admin Password:<br />
<input type="password" name="ad_pass" autocomplete="off" />
</p>
<p>
<br />

<input type="submit" name="ad_submit" value="Log me in &raquo;" id="login_button" />

</p>
</form>
</div>
<div id="loginbox-bottom">&nbsp;</div>
</div>





<?php

include_once('includes/footer.php');

$insert_fail_attempt_sql = "INSERT INTO `ad_fail_log` VALUES (NULL, NULL, '" . visitorIP() . "')";
mysql_query($insert_fail_attempt_sql);

}




else{

include_once('includes/header.php');

$find_user = mysql_fetch_assoc($find_user_res);

session_start();

$_SESSION['ad_user'] = $find_user['ad_aus'];
$_SESSION['ad_aid'] = $find_user['ad_aid'];

?>
<meta http-equiv="refresh" content="3;url=../ad/index.php">
<div id="loginbox">
<div id="loginbox-logo">&nbsp;</div>
<div id="loginbox-content">
<p>Logging In...<br /><br /><br /><br />
<center><img src="images/login-loader.gif" /></center>
</p>
</div>
<div id="loginbox-bottom">&nbsp;</div>
</div>

<?php

include_once('includes/footer.php');

}

}

}else{

include_once('includes/header.php');

?>




What the aim of the script is, is to allow users to log in then be taken to a page called index.php . I also have a include php script called check.php (below) which checks users accounts:







<?php

session_start();

if(!empty($_SESSION['adm_user']) && !empty($_SESSION['adm_aid'])){

$check_user_sql = "SELECT `adm_ana`, `adm_per` FROM `pb_admin_users` WHERE `adm_aus` = '" . $_SESSION['adm_user'] . "' AND `adm_aid` = '" . $_SESSION['adm_aid'] . "'";
$check_user_res = mysql_query($check_user_sql);

if(mysql_num_rows($check_user_res) > 1 || mysql_num_rows($check_user_res) < 1)){
   
$check_user = mysql_fetch_assoc($check_user_res);
$_SESSION['adm_name'] = $check_user['adm_ana'];
$_SESSION['adm_perm'] = $check_user['adm_per'];

}else{
   header('Location: https://*website*/' . DIR_ADM . '/login.php');
die($check_user_sql);
}

}else{
header('Location: https://*website*/' . DIR_ADM . '/login.php');
die($check_user_sql);
}

?>




I know it's got something to do with the if(mysql_num_rows($find_user_res) > 1|| mysql_num_rows($find_user_res) < 1){ , but I don't know why its rejecting correct username and password .

I've tried fiddling around with the mysql_num_rows value to 1 or 0 or ==1 etc but it will only do one of the following:

- State that my username and password are incorrect(when they're not)
                                                     OR
- Seem as if it is logging in by displaying "logging in" then for it to only display the login.php page again



I would be very grateful if anyone could give me some pointers!! 

Hi people,
My script is for my game, it is to see whether a player has already started a challenge (it is recorded to a table in my database). If the challenge has already been started, then the button to accept the challenge is disabled. But if the challenge hasn't been accepted yet, then the button is clickable. The problem though is the mysql_num_rows function isn't returning 0 like it should (meaning the challenge has not been started) and instead the button is being disabled.
Code: [Select]
<?php
session_start();
include('functions.php');
connect();
?>
<!DOCTYPE html>
<html>
<head>
<title>University Crusade</title>
<link rel="stylesheet" href="css/style.css" type="text/css" media="screen">
<meta name="viewport" content="width=device-width, minimum-scale=1,maximum-scale=1, user-scalable=no">
</head>
<body>
<?php
if (isset($_SESSION['userid'])) {
include('safe.php');
?>
<ul id="tab-nav">
<li><a href="stats.php" id="tab-character">Character</a></li>
<li><a href="games.php" class="active" id="tab-games">Games</a></li>
<li><a href="account.php" id="tab-account">Account</a></li>
</ul>
<div id="wrapper">
<h2 id="name">Select a Challenge</h2>
<ul id="table-view">
<li>
<fieldset>
<legend>"Easter Egg" Challenge</legend>
<div id="rewards">
<p class="instructions">
Find each of the 4 "Easter Egg" barcodes around
the university campus.
</p>
<p>
Rewards: Every egg is worth
<span class="stat">50</span> XP and
<span class="stat">35</span> gold coins.
</p>
</div>
<form action="games.php" method="POST">
<?php
$check = mysql_query("
SELECT start1 FROM chal1 WHERE userid='".$_SESSION['userid']."'
") or die ("Could not select database from chal1");
if (mysql_num_rows($check)>0) {
echo "
<button class=\"buttons\" type=\"submit\" name=\"start1\" disabled=\"disabled\">
Accept challenge
</button>
";
} else {
echo "
<button class=\"buttons\" type=\"submit\" name=\"start1\">
Accept challenge
</button>
";
}
?>
</form>
</fieldset>
</li>
<li class="even">
<fieldset>
<legend>Increase Strength</legend>
<div id="rewards">
<p class="instructions">
You'll find the barcode in the Sports Centre.
</p>
<p>
Rewards: Every time you visit the Sports Centre
you'll receive <span class="stat">2</span> Str. points.
</p>
</div>
<form action="games.php" method="POST">
<button class="buttons" type="submit" name="start2">
Accept challenge
</button>
</form>
</fieldset>
</li>
<li>
<fieldset>
<legend>Increase Intelligence</legend>
<div id="rewards">
<p class="instructions">
You'll find the barcode in the university Library.
</p>
<p>
Rewards: Every time you visit the Library
you'll receive <span class="stat">2</span> Int. points.
</p>
</div>
<form action="games.php" method="POST">
<button class="buttons" type="submit" name="start2">
Accept challenge
</button>
</form>
</fieldset>
</li>
</ul>
</div>
<div id="footer">
<a class="buttons" href="logout.php">log me out</a>
</div>
<?php
} else {
die ("
<div id=\"wrapper\">
<p>Opps! You don't seem to be logged in...</p>
<a class=\"buttons\" href=\"index.php\">login now</a><br />
<p>Don't have an account? No worries, just <a class=\"buttons\" href=\"register.php\">register for one.</a></p>
</div>
");
}
?>
Anyone know what could be wrong?
Thanks

I am having real problems getting mysql_num_rows function working with PHP 5

This is the split up script:

index.php

<?php
ini_set('display_errors', 1);

require_once 'config.php';

require_once 'func/func.db.php';

$connect = databaseConnect($host, $user, $password, $database);

if($connect == true)
{

//

printf("<table>");

// get it querying results for showing users entries as of now:

$result = query("SELECT * FROM entries");

if($result == true)

{

printf("<table>

<tr>

<td></td>

</tr>\n");

while($row = mysql_fetch_array($result))

{

printf("

<tr>

<td>Result row</td>

</tr>\n");

}

printf("</table>\n\n");

}

// show form for users logged in so they can post entries, ie just one user account for now:

require_once 'auth.php';

}
?>


func/func.db.php
<?php
function databaseConnect($host, $user, $password, $database)
{

$connect = mysql_connect($host, $user, $password);

if($connect)

{

$select_db = mysql_select_db($database, $connect);

if($select_db)

{

return true;

} else {

return false;

}

} else {

return false;

}
}

function query($sql)
{

$sql = stripslashes($sql);

$query = mysql_real_escape_string($sql);

$result = mysql_query($query);

if($result){

return $result;

}
}

Then the auth.php, looks like:
<?php
if(isset($_POST))
{

$message = 'Only registered users can post';

if(array_key_exists('submit',$_POST))

{

if($_POST['username'] != '' && $_POST['password'] != '')

{

$username = $_POST['username'];

$password = sha1($_POST['password']);

// try to log user in:

$result = query("SELECT * FROM users WHERE username = '$username' AND '$password'");

echo mysql_num_rows($result);

} else {

$message = 'You did not enter all required fields, please retry';

}

}

} else {

$message = 'Only registered users can post';

}
?>

<p><?=$message;?></p>
<table>
<form id="login" name="login" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<tr>

<td><label for="username">User: </label></td>

<td><input type="text" id="username" name="username" value="" /></td>

</tr>

<tr>

<td><label for="password">Password: </label></td>

<td><input type="password" id="password" name="password" value="" /></td>

</tr>

<tr>

<td><input type="submit" id="submit" name="submit" value="Login" /></td>

</tr>
</form>
<table>

You dont need to know whats in config.php since thats just full of my database connection variables, like the hostname, user, password and database, but its saying mysql_num_rows is an invalid function, since maybe its because its lost connection to the database, but how would I get around this?

I thought about maybe making it connect to the database again, but is there any point in doing this?

This is the actual error I get:
Quote

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/jeremysmith.me.uk/html/blog-dev/auth.php on line 17


Any help is much appreciated,
Jez.

I have a mysql database table that lists baseball and softball umpires for the season.  The table has columns for: date, sport, umpire1, umpire2, umpire3, umpire 4, umpire5, visitor team, and home team.

I'm trying to write a bit of code that will tell me how many times I have schedule (manually) an umpire to see a particular school. 

Here's what I've come up with.

Code: [Select]
<?php
require_once "/config.php";
$dbc = mysql_pconnect($host, $username, $password);  
mysql_select_db($db,$dbc);   

$start_date = '2011-04-01';
$end_date = '2011-06-01';

$umpires = Array('umpire 1 name', 'umpire 1 name', 'umpire 2 name', 'umpire 3 name', 'umpire 4 name', 'umpire 5 name', 'umpire 6 name');

$schools = Array('Bagley', 'Bemidji', 'Blackduck', 'Fosston', 'International Falls', 'Kelliher', 'Laporte', 'Lake of the Woods', 'Remer', 'Walker');   
?>

<?php 
foreach($umpires as $umps) {    //selects the first umpire in the array
        echo "<table width='20%' border ='1'>";
            echo "<tr><td>$umps</td><td>Baseball</td><td>Softball</td></tr>";

foreach($schools as $town)  {    //selects the first town in the array

$sql_baseball = "SELECT * FROM $table WHERE (ump1 = $umps OR ump2 = $umps OR ump3 = $umps OR ump4 = $umps OR ump5 = $umps) AND (visitor = $town OR home = $town) AND sport = 'Baseball' AND date >= $start_date AND DATE <= $end_date";           
$result_baseball = mysql_query($sql_baseball);
$count_baseball=mysql_num_rows($result_baseball);

$sql_softball = "SELECT * FROM $table WHERE (ump1 = $umps OR ump2 = $umps OR ump3 = $umps OR ump4 = $umps OR ump5 = $umps) AND (visitor = $town OR home = $town) AND sport = 'Softball' AND date >= $start_date AND DATE <= $end_date";           
$result_softball = mysql_query($sql_softball);
$count_softball=mysql_num_rows($result_softball);

echo "<td>$town</td><td>$count_baseball</td><td>$count_softball</td></tr>";
} //loops the towns
echo "</table>";
}   //ends each umpire
?>


As you can see, I've put all the umpire names in an array...and each school in a separate array.

The html tables are being displayed (with the correct names and schools listed...but I'm getting this error:

Quote

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /by_school.php on line 33

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /by_school.php on line 37



Line 33 is this - - - $count_baseball=mysql_num_rows($result_baseball);
Line 37 is this - - - $count_softball=mysql_num_rows($result_softball);

I'm guessing that the problem is that I have multiple selects (one for each town) while using the same variable names for each select...but I can't figure out how to concacate the variable names properly...or even if that's the problem.

Any ideas?

Thanks!

Hi

I am trying to create a login script using the code below

Code: [Select]
<?php
session_start();
include_once('includes/connect.php');
$user=$_POST['username'];
$password=$_POST['password'];
//check if username and password exists
$checkuser=mysql_query("SELECT * from `tbl_users` where username = '$user' and password=md5('$password')");
if(mysql_num_rows($checkuser) > 0) //login name was found
//if they do return to home page with relevant include
{
  $user_row = mysql_fetch_array($checkuser);
  $_SESSION['auth']="yes";                    
     $_SESSION['logname'] = $user_row['forename']; 
  $_SESSION['usertype'] = $user_row['usertype'];
  header("Location: index.php");
      exit;
  }
//if not display login form with message that says logon details are incorrects
else
{
echo('Do something else');
}
?>

However I get a message saying that mysql_num_rows is not a valid resource.

Any ideas where I am going wrong?