PHP with MySQL Essential Training
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.
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
- Subject:
- Developer
- Software:
- MySQL PHP
- Author:
- Kevin Skoglund
Welcome
Welcome to PHP MySQL Essential Training. My name is Kevin Skoglund. In this course, we'll review the basic PHP data types, and learn to use PHP's control structures, like logical expressions and loops, in order to control how our code executes. We'll cover many of PHP's built in functions, we'll also learn to define our own custom functions. We'll cover the basics of SQL and learn how to use PHP to connect to a MySQL database, which will allow us to create, read, update, and delete records.
We'll learn the fundamentals of user authentication, that is the process of requiring a username and password to log into a PHP application. And finally we'll build a complete PHP web application from start to finish. A content management system that will allow admins to log in and manage the website content that gets displayed to the public. I'm excited and I hope you are too. So lets get started learning PHP. (MUSIC).
Find answers to the most frequently asked questions about PHP with MySQL Essential Training .
- Q: This course was revised on 6/4/2013. What changed?
- A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.
- Q: This course was updated on 5/20/2015. What changed?
- A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.
please wait ...
