Page 1 of 1

Login Verification Problens

Posted: Sat Feb 07, 2004 7:20 am
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?

Posted: Sat Feb 07, 2004 9:19 am
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"; 
} 
?>