CHAPTER 36Indexes and Searching

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.

Database Indexing

An

Get Beginning PHP and MySQL: From Novice to Professional, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial