Auth class----MySQL user
| From: | Pahlevanzadeh Mohsen | Date: | Wed, 08 Sep 2004 00:25:54 +0000 |
| Subject: | Auth class----MySQL user | ||
| Groups: | php.general php.pear.general | ||
| Request: | Send a blank email to php-general+get-196090@lists.php.net to get a copy of this message | ||
Dears,My code is :
<?
function Login()
{
echo "xxx";
echo "<form method=\"post\"
action=\"".$_SERVER['PHP_SELF']. "\"\">";
echo "<input type=\"text\" name=\"u\"> <br />";
echo "<input type=\"password\" name=\"p\"> <br />";
echo "<input type=\"submit\">";
echo "</form>";
}
$username=$_POST['u'];
$password=$_POST['p'];
echo md5('mohsen');
$parameterforauth=array("dsn"=>"mysql://$username:$password@localhost/mem",
"table"=>"usernames",
"usernamecol"=>"user",
"passwordcol"=>"pass");
$ptr_auth_C=new Auth("DB",$parameterforauth,'Login');
$ptr_auth_C->start();
if ($ptr_auth_C->getAuth())
echo "Successfuly loggined!!!!!!!";
?>
I have opened mysql shell,& i have typed following
statement:
use mem
grant all privileges on usernames to mohsen@localhost;
set password for mohsen=password('loverx');
insert into usernames values
(user='mohsen',pass=md5('loverx'));
commit;
But i can't loggin into my program.(with mohsen as
username & loverx as password)
Thsu i can't see "Successfuly loggined!!!!!!!"
Please guide me.....
Yours,Mohsen.
=====
---------DIGITAL SIGNATURE-------------------
///Mohsen Pahlevanzadeh////////
Network administrator & programmer
My home phone is: +98213810146
My email address is
m_pahlevanzadeh at yahoo dot com
My website is: http://webnegar.net
----------------------------------------------------------------
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail