Simple login code.

Rilto

Hi there, ive been programming for a while and getting my bearings now on php. Im writing a login bit of code and want to know how to approach it.

I have a databse with a list of Users. The user enters their Username, pass. This is checked through mysql as

$query = "SELECT Username, Password FROM User WHERE Username='$Username' AND Password='$Password'";

In jsp you can simply run the query if it fails, tehre is no match, if it passes then proceed.

I havent been able to do this so far in PHP. What is the easiest wy of doing it? If some one could explain if this is a right or wrong notion.

And my next quesion is how do i pull out a field from the returned resultset. Ill have say Username and password being fed back as a result set. How do i extract them? i tried

$Username = mysql_result($result, 0, "Username");

Thank you 🙂

TheDefender

For the latter question, look in the manual at the [man]mysql_query[/man] and [man]mysql_fetch_array[/man] functions.

For the first, probably the [man]mysql_num_rows[/man] is where you want to look. Basically, if the result returns 0, then stop and if it returns 1 result, then proceed (of course, this assumes you are using unique usernames)

Post back if you need more help once you've dug into the manual a bit more.

LarsLai

hi!
just a small hint: do not use PASSWORD as a field name as it is a reserved word in mysql.
for further information have a look at:
Treatment of Reserved Words in MySQL

mrgrammar

Originally posted by Rilto
$query = "SELECT Username, Password FROM User WHERE Username='$Username' AND Password='$Password'";

$qry = "SELECT UN, PW FROM User WHERE UN='$Username' AND PW='$Password'";
$qryres = mysql_db_query($dbname, $qry);
if (mysql_num_rows($qryres) <> 1){
echo "login failed";
}

I think that would work. I'm still new to PHP too! 😃

Brian