SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Wizard Zaggs's Avatar
    Join Date
    Feb 2005
    Posts
    1,051
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    check for case sensitive username/password

    Hi Guys,

    How can I check for case sensitive usernames and passwords using PHP & MySQL?

    I have tried the following without success:

    PHP Code:
    select id from table where username='".$_POST['username']."' and password='".md5($_POST['password'])."' collate latin1_bin 
    Thanks in advance...

  2. #2
    SitePoint Zealot
    Join Date
    Nov 2005
    Posts
    181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This belongs in the database forum... but anyway, a quick google search popped this up: http://gilfster.blogspot.com/2005/08...-in-mysql.html

  3. #3
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,258
    Mentioned
    196 Post(s)
    Tagged
    2 Thread(s)

    query using POST vars

    BTW. You really don't want to use POST directly in your queries like that.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •