Get an overview of databases, MySQL, and the fundamental terminology and concepts.
- We've learned to use PHP to build pages…which link to other pages and to create web forms…which can submit and process data.…You can build a solid, dynamic website…using only these tools, but for complex sites,…you will reach the limits of what you can do…with just PHP alone.…Adding a database is the next step,…and it offers many benefits.…Databases provide a way to both read and write data.…They allow you to store more information,…and to keep that information organized,…so that you can access it faster.…
They also allow you to easily relate…different types of data to each other.…The database we'll be using is MySQL.…You can use other databases with PHP,…but MySQL is the best supported, and the most common choice.…It's open source, and free, just like PHP.…It's also very easy to use, and because it's popular,…you'll find a lot of online support if you ever need help,…and it provides a good introduction…to many common database concepts.…If you've never worked with a database before,…chances are that you have worked with a spreadsheet…
- Organizing project files
- Including and requiring files
- Working with URL parameters
- Encoding dynamic content
- Modifying headers and page redirection
- Creating forms and processing form data
- MySQL basics
- Using PHP to access database tables
- Creating, reading, updating, and deleting database records with PHP
- Validating data
- Preventing SQL injection
Skill Level Beginner
1. Start a Database-Driven Project
2. Build Web Pages with PHP
3. Headers and Redirects
4. Build Forms with PHP
5. MySQL Basics
6. Use PHP to Access MySQL
7. CRUD with PHP
8. Validate Data with PHP
9. Prevent SQL Injection
Next steps1m 8s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.