Login Verification Problens

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
HaVoC
Forum Commoner
Posts: 83
Joined: Sat Feb 07, 2004 7:20 am
Location: Smiths Falls, CA

Login Verification Problens

Post by HaVoC »

Now I tried, I think in my opinion an unusual way. But ever so simplistic.

[php_man]
$query = 'SELECT * FROM members WHERE cname = ' .$_POST['cname'];

$result = mysql_query($query);

While( $rows = MySQL_fetch_array($result) ) {
$cname = $rows['cname'];
$password = $rows['password'];
if ( $_POST['cname'] == $cname && md5($_POST['password']) == $password ) {
echo "Logged In!\n";
}else{
echo "Wrong Username and/or password!\n";
}
}
[/php_man]
Can this be done?
qads
DevNet Resident
Posts: 1199
Joined: Tue Apr 23, 2002 10:02 am
Location: Brisbane

Post by qads »

Code: Select all

<?php
$username = addslashes(trim($_POST'cname']));
$password = md5($_POST['password']);
$query = mysql_query("SELECT * FROM members WHERE `cname` = '$username' and `password` = '$password' limit 1");
if(mysql_num_rows($query) == 1)
{
echo "Logged In!\n"; 
}
else
{ 
echo "Wrong Username and/or password!\n"; 
} 
?>
Post Reply