[Resolved] PHP - MySQL problems

[maximum-php]

Hi,

I'm new to PHP & MySQL, and to these boards. I would appreciate any help that any of you can give.

I have a database / table created in MySQL. The table consists of 4 items. 2 usernames & two passwords.

I want to be able to use POST data submitted from a form to open up and check the POST data username & password with the items in the MySQL database. It works just fine for the first usrename & password in the MySQL database but not the other. Here is the following PHP code to try and accomplish this. What am I doing wrong??

<?php
session_start();
session_register("user");
session_register("auth");
$post = $_POST;

$mysqlconnect = mysql_connect("127.0.0.1", "root", "xxxxx");
mysql_select_db("usrpsw");
$query = "SELECT * FROM access";
$result = mysql_query($query);

$info = mysql_fetch_array($result, MYSQL_NUM);
mysql_close($mysqlconnect);
foreach ($info as $key => $value) {
if($value == $post['usr'] AND $info[$key+1] == md5($post['psw'])) {
$SESSION['user'] = $post['usr'];
$SESSION['auth'] = 'y';
}
}
if ($_SESSION['auth'] == 'y') Header ("Location: http://www.xxxxx.com/frame.php");
//else Header ("Location: http://www.xxxx.com/invalid.php");
?>

The above posted code works to pull just the first username / password from the list and redirect appropriatly but it doesnt look like $info pulls more than just the first two elements. Why does it not pull the entire database?

Thx for any help,

[TheDefender]

Because you told it to only pull the last row of data in the result set with this line:

$info = mysql_fetch_array($result, MYSQL_NUM);

This only pulls one row of data. If you want all of the results, then you'd have to put it into a while loop:

while($info = mysql_fetch_array($result, MYSQL_NUM)){
  // do something for each row of data when you are in the while loop.
} 

I personally recommend you use the POSTED data in your query, so you only get one result:

$sql = "SELECT * FROM access WHERE username = '".$_POST['username']."'";

You'd need to add some validation to make sure it exists, and whatnot, but that way, you can do things the same way you are trying to do now, and then pull that one row that you really need.

[maximum-php]

Thx TheDefender, your suggestion worked great,, appreciate the fast reply and the help.

[TheDefender]

YW. Be sure to mark the thread resolved using the M"Mark Thread Resolved" link at the bottom, and have a nice day.🙂

P.S. Welcome to our community!