MySQL Cookbook, Second Edition > Processing Web Input with MySQL > Generating Previous-Page and Next-Page Links

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

MySQL Cookbook, Second Edition

Search

Preface

Ch. 1. Using the mysql Client Program

Ch. 2. Writing MySQL-Based Programs

Ch. 3. Selecting Data from Tables

Ch. 4. Table Management

Ch. 5. Working with Strings

Ch. 6. Working with Dates and Times

Ch. 7. Sorting Query Results

Ch. 8. Generating Summaries

Ch. 9. Obtaining and Using Metadata

Ch. 10. Importing and Exporting Data

Ch. 11. Generating and Using Sequences

Ch. 12. Using Multiple Tables

Ch. 13. Statistical Techniques

Ch. 14. Handling Duplicates

Ch. 15. Performing Transactions

Ch. 16. Using Stored Routines, Triggers, and Events

Ch. 17. Introduction to MySQL on the Web

Ch. 18. Incorporating Query Results into Web Pages

Ch. 19. Processing Web Input with MySQL

Introduction

Writing Scripts That Generate Web Forms

Creating Single-Pick Form Elements from Database Content

Creating Multiple-Pick Form Elements from Database Content

Loading a Database Record into a Form

Collecting Web Input

Validating Web Input

Storing Web Input in a Database

Processing File Uploads

Performing Searches and Presenting the Results

Generating Previous-Page and Next-Page Links

Generating Click to Sort Table Headings

Web Page Access Counting

Web Page Access Logging

Using MySQL for Apache Logging

Ch. 20. Using MySQL-Based Web Session Management

Appx. A. Obtaining MySQL Software

Appx. B. Executing Programs from the Command Line

Appx. C. JSP and Tomcat Primer

Appx. D. References

Colophon

Index

19.11. Generating Previous-Page and Next-Page Links

19.11.1. Problem

A statement matches so many rows that displaying them all in a single web page produces an unwieldy result.

19.11.2. Solution

Split the statement output across several pages and include links that enable the user to navigate among pages.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial