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.