PHP and MySQL User-Driven QueryingPHP and MySQL - User-Driven Querying
User-Driven Querying
User Input
Passing Data with URLs
Passing Data with the HTML <form> Environment
Passing Data with Embedded Links
Security and User Data
How PHP Initializes Variables
Querying with User Input
Combined Scripts
Adding Links to Results
One-Component Querying
Case Study: Previous and Next Browsing
Step 1: Using the Generic browse Function
Step 2: Implementing the Generic browse Function
Step 3: Adding Page Numbers
What's Missing from the Previous and Next Browser
Case Study: Producing a select List
Implementing the selectDistinct Function
We explain user-driven querying by introducing how to:
- Pass data from a web browser to a web server.
- Access user data in scripts.
- Secure interactive query systems.
- Query databases with user data.
- Produce one script that contains an HTML<form> and the code that outputs the queryresults. We call this a combined script.
- Develop results pages with previous page and next page links.
- Use five-step querying to produce components for user input.