PHP with MySQL Essential Training
I’m happy to announce PHP with MySQL Essential Training has been released on the lynda.com Online Training Library. It’s almost 11 hours of video training on PHP. I start with the basics of the PHP language and work up to dynamic web pages with a MySQL backend by demonstrating how to build a content management system.
Some of the topics it covers include: installation, PHP language fundamentals (variables, arrays, loops, functions, etc.), blueprinting an application, building dynamic pages, structuring and interacting with databases, how to build, validate and process forms, and regulating user access with passwords. I also provide practical advice, give best practices examples, and demonstrate refactoring techniques to improve existing code.
PHP with MySQL Essential Training is available online as streaming video to subscribers of the lynda.com Online Training Library ($25/month, $250/year, $375/year with exercise files included). It is will also be available as a CD-ROM soon both through Lynda.com and Amazon.com.
I also recorded Ruby on Rails Essential Training for the lynda.com Online Training Library which is available online to lynda.com OTL subscribers and on CD-ROM, both through lynda.com and Amazon.com, for $99.95.
If you try any of them and find that they are helpful, be sure to let me know!
August 5th, 2007 at 12:10 am
Hello Kevin,
I watched your Lynda title on PHP and MySQL.
The training helped me out a lot and I want to thank
you for creating an accessible yet quite in depth presentation
of creating a CMS.
I enjoyed the fact that you took the time to go over refactoring, best practices issues and pointing out production environment security needs.
I have been using the online training library for quite some time now and your title is
definitely one of the highest in quality and hands on coverage in the Lynda.com library!
Thanks again
Paul
(Israel)
August 24th, 2007 at 10:11 am
[...] already announced the online release of PHP with MySQL Essential Training. I’m really happy that it’s been getting tons positive user feedback. It seems to be [...]
March 26th, 2008 at 1:35 am
I can’t thank you more for your tutorial of “PHP with MySQL Essential Training”. You are one of the best trainer at lynda.com.
Thank you very much for your effort and teaching techniques.
July 8th, 2008 at 10:59 am
agreed. Kevin, you did a great job. After reviewing several books, I always come back to your videos for help.
July 23rd, 2008 at 3:50 am
fantastic training i am a graphic designer and have wanted to break into web design and development and have found you tutorials like a bible for it. Thanks for a complete explanation of php and mysql definatly the best trianer on lynda.
August 19th, 2008 at 2:43 pm
Kevin,
Thank you for such a wonderful product! I’m a web developer, that usually outsources PHP/MySQL portions of web sites — beyond the basic “includes” and “requires”. I’ve been wanting to do more of the work first-hand, and your training videos fit the bill perfectly.
I have a solid background in JavaScript, Flash (ActionScript 1 and 2), and Director (Ugh! Lingo!), as well as solid experience with X/HTML and CSS. I’ve wanted to focus on a single server-side language and chose PHP. Your videos got me up to speed very quickly.
My one question — assuming you read all of these comments — is I’m wondering what would be the next logical “learning tool” for expanding the MySQL foundation that you set in your video series. The forums on the MySQL official site are helpful, but I am interested in a hands on tutorial — regardless of whether it is web, video, or print. Suggestions?
Again, thank you for an excellent product. I’m seriously considering purchasing the disc version to have on hand as an in-house training tool.
Best regards,
Rob
August 19th, 2008 at 2:52 pm
@Rob: Thanks! I’m developing a sequel to this training now. It won’t be MySQL focused but it should help sharpen your skills. I don’t know of a “pure MySQL” training to recommend. I’d love to eventually do a title dedicated to MySQL, but I have to find the time first.
Also, before you purchase the disc, you might want to wait just a week or two. There is a revised version on its way with a few clarifications and bug fixes here and there as well as updated Mac installation instructions.
September 17th, 2008 at 11:11 am
Hi Kevin, I’m going through your tutorial at the Lynda.com site. I have a question, I’m sure I must have missed something. In the setting cookies video you place your setcookie function in the body of the html. When I do this I receive an error about the header. Do I have to config my php.ini file so this won’t happen?
Thanks
Steve
September 17th, 2008 at 11:30 am
Sorry Kevin, I just loaded a new version of your tutorial from lynda.
January 24th, 2010 at 7:46 am
Awesome tutorial. Almost finished it. Thanks! I have a general question. In the video you sometimes include a bit of php+html and sometimes you use a function not to repeat your self.
I was wondering when to use an include-file and when to use a function?
January 24th, 2010 at 8:49 am
@Jelle: It is largely a matter of style and personal preference. I tend to use include files when it is mostly HTML and functions when it is mostly PHP or has variables that require processing. And sometimes I start with an include file and then decide a function would work better, or vice versa.