After getting an overview of the five basic steps for PHP-database interaction, learn to use mysqli_connect to connect to a database and mysqli_close to close the connection when done.
- [Instructor] In this movie,…we'll learn how to use PHP's MySQLi API…to connect to our database.…There're five fundamental steps…to getting PHP to interact with the database.…The first is that we need to create a database connection.…That's essentially like logging in to MySQL.…Once we're logged in, then we can perform a database query.…We can use the results of that query…to create whatever part of our page we need…to output the results,…or maybe just to do calculations inside PHP.…But once we done working with the data,…we can release the returned data…and finally close the database connection…or log out.…
Now, steps one and five…should only happen once for each PHP script.…You log in at the beginning,…you perform your queries,…and at the very end, you log out.…But you may repeat steps two through four…many times in a PHP script.…You would make a query on one table,…get back the data,…maybe you build part of your page,…then you turn right around…and you make another query to the database.…Maybe to a different table,…
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: Connect to MySQL with PHP