MySQL is a database that is open source and free, just like PHP. A database allows you to read and write data, store more data, keep it organized and provides faster and more efficient manipulation. The most powerful feature is the ability to create data relationships. This MySQL introduction video describes what a database is, how it is structured and how you will use PHP to access the data.
- View Offline
- Exercise Files
We've learned enough PHP by now that we can build dynamic websites. …We can build pages that link to other pages, web forms that submit data, and …even access cookies to remember user data from page to page. …You can build a pretty good website using only these tools. …You can even have features like user log ins. …But as your site complexity increases, you are going to reach the limits of what …you can do with just PHP alone. And quickly, you'll discover that adding …a database makes a lot of sense. A database is going to allow you to both …read and write data. Mostly with PHP so far, we have been …reading data that we had coded ahead of time.…
Writing data can be done with just PHP alone, but the process is more …complicated than it is to just set up a database. …Databases also let you store more data, keep it better-organized, they're faster …to access the data. And it's much easier to manipulate the …data, especially if we want to manipulate a lot of data all at the same time. …And perhaps most importantly, databases allow us to relate data to other data. …
- 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
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- 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.