DaniWeb Forum Index > Web Development > PHP

retrieving data from MySQL

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 22

Reputation: eparse is an unknown quantity at this point

Solved Threads: 0

eparse

Offline

Newbie Poster

retrieving data from MySQL

Mar 17th, 2008

hi for all the expert here, i am now facing a minor problem on retrieving data here. MySQL do contain all the variables defined with data inside it. However, i juz need to know how to loop through the array to get all the data in a row?
Below is the php code i used:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
//session_start();
$query = "SELECT * FROM user"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
if($_POST['name'] == $row['username'])
{
	echo "Thanks for logging in.";
	header("http://www.google.com");
}
else
{
	echo "Sorry, your username and password does not match.";
	//header("http://www.yahoo.com");
}
$_SESSION['name']=$_POST['name'];
$_SESSION['password']=$_POST['password'];
$_SESSION['status']=$_POST['status'];
?>
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
//session_start();
$query = "SELECT * FROM user"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
if($_POST['name'] == $row['username'])
{
	echo "Thanks for logging in.";
	header("http://www.google.com");
}
else
{
	echo "Sorry, your username and password does not match.";
	//header("http://www.yahoo.com");
}
$_SESSION['name']=$_POST['name'];
$_SESSION['password']=$_POST['password'];
$_SESSION['status']=$_POST['status'];
?>

especially at the function, i dunnoe why i can see the Thanks for login even no username entered. Can anyone help? By the way, php redirect cannot use more than once? Thanks for help....

Last edited by eparse; Mar 17th, 2008 at 9:23 am.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: retrieving data from MySQL

Mar 17th, 2008

Instead of $row = mysql_fetch_array($result) use, while($row = mysql_fetch_array($result)) { AND

•

echo "Thanks for logging in.";
header("http://www.google.com");

will give you an error because you can't output anything before header function. Either echo a message or redirect the user.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Mar 2008

Posts: 22

Reputation: eparse is an unknown quantity at this point

Solved Threads: 0

eparse

Offline

Newbie Poster

Re: retrieving data from MySQL

Mar 17th, 2008

thanks for the solution, however i still facing the problem using while loop...
it keeps showing this on the page:
Sorry! Wrong name!!Sorry! Wrong name!!Sorry! Wrong name!!
when i use while loop..
below is the modified code:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
$query = "SELECT * FROM user"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if ($_POST['name']==$row['username'] && $_POST['password']==$row['password'])
	{
	echo "Login successfully!!!";
}
else
{
	echo "Sorry! Wrong name!!";
}
}
$name=$_POST['name'];
$password=$_POST['password'];
$status=$_POST['status'];
?>
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
$query = "SELECT * FROM user"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if ($_POST['name']==$row['username'] && $_POST['password']==$row['password'])
	{
	echo "Login successfully!!!";
}
else
{
	echo "Sorry! Wrong name!!";
}
}
$name=$_POST['name'];
$password=$_POST['password'];
$status=$_POST['status'];
?>

and it only manage to get the 1st row of the data...any silly mistakes i'd done?

Last edited by eparse; Mar 17th, 2008 at 11:20 am.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: retrieving data from MySQL

Mar 17th, 2008

When the user types username and password, why not check if that exists in the table, rather than get all records and then check ?

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$name=$_POST['username'];
$password=$_POST['password'];
Ie., $query = "select * from user where username='$name' and password='$password'";
$name=$_POST['username'];
$password=$_POST['password'];
Ie., $query = "select * from user where username='$name' and password='$password'";

Then check if this returns more than 1 row. If it does, then the username and password is valid. Else, invalid username and pass.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Mar 2008

Posts: 22

Reputation: eparse is an unknown quantity at this point

Solved Threads: 0

eparse

Offline

Newbie Poster

Re: retrieving data from MySQL

Mar 17th, 2008

well, using simple script, i can get all the data within the table, the table now consists of 3 rows of data, but i dunnoe why there exist three times of echo ...and the variable do contain data input by the user...

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: retrieving data from MySQL

Mar 17th, 2008

It displays thrice because its looping three times. You can do it this way.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
$name=$_POST['name'];
$password=$_POST['password'];
$query = "SELECT * FROM user where username='$name' && password='$password'"; 
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result) > 0){
	echo "Success!";
}
else
{
	echo "Sorry! Wrong name!!";
}
?>
<?php
mysql_connect("localhost", "root", "1234") or die(mysql_error());
mysql_select_db("userlist") or die(mysql_error());
$name=$_POST['name'];
$password=$_POST['password'];
$query = "SELECT * FROM user where username='$name' && password='$password'"; 
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result) > 0){
	echo "Success!";
}
else
{
	echo "Sorry! Wrong name!!";
}
?>

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Mar 2008

Posts: 22

Reputation: eparse is an unknown quantity at this point

Solved Threads: 0

eparse

Offline

Newbie Poster

Re: retrieving data from MySQL

Mar 17th, 2008

thanks man....it solved...
reputation given...

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: retrieving data from MySQL

Mar 17th, 2008

cool !

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Mar 2008

Posts: 22

Reputation: eparse is an unknown quantity at this point

Solved Threads: 0

eparse

Offline

Newbie Poster

Re: retrieving data from MySQL

Mar 17th, 2008

by the way...got any php script tht can redirect the viewer after display a message like:

Thank You....You'd logged in sucessfully...

After 5 seconds redirect the page..possible?