Prepared statements in MySQL help database query functions by picking up a great deal of the legwork required to parse queries correctly. While this is a more advanced feature, it is nonetheless highly important. This online video introduces prepared statements in MySQL and shows how they can change the way you query dynamic data from complex databases.
- View Offline
- Exercise Files
Prepared statements are a feature of MySQL, and of many other databases. …The topic is too advanced for an introductory tutorial, but I do think …it's important for you to understand what they are. …The general idea is that you give MySQL a template for a query that you want to …run, with places indicated where you can fill in the blanks later. …For example, we might have an insert statement, and in place of the three bits …of data that we would be dropping into the columns, we would put question marks. …Those are place holders for where the data is going to go later. …Then when we want to run the query: we call up the template, fill in the blanks …and then MySQL to run it. So why do it this way, why go that extra step? …Well, because when any query runs, the database has to parse the query and …develop a plan for running it. With prepared statements, the database …will do this work once and then you can reuse it for future queries where only …the variables change. The parsing and the plan of attack stay …
- 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.