One way to solve problems with validation logic in MySQL is to experiment with false positives. PHP uses type juggling to compare two things that have a different type, and a quirk of the program is that it may say two strings are equal because they both start with spaces or plus signs. This online tutorial helps you learn to code for exact matches instead of equal matches, and for triple equals, not double equals.
- View Offline
- Exercise Files
In this movie we're going to talk about problems that can occur in your …validation logic. Now these are problems that happen with …any if statement, but they're critical to get right when we're working with validations. …Normally in your code, if your if statement's not right, well, then you'll …see it right there on the page and know, while you're developing, that you've done …something wrong. But if our validations fail us, then we …lose control over the data that's coming into our application. …And we may not even know about it because we're not there at the time that it happens. …So let's work to understand some of the common problems. …The last movie we wrote a validation, that would check to make sure the @ …symbol, was inside a string that was being submitted by a form.…
And the string POS function is what we were using. …That function either returns the position where the item is found, or it returns …false if it's not found at all. If we use the simple comparison operator …equals equals then we get false positives. …
- 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.