URLs may contain reserve characters that will cause problems in PHP and MySQL. To avoid these problems, you can encode the reserve characters by changing them to hexadecimal digits. While this is a useful way to prevent errors, it does require some special coding. Watch this online video to learn about encoding GET variables that will work within your programs.
- View Offline
- Exercise Files
Now that we know how to construct URLs to be used as links, we need to talk about …the characters that we're allowed to use in those URLs. …URLs can contain the most common characters like letters, numbers, …underscores, and dashes. But there are some characters that are …going to cause problems because they have special meaning to the URL. …These are known as reserved characters. Here are a list of the reserved …characters that we have problems with if we include them in the URL. …You can see there are quite a few. When we're constructing URLs for lengths, …we must encode these characters so they don't interfere with the function of the URL.…
Encoding a reserved character means converting that character to a percent …sign followed by a pair of hexadecimal digits. …Hexadecimal just means that in addition to zero to nine, we can use the letters A …through F as if they were digits, too. So, what we'll need to do is be able to …convert each of these characters into its hexadecimal form, put it in a URL. …
- 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.