TheCodeCast: Episode 002 - Login System Part 2
Difficulty Rating:
3 out 5 Cups Of Coffee
Second episode is here and we’re trying something a little different this time around. This episode was filmed in front of a green screen. See I feel like I can explain things a lot better if I can talk with my hands and have eye contact with the viewer. Anyways you’ll see the results in this episode. This time around we cover the down and dirty PHP code that hooks up all that database stuff from last time to some sort of user interface. Its not pretty, but it is functional. Now also, I just want to say that there are probably a billion different ways to build a login system with PHP/MySQL, and this is just my way. So please hold off on the “That’s Not How You Do It!” emails. Anyways, check out the show and let me know what you think in the comments.
Things mentioned in this episode:
PHP
PHP Sessions
PHP MySQL Functions
Code Files:
All Project Files In A Zip File
index.php
login.php
logout.php
protectedPage.php
Download Link Below:
June 4, 2007
Hi there,
when’s the new show coming out?
Thanks in advance
June 5, 2007
Hey when is the next ep coming ??
June 16, 2007
I get 404 errors for episode 1 & 2 downloads
July 10, 2007
Thats right…we want more CodeCast’s! Keep them coming…
And you forgot to put the php code files used on the ep2 on the website.
July 14, 2007
[...] The CodeCast ? TheCodeCast: Episode 002 - Login System Part 2 (tags: php login codecast) var adv_random = Math.random() * 10000; var adv_width = ‘510′; var adv_height = ‘0′; var adv_key = ‘20070518125338′ + adv_random; var adv_txuserid = ‘6INYE’; var adv_ad_align_type = ‘1′; var adv_lo_border = ‘cecece’; var adv_lo_background = ‘ffffff’; var adv_lo_adtitle = ‘4f72b3′; var adv_lo_addesc = ‘666666′; var adv_lo_adurl = ‘2c81c4′; var adv_adno = ‘3′; var adv_bg_img = ’skin001′; var adv_ui_type = ‘S’; getAdClixAD(’20070518125338′ + adv_random); [...]
August 25, 2007
Attack on TheCodeCast (Episodes One and Two)…
Continuing from our last post, I am here going to implement Jake’s tutorial in Ruby on Rails. I realize that his goal is to present all manner of languages and technologies. In the interest of healthy competition, and driving traffic to both of…
April 14, 2008
Is this animated character a video thats been inserted, or a speech synchronizing program that is just doing a great job? If so, I’d be curious what program that is!
April 14, 2008
Great stuff, thanks..
More More More…
April 14, 2008
Fullscreen doesn’t seem to work in Firefox 2.0.0.13 on Windows Vista.
May 13, 2008
Hey Jake, I really like what you did with those first two episodes. They were really put together well. Any chance on more episodes in the future?
February 13, 2009
It’s too bad that your example code contains a number of gaping security holes:
- An SQL injection bug allows anyone to log on by specifying something like “‘ OR 1=1; –” as a username.
- By inserting unchecked values taken from query variables in your HTML you allow for cross site scripting attacks.
Sure, these scripts are just provided here as examples. But the problems are fundamental to these kind of scripts and easy to solve without making the code very complex. Furthermore, as you provide the script sources you can count on them being used in the real world in some form. I think you have a responsibility to people reading your blog to provide them with scripts that provide at least a basic amount of security.
February 13, 2009
Good job!
February 13, 2009
Hi,
You main page layout is broken in firefox. Hidden video displays on top. Add wmode=”transparent” into tags to fix.
February 13, 2009
Not a bad video series you have going here, I especially liked the attention to the minor details that most overlook, such as “ini_set()”.
However, I do agree a basic warning (even in comment within the script) is needed to stress the non-use of these files in the real world.
Look forward to seeing future episodes!
Matt