The easiest form-field requirement in MySQL is that a user cannot leave a form blank. Character requirements such as verifying that an email address has the @ symbol are also common. This video on validating form values walks you through present string length, type inclusion, uniqueness, and format. A high-level function in format is preg_match, and it lets you apply a regular expression to see if there is a match.
- View Offline
- Exercise Files
When we accept data from users especially from web forms, let's say, submit, we …almost never want to just accept any old data that they send In fact, it's to our …benefit as developers to assume that users are sending us the worst kinds of …data possible, that may be even trying to hack our site and do us harm. …Checking the submitted data carefully is the road to having robust and secure code. …So we need to spend some time thinking about requirements for our data and …learning how to enforce those requirements. …I promise you're going to spend significant time on this for every …project that you do, so it's worth investing the time in learning how to do …it and to avoid the pitfalls. Imposing data requirements is called …validating our data, and you'll hear me refer to the process as validations or …passing or failing our validations. If data passes validations, it means that …data was acceptable and we can use it. If it fails validations, that means there …was a problem and we need to reject it. And most often that means going back to …
- 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.