After completing the first two parts of the administrator area CRUD, you will need to create an edit subject form. While this can be done by building on what was created for the creation form, you will also need to populate this new form with values from the database, since you will be editing existing entries from the MySQL database. Over the course of this tutorial, you will learn the steps required in creating an edit subject form.
- View Offline
- Exercise Files
We completed the first two parts of our admin area CRUD, read and create. …Now we're going to build on what we did for create as we implement update. …Like create, update will have a web form to let us edit a subject but there's one …main difference between the two. With update we're going to need to first …find an existing subject in the database and then pre-populate its form with our values. …With create we didn't need to do that because there wasn't an existing subject …to worry about. So in a sense update is going to combine …the work that we did for both read and create.…
We're going to read it from the database and then we're going to display the form …that we had for create but with values populated in it. …I want us to make one additional change. When we coded our create action, we did …it as two separate php pages. The first page displayed the form and the …second page performed the form processing. …This time I want us to create a single form that will submit to itself. …The form processing will just live at the top of the PHP page before the form displays. …
- 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.