Now that we have our store locations in a usable format, we need to create the table on our website’s database and import the data for the locations.
Log into the phpMyAdmin account for your website. Create a new table – for this example, we will call the table Sheet1.
Add the columns to the table that you want to use in your store locator map, i.e.: store name, address, phone number, website address, longitude, and latitude. Make sure that you add columns for longitude and latitude – use float for the type and (10,6) for the length. These values will let the longitude and latitude fields store 6 digits after the decimal, plus up to 4 digits before the decimal.
Here is a screenshot of an example table (from http://code.google.com/apis/maps/articles/phpsqlsearch.html):
If you prefer to create the table by writing an SQL commands, use something like this:
CREATE TABLE `Sheet1` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 60 ) NOT NULL , `address` VARCHAR( 80 ) NOT NULL , `phone` VARCHAR( 80 ) NOT NULL , `website` VARCHAR( 80 ) NOT NULL , `lat` FLOAT( 10, 6 ) NOT NULL , `lng` FLOAT( 10, 6 ) NOT NULL ) ENGINE = MYISAM ;
Once you have the table and the columns you want created, it is time to import your locations. Import the csv or xls file that we created in our last post. Now all of your store locations should be stored in your site’s database.
The next step will be creating a PHP page which will be used to connect the store locator on our website to the database of locations that we just created.