There are three basic functions for retrieving data from MySQL. These functions control retrieving the data, working with the data, and releasing the memory when you are done. In this tutorial you will learn to use the mysqli_query, mysqli_fetch_row and the mysqli_free_result functions to access, use, and release data properly from your MySQL database.
- View Offline
- Exercise Files
In the last movie, we learned how to create and close a MySQL connection. …But we haven't done anything with that connection yet. …We need to be able to issue queries from MySQL and then work with data that it …brings back to us. And that's what we'll do in this movie. …To do that, we're going to learn three new functions. …They're MySQL API functions. They're mysqli_query, which is, of …course, what we'll use to do our querying. …Then if we get results back, we'll use mysqli_fetch_row. …To work with those results, and then as we listed as one of our key steps, we …want to free the result at the end. To tell PHP that it's okay to flush that …memory and not try to hold onto those results any longer.…
That'll free up some memory for us. Alright, so let's try and add these to …the databases.php file that we started in the last movie. …So, let's open up databases.php, and you can see I've already got my connection up …here at the top. And I'm closing it down here at the bottom. …Now, I need to actually do my query, and I'm going to do it right here in a new …
- 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.