Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.
I want to thank you for taking PHP with MySQL essential training. We've now completed our first project in PHP, a complete content management system. We have our public area, that's the part of the site that we want our public users to see. And it allows them to see subjects and pages that we've chosen for them to see in a read only context. And then we have the admin area that has user authentication, which requires admins to authenticate themselves by logging in with a user name and password. And then gives them access to areas to allow them to manage the site content on the front end for users, and to determine what subjects and pages they should see.
As well as manage the admins who ought to have access to our admin area. It's a very simple application. I am sure you can probably think of dozens of new features to add to it. Our goal wasn't to build the best content management system ever made. But to learn enough PHP fundamentals so that we could create a fully realized project. We came a long way during this tutorial. From the very basics of PHP to interacting with data bases. To the fundamentals of password encryption. And along the way we learned a lot about best practices and programming techniques that I hope will help you to think like a programmer and write smarter code.
Thank you for taking this journey with me. There are a lot of researches out there to help as your journey continues from here. Once you've had some practice with the essentials of PHP in MySQL. You may want to learn about object oriented PHP, which I teach in PHP with MySQL Beyond the Basics, another tutorial on lynda.com. There are also many online resources to guide you. php.net is one of the best. And there are hundreds of blogs and forums where developers ask questions and trade tips. And of course you can always refer back to these videos, and our sample code as a reference if you get stuck. Remember developing is a process of making mistakes and making bugs and working through them until you understand the problem. So don't get discouraged if you run into a problem. Just start simple and move through the problem step by step checking your code and assumptions as you go.
PHP and MySQL make it really easy to create amazing sites for the web. I look forward to seeing all the projects that you create online someday. Until then, happy coding.
Find answers to the most frequently asked questions about PHP with MySQL Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.