Forums / Locator / Integrating with zip code datebase... -

:: Forums :: Discussions :: Locator		<< Previous thread \| Next thread >>
Integrating with zip code datebase...


Moderators: nlstart	This thread is now closed

Author Post

Beamin1

Registered Member #2034

Joined:
Location: 27565
Posts: 1

Hiyas... not sure how I never found this(your site) before with all the years I've used E107 but I'm here now... I'm trying to come up with a solution to automatically locate a user based on their zip code.. I already have a really nice database of zip codes I'd be willing to share with anyone that wants to try to help... What I have is in the following format...




INSERT INTO `ZIPCodes` VALUES ('00501','U','Holtsville','D','Suffolk','36103','New York','NY','36','5380','631','Eastern',-5,'Y',40.813078,-73.046388);

INSERT INTO `ZIPCodes` VALUES ('00544','U','Holtsville','D','Suffolk','36103','New York','NY','36','5380','631','Eastern',-5,'Y',40.813223,-73.049288);

INSERT INTO `ZIPCodes` VALUES ('00601','S','Adjuntas','D','Adjuntas','72001','Puerto Rico','PR','72','0000','787','Atlantic',-4,'N',18.16595,-66.723627);

As you can see, it has the locations GPS coords already added... so what I'm trying to figure out if I can modify this a little to fit in with locater.... so that all US zip codes are automatically available, all the user has to do is enter his\her zip code which can be added to the registration page....

Now, the data I have is ONLY in the previous format... I don't have an active database with it on the dump file so I'm not 100% on what each item is but that shouldn't be too difficult to figure out... I have downloaded locator, and I've bought a copy of php\mysql for dummies and am going to jump in with both feet... any suggestions would be greatly appreciated.


Jump: Back to top

Home Contact Signup Login