470,849 Members | 1,033 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

How to validate user name and password with case sensitiveness in php?

Hello Friends!
I am Manu Gupta, an IT Engineering student, learning PHP presently. I
want to match user name and pwd from MySQL, it shows case
insensitiveness. Can anybody help me in implementing case sensitiveness
in either PHP or MySQL?
Thanks in advance

Feb 10 '06 #1
3 1456
What do you have so far? Can you show some code?

Feb 10 '06 #2
When you create your mysql table, set the data type attibutes for
username and password columns to binary.

create table login ( uname VARCHAR(8) BINARY, ... ...)

Feb 10 '06 #3
le********@gmail.com wrote:
Hello Friends!
I am Manu Gupta, an IT Engineering student, learning PHP presently. I
want to match user name and pwd from MySQL, it shows case
insensitiveness. Can anybody help me in implementing case sensitiveness
in either PHP or MySQL?
Thanks in advance


http://dev.mysql.com/doc/refman/5.1/...nsitivity.html

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Feb 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Joeri KUMBRUCK | last post: by
3 posts views Thread by Wm. Scott Miller | last post: by
1 post views Thread by Raghuram | last post: by
3 posts views Thread by ojnoka | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.