kipper

I would be happy to hear from others on this. I see this is dated from 2008. Some of the code doesn't work and it requires one to pay for one of the services. So, if I have a database with a table of all the zip codes. I have store location with the zip codes. What is the best way to have a form, where an end user enters their zip code and it pulls up a 30 mile radius, of stores in that 30 mile radius.

Hi there, this is a request for code snippet. I was looking to find the best way to create a zip code locator? As we have all seen as a store locator. For example, like http://www.bestbuy.com/site/olspage.jsp?id=cat12090&type=page. I don't need to search by the address, just the zip code. I have a number of stores, where I have the latitude and longitude. In my application, when I add a store, it inputs the lat and long in the database. Now, my challenge, is for a user to enters their zip code, it would show all the stores in a 50 mile radius. Or whatever radius I decide on. This is where I ask your feedback. I can buy a database with all the zip codes in the US. ( just USA), and do some sort of calculation based on the lat and long. OR Use an API. Perhaps Google. I would lean towards this one. I don't need the map to show up. I would start with a very basic list of the stores. Just like the Best Buy example, I only want to return the list of stores. Which way???? Thanks Kip

Thank you everyone. So, the answer is no, there is not a way. As I mentioned, I know I put an image or a link, but that all requires a user to click on something. I was hoping to call a header. At least I know the answer is no. Thanks

HI everyone, I am sure this has got to be common question. Is there a way to tell if an email recipient opened an email I sent? Here is the scenario. In an application where the application sends email campaigns. So, if I send out an email to 100 people, I want to keep track of how many of them actually opened the email. I do not want to rely on a reader clicking a link, or downloading image to determine if the "read" the email, as one can still read an email without doing those things. Is there a more reliable way? Thanks Kipper

Yes, it is not the clarification that is an issue that is the problem, but when this same dude Pikachu2000, goes even over to my second post with a much more pin pointed question, self admits he doesn't know, but looks at this. Just don't answer if you don't know I guess is my motto. I found the answer in another forum with the exact same text. http://www.weberdev.com/get_example-4015.html or http://developers.evrsoft.com/forum/archive/index.php/t-1180.html It was exhausting.

"Set up a POP3 mailbox, use PHP to read the email contents". This solves the issue with connecting to databases across servers.

I wish I could get the global moderators. Each time I have posted a forum questions, it is frustrating as to some of the other forum members, that they want to answer some other question. Take the easy way out. I find it annoying. It would be nice that if the moderators can take a look and keep these people at bay. It may be picky, but the few times I have posted a question, if they don't know, then don't post. I have not gotten the answer and found it myself. Took a week, but I always figured it out. Next, I find that the other php forum are much more sophisticated and helpful. Not sure what you can do about this, but perhaps more involvement by the moderators. btw, I have about 5 other programming friends that all say the same thing. Thanks for listening.

How does a web server, with a database connect to the emails it receives? How does the web server get the contents of the emails it receives so I can parse it? Thanks

How does a web server, with a database, connect to the emails it receives? I appreciate your concern for how I might want to accomplish the task. But, for my reasons ( mostly security and access), the questions still remains the same. Does anyone know how these parsing programs work. I know how to have a form send the submitted values to an email, the email is sent to the designated server with the central database, the part I am stuck on, is when the emails arrives, how does the web server get the contents of the emails so they can parse. I can parse, I can insert into a database, I can mail, etc. It is this part where I was wondering how that is done. So, to keep it simple, How does a web server, with a database, connect to the emails it receives, so the code can insert the parsed email contents into the data base? How does a web server, with a database connect to the emails it receives? How does the web server get the contents of the emails it receives so I can parse it?

It will go into one database. It is the route. It will cross servers. And, it is the way the application that has the central database is set up. There are many applications set up this way. It's a way to provide to the customer, the ones with the websites, you just provide them with an email address. It is simple for them, the customer.

I think you are not understanding what I mean. I know how to send mail, I use mail or phpmailer. I know how to insert into databases. My hosts do allow sending emails. I send one to the person who completes the form. I am asking about an email parsing program. Not who once I have it to insert it into a database. I know to put a variable to (hidden field in the form) to show the origination. The question is not a basic one. I am an intermediate to advanced user. This is an accepted practice where I know there are other method. For our reason, we want to do an email parser. If you don't know, that is fine.

No, I know how to to that. Here is the scenario. We have multiple websites that use a slightly different form, but they all collect firstname, lastname, email address and zip code. as in http://nobaltimorebeveragetax.com/. The goal, is to get the data from all these form, into one central database. Rather than each website putting the data in their own database on that server, it needs to go in one central database on a designated server. So, I have heard of email parsing. Rather than have a form, have the submit, and post to that database. The post values go into an email address. Called a paring email. So the values of $fname, $lanme, $email and $zip are sent to an email NOT into a database. Then, a little program receives these emails and parses the information from the content of the email and inserts to that central database. This practice makes it easy, because all you have to so on each form, rather than a POST and a Insert to a database, it sends an email with the vaules. I know this is done alot, because some applications provide a "Parsing email" to it's customers. Make sense?

I am asking if anyone knows of any tutorials to take the contents of a simple form, hit submit, then the values go to an email, the email contents are then parsed and go into the correlating mysql table. For example, if I have a form like this http://nobaltimorebeveragetax.com/ It is only the first name, lastname, email address and zip code. I know how to do a POST or a GET, to put directly into a database table. The reason is because there are multiple sites with this type of form and would like them to go to one central database. I do not wish to do iframe since we would still have to style (css) each form. I have heard of "paring emails". Any tutorial, resources or suggestions would be most appreciated. Thanks Kip

Thank you guys. But, I my problem is not the type of csv. Tab delimited is always preferred and the outcome is to generate the insert statements. As in my near last line of the code is: <code> echo " insert into wp_joinus (fname, lname) values ('{$cells[1]}' , '{$cells[2]}') "; </code> Since this has got to be a very common procedure, I would think there is some snippet to handle this. I use trim and a snippet I call msqlprep which takes care of magic quotes on or off depending on the version of php and so on. So, I was looking for some snippet that generates insert sql statements and does a really good job of cleaning or validating the values. (don't have to worry about the mysql connection and like that, just echo out the inserts. In response to dabaR, I always go php.net first. Which section do you mean? Your statement: " I don't see which snippet that generates the insert statements. Please define. Thanks for all your help guys. But, if you don't know, then it looks I have the really good snippet. I would be happy to share. Kip

or at least just echo out the query ( insert statement). I wrote some code to take a very simple spreadsheet with name and address and import into a database table. Simple I thought, right? Well does anyone have some snippet of code that addresses apostrophes in names, extra commas and so on in the data? To keep it simple, I will just use first and last name. tab delimited. Does anyone have any code that is more sophsticated? Thanks Kip <code> $file = "philly.csv"; if($handle = fopen($file, 'r')) { while(!feof($handle)) { $line=fgets($handle); $cells = explode("\t", $line); echo " insert into wp_joinus (fname, lname) values ('{$cells[1]}' , '{$cells[2]}') "; } fclose($handle); } </code>