There are five steps used to access data in MySQL with PHP. The first and last steps, connecting to the database and closing that connection, should only be performed once for each script. Using a telephone analogy, this video demonstrates the steps involved in connecting to MySQL with PHP and then closing the connection after retrieving your data.
- View Offline
- Exercise Files
In the last movie, we decided that the database API that we will use, is the …procedural version of MySQL. Now we're ready to learn how to use PHP …and MySQLi to connect to our database. There are five basic steps for database …interaction in PHP. First we create a database connection. …That's a bit like picking up the telephone to call somebody. …Then, once we've got the database on the line, we're ready to start issuing …commands to our database. So we perform our queries, those can be …Select statements, they can be Insert statements, they can be Delete, all but …MySQL that we just learned. That would be in step number 2.…
If we're doing a Select then it would, might return data to us. …And we would use that return data. We could add there output it to the screen. …To the browsers. So the user could see it. …Or you might store it in an array. Or in a variable. …Do something with it. The whole point of querying the database …is to get back the data. And then we want to do something with …
- 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.