Creating a Table with User and Psw

Security issues related to php and mysql usage. How to make your code secure? Security measures and configurations? It's all in here!

Moderators: egami, macek, gesf

Post Reply
liquedus
php-forum Active User
php-forum Active User
Posts: 264
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada
Contact:

Sat Jul 05, 2003 5:27 pm

create table yournamehere (id int auto_increment primary key, username varchar(20), password varchar(50))

and i am guessing that all the passwords have to be md5'ed

hope that helps :)

patna_in
New php-forum User
New php-forum User
Posts: 101
Joined: Sun Feb 06, 2005 10:54 am
Contact:

Sun Feb 06, 2005 11:06 am

Now how i match this password with a password given by a php driven site.

User avatar
Alexej Kubarev
Site Admin
Site Admin
Posts: 2213
Joined: Fri Mar 05, 2004 7:15 am
Location: Täby, Stockholms län
Contact:

Fri Feb 11, 2005 1:40 pm

the password that you are getting from a user should be md5 encoded.. then you simply try to selelct the user with that use4rname and that md5 encoded password... in case you get 0 rows: wrong username or password error should be thrown..
Best Regards,
Alexej Kubarev
-------------------------------
Zend Certified Engineer
Image Image

Post Reply
  • Information
  • Who is online

    Users browsing this forum: Yahoo [Bot] and 1 guest