Re: [nyphp-talk] Zip code radius

2009-05-22 Thread CED
Edward Potter wrote: Yep, Geocode a list of addresses, export lat, lng file. Suck into the iPhone, parse the file, build a store locator that knows where I am, link those pins to a mysql db, spit out some more xml soup. Fun stuff. Mapkit 3.0 is wild. ;-) Search google + php + map + geocode

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Edward Potter
Yep, Geocode a list of addresses, export lat, lng file. Suck into the iPhone, parse the file, build a store locator that knows where I am, link those pins to a mysql db, spit out some more xml soup. Fun stuff. Mapkit 3.0 is wild. ;-) Search google + php + map + geocode On May 22, 2009, at

Re: [nyphp-talk] PHP 5.3 add_x_header Broken

2009-05-22 Thread Hans Zaunere
> > However, when the X-PHP-Originating-Script header is added, it's prefixed > > with a \r\n. This thus breaks some email clients, especially when sending > > from a Unix host where all the other headers are separated by only a \n. > > Well, last I looked, the mail format RFC says the headers ar

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Aaron Fischer
That sounds good, thanks for the link Paul. -Aaron On May 22, 2009, at 4:21 PM, Paul Guba wrote: Here is what I used: http://www.micahcarrick.com/04-19-2005/php-zip-code-range-and-distance-calculation.html Paul Guba p...@gubavision.com On May 22, 2009, at 4:04 PM, Aaron Fischer wrote: Gre

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Paul Guba
Here is what I used: http://www.micahcarrick.com/04-19-2005/php-zip-code-range-and-distance-calculation.html Paul Guba p...@gubavision.com On May 22, 2009, at 4:04 PM, Aaron Fischer wrote: Great stuff, thanks John! I got my Google API Key and am reading up on geocoding now Never tried som

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Paul Guba
There is actually a class available google it in includes basic script and database with zipcodes and long and lat points. I think it even factors in for the curvature of the earth. Used it a way back. Paul Guba p...@gubavision.com On May 22, 2009, at 4:04 PM, Aaron Fischer wrote: Gre

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Aaron Fischer
Great stuff, thanks John! I got my Google API Key and am reading up on geocoding now Never tried something like this before so it looks like I've got some learning to do. -Aaron On May 22, 2009, at 2:36 PM, John Campbell wrote: I used to do a bit of GIS stuff. Here is what you need to

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Konstantin Rozinov
Paul, I would be interested in looking at the code of the class too, just to see how something like that works. Thanks Konstantin On Fri, May 22, 2009 at 2:29 PM, Paul McGrane wrote: > Aaron: > > I have one...but need to dig it up...ping me off list if you are interested. > > BTW...does your d

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread John Campbell
I used to do a bit of GIS stuff. Here is what you need to do. 1) Import a list of zip codes & lat/lng centroids into your database. The data is here: http://www.census.gov/tiger/tms/gazetteer/zips.txt 2) Geocode all of your contacts, and store the lat/lng coordinates with the contacts. Google ha

Re: [nyphp-talk] Zip code radius

2009-05-22 Thread Paul McGrane
Aaron: I have one...but need to dig it up...ping me off list if you are interested. BTW...does your db table include geo-codes for the addresses...this is key for both parts of what you would like to do. Paul serv...@lynxtdc.com lynx...@gmail.com On Fri, May 22, 2009 at 2:09 PM, Aaron Fischer

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Néstor
OK, I do not know what to do next. This are errors from the apache log: --- PHP Warning: PHP Startup: Unable to load dynamic library 'D:\\php5\\ext\\php_mysql.dll' - The specified procedure could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load

[nyphp-talk] Zip code radius

2009-05-22 Thread Aaron Fischer
I'd like to build a feature that will allow someone to enter a zip and a radius and have the page display all the contacts that are within the specified radius of that location. (I have a db table to query that has contacts and their address information, including zips.) Has anyone found a

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Néstor
Yes to all your questions. I think the difference might be that this is the first time that I did a PHP automatic install instead of a manual. I am removing PHP and I will do a manual install, to see if it makes a difference. I will find soon is the automatic PHP install is the problem. Thanks,

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
Nestor: > The Apache error log says: > PHP Warning: PHP Startup: Unable to load dynamic library > 'D:/php5/ext\\php_mysql.dll' - The specified procedure could not be > found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load > dynamic library 'D:/php5/ext\\php_mysqli.dll' - The s

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Néstor
I have all of the extensions that I want uncommented. I have other set ups running php + mysql, but this is the first time that I tried running it in a W2K3 and using the same mysql for IIS and Apache and different php's. PHP can see other extensions but it is not able to see mysql. That is what

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
Sire: On Fri, May 22, 2009 at 07:31:05AM -0700, Nstor wrote: > When I access phpinfo.php via IIS it shows access to mysql but when I access > it using my apache set up it does not show access to myslq So uncomment the mysql extension (eg "extension=php_mysqli.dll") line in the php.ini file speci

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Néstor
When I access phpinfo.php via IIS it shows access to mysql but when I access it using my apache set up it does not show access to myslq :-) On Fri, May 22, 2009 at 6:47 AM, Daniel Convissor < dani...@analysisandsolutions.com> wrote: > On Thu, May 21, 2009 at 05:00:53PM -0700, Nstor wrote: > > >

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
On Thu, May 21, 2009 at 05:00:53PM -0700, Nstor wrote: > > I want to be able to use Apache with port with the same mysql so > I tried to set up a W2K3 + apache2.2 + php5.29 + mysql 5.5.1.a and > everything > works except that I am not able to access mysql. Is there something that I > might >