Member Avatar for Niccloud

I am trying to search for something in the database. However, this error keeps popping up. I was wondering if anyone could help me. Thanks

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?
$host = '127.0.0.1';
$database = 'lab11';
$conn = mysql_connect($host);
$select = mysql_select_db($database, $conn);
$user = $_POST['user'];
$pass = $_POST['pass'];
if (! $conn)
die("Couldn't connect to MySQL");
$query = 'SELECT * FROM `security` LIMIT 0 , 30';
$result = mysql_query($query, $conn);
$row = mysql_fetch_assoc($result);
$a = array_search($user, $row);
echo $a;

mysql_close($conn);
echo 'Hi ';
echo $user. '.' ;
echo ' I can see your password.';
echo ' It is ';
echo $pass;
?>
</body>
</html>
  • 2 Contributors
  • 5 Replies
  • 288 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Menster
Member Avatar for Menster

Hi there,
Have you tried running your sql statement straight through your SQL command interface (like phpMyAdmin). If that returns no errors, try adding some error catching as follows and check the results:

$query = 'SELECT * FROM `security` LIMIT 0 , 30';
$result = mysql_query($query, $conn);
if (mysql_numrows($result) > 0)
{
$row = mysql_fetch_assoc($result);
$a = array_search($user, $row);
echo $a;
} else {
echo "No rows returned";
}
Member Avatar for Niccloud

Thanks for the help but the same error appears and the query works in sql. Is there any more actions that you can recommend me to fix this error?

Member Avatar for Menster

Try this, it seems that the $result variable is set to NULL when you try and retrieve rows from it, if you are sure that your sql is correct, are you certain that you are connecting to your database correctly? I notice that you aren't passing a username or password to your mysql_connect() statement. But if that is also fine then try this:

$query = 'SELECT * FROM `security` LIMIT 0 , 30';
$result = mysql_query($query, $conn);
if (mysql_numrows($result) == 0)
{
echo "Result set is EMPTY";
} else if (!$result) {
echo "Result set is NULL";
} else {
echo "Result set is VALID";
$row = mysql_fetch_assoc($result);
$a = array_search($user, $row);
echo $a;
}

Apart from that, I'm pretty much out of ideas, hope this helps

Member Avatar for Niccloud

Thanks for the help!!!
It worked finally. You were a great help

Member Avatar for Menster

Swt, anytime

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.