When creating records with PHP, a true or false result of the operation is returned from MySQL. While there is no data to work with after the command, there are still important steps to take using the result. In this video you will learn how to use the MySQLi interface to insert some data using PHP. You'll also receive some tips about formatting queries in PHP for easier readability, checking results and how to handle query failures.
- View Offline
- Exercise Files
We have learned how to read data from the database. …The process for creating updating and deleting records is going to be very …similar with a few key differences. The most important difference is just …that when we do a select, we're expecting to get back rows of data as a result. …Either that or an empty set with no rows. But still we're expecting a resource …result to come back to us that we then parse through. …With insert, update, and delete, we're not expecting to get any data back. …We're just affecting a change on the database either inserting a row, deleting …a row or updating a record in place. So it just returns true or false to us …for whether it succeeded or whether it failed.…
So with this difference in mind, let's try and use our MySQLI interface to do an …insert of a new subject. So to begin with let's open up databases.php. …Now I don't want to change this file. First of all we can see all of four …subjects with it which is going to be handy later on and also it's a good …
- 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.