Re: e-mail to mysql database?

YOu need to contact your host first. What you need is for the server to detect emails coming into a certain address, or with a certain subject line, and pass them over to a free-standing (ie not a browser-run) PHP script. The trick will NOT be the parsing of the text and inserting it into the DB, the trick be getting the email piped into the PHP script -- and this is very dependent on which server/mail/OS they're running. Justin French on 12/08/02 11:36 PM, Frank Schellenberg (news.php.net@scid.nl) wrote: > In Short: What I need is a php script that reads an email file and split its > data to a mysql file. > A bit longer if you are still interested.... > > For the following project: > http://www.crossing-africa.com, a journey I am going to make on > a bike. > What are the plans: > > I am taking a satilite phone and SMS my possition with GPS coordinates like: > N50.34.234 E006.45.34 on 23-feb-2003 > I already have a script that translates that sms to an e-mail that looks the > same. > Then what: > This e-mail needs to be split up like this: > N50.34.234 > E006.45.34 > 23-feb-2003 > and then be insterted into a mysql database. > The result then is that my exact location is know everyday and will be > plotted on the web. > > The website runs on a cobalt server > > As my php knowledge is very limited and I searched the web for a script to > do so I havent found it, could any of you help, as it must be out there! > Thanks for any helpfull contribution. > > Frank Schellenberg > >