laytonsdad's Profile User Rating: -----

Reputation: 424 Architect
Group:
Contributors
Active Posts:
1,808 (1.17 per day)
Joined:
30-April 10
Profile Views:
16,456
Last Active:
User is offline Today, 11:06 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
Chrome
Favorite Processor:
Intel
Favorite Gaming Platform:
Nintendo
Your Car:
Toyota
Dream Kudos:
250

Latest Visitors

Icon   laytonsdad Needs help with a design idea...

Posts I've Made

  1. In Topic: Best way to select using where clause for exact match

    Posted 21 Jul 2014

    Thank you all for your input. The userName field is has a unique index set. I was simply wondering about the case sensitivity as it seemed wrong that "Tom", "TOm", and "TOM" or any variation of caps and lowercase letters matching "tom" would allow access with the correct password inserted twice.

    Again thank you all for your wisdom.
  2. In Topic: Best way to select using where clause for exact match

    Posted 18 Jul 2014

    Dormilich

    I see your point. The site only has a back end for adding posts to a blog. I will be inserting the usernames and there will be no duplicates.
  3. In Topic: Best way to select using where clause for exact match

    Posted 18 Jul 2014

    View PostDormilich, on 17 July 2014 - 12:19 AM, said:

    View Postlaytonsdad, on 16 July 2014 - 11:55 PM, said:

    Here is the query I am running now.

    SELECT * FROM users WHERE BINARY userName = ? AND password = ? LIMIT 1;

    isnít it dangerous if you can have duplicate user names?



    The Problem was with the query, if I have a user "admin", and the user types "Admin" and the same password for "admin" they get access. This is not good. There should only be one "admin" user name with the password associated with it.

    BetaWar said:

    There is a STRCMP function in MySQL which returns 0 if the two strings are exact matches, that's normally what I use when I care to do case-sensitive matches


    Thank you beta I'll take a look.
  4. In Topic: 'undefined' is not an object

    Posted 12 Jul 2014

    Can you post the entire code as it is written in the problem. I believe you have a scope issue but can not be positive without seeing the full codes structure. Just remember to use code tags. :)
  5. In Topic: 'undefined' is not an object

    Posted 11 Jul 2014

    This discussion on variable scope is great to read. Check it out.

My Information

Member Title:
Cheese and Sprinkles
Age:
32 years old
Birthday:
December 28, 1981
Gender:
Location:
Temecula CA
Interests:
Coding and learning new languages
Full Name:
Dustin Parker
Years Programming:
14
Programming Languages:
HTML, CSS, PHP, JavaScript, Java, C#, ASP.net, XML, python

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://dpwebprogramming.com
Facebook:
http://facebook.com/pagesbydustin
Twitter:
pagesbydustin

Comments

Page 1 of 1
  1. Photo

    Michael26 Icon

    02 Apr 2013 - 09:51
    Congrats on winning signature of the month. :)
Page 1 of 1