Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

PHP Tutorial - 32 - Email Confirmation for PHP Game

Loading...

Sign in or sign up now!
28,271
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 31, 2009

Make sure to watch this video in HIGH QUALITY!

I will post all the code at my website http://thenewboston.com so you guys can get it all there!

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (27)

Sign In or Sign Up now to post a comment!
  • 1:22 connect.oho

  • your code is vunerable to sql injection attacks. just sayin.

  • where did that passkey came from?

  • *Looks through 80 lines of code*

    *1/2 hour later*

    "OH! I put 'pass' not 'password'!"

  • @SCARHExtendedMags Or you could name it something useful and sanitize the input, eliminating the risk altogether.

  • @dandymcgee You could name the temp table someting stupidly long, then it would be unlikely to guess.

  • @moufpuncha How hard is that to guess though? Far more often than not I come across tables named "Customers", "Employees", "Payroll". Don't every rely on security through obscurity, I know a hundred people who will tell you a false sense of security is better than no security because it's easier to forget about it.

  • @dandymcgee yeah but wouldn't you have to know the name of the table or database?

  • First off, great beginner tutorial. You're really good at explaining tough concepts.

    To anyone watching, just keep in mind what could happen if a user browses to:

    ?passkey=whocares'; DROP TABLE temp; --

    ALL user input should be sanitized on arrival, and especially before performing a SQL query.

  • $sql -> Lame query...

    True query should be: INSERT INTO temp (code,username) values ('$confirm_code','$name')

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more