Join David Powers for an in-depth discussion in this video Setting up the database for the example site, part of PHP: Clean URLs on Apache Server.
- [Voiceover] The best way to learn…how to create clean URLs with mood rewrite…is with some practical examples.…To use the exercise files for this course,…you need to set up a small database…in MySQL or MariaDB.…The table structure and data are in this file,…which is in the Chapter 1 01_03 folder…and it's called handp.sql.…This creates a database called handp…and then populates four tables with data.…It's a dump file.…
So you can load it into MySQL or MariaDB…in your testing environment using the command line…or a database administration tool,…such as Navicat or phpMyAdmin.…I'm going to use phpMyAdmin,…which I've got open in my browser.…So, I need to go the important tab…and then navigate to that file handp.sql…in the exercise files.…I have got the exercise files on my desktop.…Chapter 1 01_03 folder handp.sql.…
Select that and then scroll down to the bottom…in phpMyAdmin,…click Go.…It creates the database,…imports everything.…Here it is.…Handp.…Let's take a quick look at it.…And there are the four tables.…Arrangements, flowers, search2arragnments, and searchterms.…
Author
David Powers
Released
5/23/2016Rather than checking URLs individually, David shows how to evaluate and update them sitewide with the Apache mod_rewrite module. Watch these tutorials to learn how to enable mod_rewrite on your server, understand the structure of mod_rewrite rules, remove unnecessary file extensions, convert query strings into readable numbers and text, and use rewrite maps to look up complex values without regular expressions. Plus, learn how to enhance search results and provide searchers with links to specific parts of a webpage.
- Checking your Apache setup
- Creating simple regular expressions
- Removing .php from URLs
- Replacing query strings
- Displaying clean URLs in search results
- Linking to parts of a webpage
- Creating a clean URL for any PHP file
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 6s
-
Using the exercise files3m 43s
-
-
1. Checking Your Setup
-
2. Basic URL Rewriting
-
How to use mod_rewrite3m 40s
-
Removing .php from the URL6m 37s
-
Using RewriteBase2m 25s
-
-
3. Advanced Techniques
-
Conclusion
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Setting up the database for the example site