Abstract
Chapter 28 introduced the utility of the PRIMARY and UNIQUE keys, defining the role of each and showing you how to recognize and incorporate them into your table structures. However, indexing plays such an important role in database development that it’s worth devoting some additional time to this feature. In this chapter, the following topics are covered:
-
Database indexing: The first half of this chapter introduces general database indexing terminology and concepts, and discusses primary, unique, normal, and full-text MySQL indexes.
-
Forms-based searches: The second half of this chapter shows you how to create PHP-enabled search interfaces for querying your newly indexed MySQL tables.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 W. Jason Gilmore
About this chapter
Cite this chapter
(2008). Indexes and Searching. In: Beginning PHP and MySQL. Apress. https://doi.org/10.1007/978-1-4302-0299-8_36
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0299-8_36
Publisher Name: Apress
Print ISBN: 978-1-59059-862-7
Online ISBN: 978-1-4302-0299-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books