In this video, you will review the choices for built-in database APIs in PHP. See how the functional and object-oriented versions of the MySQLi API are similar.
- [Instructor] In this chapter, we will learn how…to use PHP to issue database commands.…PHP offers three different ways…to connect to the MySQL database…API is the technical term for each…of these connection options.…API stands for Application Prgramming Interface.…And an API is just a set of functions…which define the way we use the software.…Let's review these three APIs,…so we can decide which one to use.…The first is MySQL.…This is just the original MySQL API, the most basic way…that we can connect to MySQL.…
The second is MySQLi.…The "I" stands for improved, so, as you can guess,…it came along after the first one.…And then the third one is PDO,…which is an abbreviation for PHP Data Objects.…All three of these are extremely similar,…and once you learn how to use one,…you can easily switch to another.…The differences are a lot like the difference…between driving different kinds of cars,…like a Honda or a Toyota.…The controls for the windshield wipers…and the headlights may be in different places,…but the overall concepts are the same,…
Author
Kevin Skoglund
Released
6/27/2017- 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
Duration
Views
-
Introduction
-
Welcome48s
-
-
1. Start a Database-Driven Project
-
Blueprint the application5m 49s
-
Establish your work area6m 27s
-
Make page assets reusable6m 30s
-
-
2. Build Web Pages with PHP
-
Links and URLs9m 40s
-
Use URL parameters8m 49s
-
Encode URL parameters8m 31s
-
Encode for HTML7m 18s
-
Challenge: Add pages3m 26s
-
Solution: Add pages7m 40s
-
-
3. Headers and Redirects
-
Modify headers8m 3s
-
Page redirection7m 1s
-
Output buffering6m 6s
-
-
4. Build Forms with PHP
-
Build forms8m 53s
-
Use form parameters4m 22s
-
Detect form submission5m 24s
-
Single-page form processing6m 45s
-
Challenge: Add forms2m 9s
-
Solution: Add forms5m 1s
-
-
5. MySQL Basics
-
MySQL introduction6m 15s
-
Create a database6m 30s
-
Create a database table6m 20s
-
CRUD in MySQL4m 1s
-
Populate a MySQL table6m 15s
-
Challenge: Pages table3m 51s
-
Solution: Pages table5m 15s
-
-
6. Use PHP to Access MySQL
-
Database APIs in PHP4m 22s
-
Connect to MySQL with PHP8m 56s
-
Retrieve data8m 1s
-
Work with retrieved data6m 50s
-
Error handling6m 51s
-
Challenge: List pages2m 1s
-
Solution: List pages5m 6s
-
-
7. CRUD with PHP
-
Find a single record8m 22s
-
Use form data to create records10m 38s
-
Use form data to update records11m 24s
-
Delete a record8m 23s
-
Challenge: Pages CRUD3m 10s
-
Solution: Pages CRUD8m 1s
-
-
8. Validate Data with PHP
-
Common data validation types9m 11s
-
Validate form values8m 23s
-
Display validation errors10m 11s
-
Solution: Validations8m 1s
-
-
9. Prevent SQL Injection
-
Understand SQL injection5m 17s
-
Sanitize data for SQL8m 57s
-
Delimit data values3m 54s
-
Prepared statements3m 21s
-
-
Conclusion
-
Next steps1m 8s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Database APIs in PHP