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. Instructors •.
Kevin Skoglund builds custom web solutions at Nova Fabrica, and teaches web development to others at Lynda.com. Kevin Skoglund is the founder of, a web development agency specialized in delivering custom, scalable solutions using Ruby on Rails, PHP, SQL, and related technologies. Nova Fabrica clients include An Event Apart, Atlas Carpet Mills, Consulate Film, Gregorius Pineo, Maharam, Oakley, and The Bold Italic. Kevin is a lynda.com author with over 15 years of teaching and web development experience.
Related courses • Course By: Kevin Skoglund 10h 26m 33s • Course By: Kevin Skoglund 3h 37m 35s • Course By: Kevin Skoglund 2h 54m 19s • Course By: Kevin Skoglund 2h 17m 2s • Course Transcript If you are a premium member of the lynda.com training library, you will have access to the exercise files that are used throughout this title. If you are a monthly or annual subscriber to lynda.com, you won't have the exercise files that accompany this tutorial, but you can follow along with me. Everything that's in the exercise files, we will create during the tutorials. So, as long as you continue to work along with me, your files will exactly mirror what's in the exercise files. Remember, that you can pause the video or rewind if you need more time to copy something down. The exercise files for this title are arranged by chapter and by movie. And you can find the exercise files that correspond to the movie that you're watching, by first looking for the chapter number, and then the movie number.
Join Sasha Vodnik for an in-depth discussion in this video Exercise files, part of Learning Chrome Web Developer Tools. Jun 27, 2017. Learn how to build dynamic, data-driven webpages using PHP with MySQL.
In order to make use of the exercise files, you'll want to first make sure that you install and configure the necessary software, as shown in chapters 2 and 3. That is PHP, MySQL, and the Apache web server. Once you're confident, that you have everything installed and configured. Then you will want to copy the contents of the exercise files folder into your web document root directory. If you don't know where that is, I show you how to find your document root in the installation chapters. On my Mac, that's going to be inside my User directory, inside the Sites directory, which we also create in the installation chapter.
It's a good idea to make a copy of the exercise files, so that you still have the original to refer back to if you make changes. On my Mac, I will Option drag the folder Sandbox over into my Sites directory. Now, your files will match mine at the start of the movie.
Beginning in chapter 13, we'll be incorporating a database into our project, and for the exercise files to work, your database needs to match what the files expect. In the exercise files for these chapters, you'll find a database file that you can load into MySQL, and put your database into the same state as mine. If you don't already have a database to load the file into, you'll want to review the beginning of chapter 13, where we first create our database and set up the necessary permissions. You can load that file directly into a MySQL database, either by using a tool such as PHPMyAdmin, or by going to a command line application, such as our Terminal, and typing in mysql-u followed by a user name that has access to the database. We use widget_cms in our examples, dash p that key that would be entered in the password followed by the database name, widget corp. Then a less than sign followed by the path to get to the SQL file that you want to load.
You can either type that in by hand or on the Mac, you can actually drag the file into the terminal and it will output the full path for you. Once you've located the file that you want to load into the database, simply hit Return. It will prompt you to enter the password that the username requires to access the database. And then it will update the database with the instructions in that SQL file.
Note, that the import will remove all old database data at the same time as it imports the new data. Importing can also be useful if you do experimenting on your own, but then want to get your data in sync with mine.
Once you have the same files and the same database, you'll be able to work right along with me. Don't forget that you can also use the exercise files to check your work as you go along. • Practice while you learn with exercise files.
Watch this course anytime, anywhere. Course Contents • Introduction Introduction • • • 1. PHP Overview 1. PHP Overview • • • • • 2. Mac Installation 2. Mac Installation • • • • • • • • • • • 3.
Woodforest Bank Card Activation Number. Windows Installation 3. Windows Installation • • • • • • • 4. First Steps 4. First Steps • • • • • 5. Exploring Data Types 5. Exploring Data Types • • • • • • • • • • • • • 6. Control Structures: Logical Expressions 6.
Control Structures: Logical Expressions • • • • • 7. Control Structures: Loops 7. Control Structures: Loops • • • • • • • 8. User-Defined Functions 8.
User-Defined Functions • • • • • • • 9. Debugging • • • • 10.
Building Web Pages with PHP 10. Building Web Pages with PHP • • • • • • • • • 11. Working with Forms and Form Data 11. Working with Forms and Form Data • • • • • • • • • 12. Working with Cookies and Sessions 12. Working with Cookies and Sessions • • • • • • 13. MySQL Basics 13.
MySQL Basics • • • • • • • • 14. Using PHP to Access MySQL 14. Using PHP to Access MySQL • • • • • • • • • • 15. Building a Content Management System (CMS) 15. Building a Content Management System (CMS) • • • • • • • 16.
Using Site Navigation to Choose Content 16. Using Site Navigation to Choose Content • • • • • • 17. Application CRUD 17. Application CRUD • • • • • • • • • • • • • 18. Building the Public Area 18. Building the Public Area • • • • • • 19.
Regulating Page Access 19. Regulating Page Access • • • • • • • • • • Conclusion Conclusion •.