Book Image

Sphinx Search Beginner's Guide

By : Abbas Ali
Book Image

Sphinx Search Beginner's Guide

By: Abbas Ali

Overview of this book

Table of Contents (15 chapters)
Sphinx Search
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface

Time for action - populating the database


Import the following SQL to populate amenities and cities tables:

--
-- Dumping data for table `amenities`
--
INSERT INTO `amenities` (`id`, `name`) VALUES
(1, 'Parking'),
(2, 'Swimming Pool'),
(3, 'Garden'),
(4, 'Elevator'),
(5, 'Club House'),
(6, 'Watchman');
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` (`id`, `name`) VALUES
(1, 'Nagpur'),
(2, 'Mumbai'),
(3, 'New Delhi'),
(4, 'London'),
(5, 'New York'),
(6, 'Hyderabad');

What just happened?

We populated the amenities and cities tables with some data. We did not populate the properties table, as we will be creating a simple form to add a property in the next exercise.

Basic setup

We will use the exact same setup as we did in Chapter 5, Feed Search, and you can use the same directory structure and common files, such as init.php.