Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
|
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 9th, 2004, 06:30 AM
Authorized User
 
Join Date: Oct 2004
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to SiliconFuRy
Default Data entry from email

Morning childs!

I've got an upcoming project, and one of the things I'm wanting to do is to input data into a database via email.

i.e.: Send an email to some address, somehow parse the email for certain commands and such, and input certain data into a database.

I've no idea how to do this at all, any pointers anyone?

Many shoes,

Jamez/SiliconFuRy
__________________
Many shoes,

Jamez/SiliconFuRy
 
Old December 9th, 2004, 02:18 PM
Authorized User
 
Join Date: Dec 2004
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to peg110
Default

I suppose the biggest question would be What was the mail server?

Much of what you are suggesting would be very dependant on HOW you are getting this mail. If you do not have access to the Mail Server directly and would be using a program such as Outlook to retrieve and then some other script to further process it... then you could have some issues.

If, on the other hand, you are using something like qmail or sendmail or something using the maildir or mbox format, the data is typically stored in a plain text file on the server (until retrieved that is) and from there you could create a scheduled task to check for what you are looking for (in the specific account), and then procees what it finds appropriately.



Paul Gardner
------------------
PHP-LIVE help
Via Web @ http://www.mnetweb.co.uk/irc
Via IRC Client pgardner.net:6667
room #PHP
 
Old December 10th, 2004, 05:01 AM
Authorized User
 
Join Date: Oct 2004
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to SiliconFuRy
Default

Well, the problem is the mail server is an exchange server (I'm in a corporate environment, I've gotta just deal with it :/).

I've had a couple of ideas, like having a script just look at the mailbox every x seconds, using an infinite loop and the sleep (or similiar) command.

Many shoes,

Jamez/SiliconFuRy
 
Old December 10th, 2004, 06:05 AM
Authorized User
 
Join Date: Oct 2004
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to SiliconFuRy
Default

Question is, is it mathematically :D possible to access an exchange server mailbox through PHP?

Also thinking about just using a thirdparty cheap POP providor, and have exchange forward emails to that mailbox. Would simplify things somewhat.

Many shoes,

Jamez/SiliconFuRy
 
Old December 17th, 2004, 09:40 AM
Authorized User
 
Join Date: Dec 2004
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to peg110
Default

Quote:
quote:Originally posted by SiliconFuRy
 Well, the problem is the mail server is an exchange server (I'm in a corporate environment, I've gotta just deal with it :/).

I've had a couple of ideas, like having a script just look at the mailbox every x seconds, using an infinite loop and the sleep (or similiar) command.

Many shoes,

Jamez/SiliconFuRy
Well I am not 100% sure, but I don't think Exchange stores email in a plain text fromat which would mean you would likely have to do some other (possibly intense) coding to gain access to the mail box. I wanted to do something similar using the Outlook Client (even though it was also a POP account) and I would have needed to download (and pay for) all these other utilities.

Also tried to use the Rules Wizard in Outlook to achieve the same type of thing..... Again, I needed another utility to launch an external script.

Finally, I would be very weary of using an Infinite loop. I have done this in the past for other projects..... Even in the SLEEP mode, you still use up CPU Cycles and you may potentially take a huge performance hit. If anything, you would be better to use the scheduler (in windows) or a Cron Job (in nix).

Good luck

Paul Gardner
------------------
PHP-LIVE help
Via Web @ http://www.mnetweb.co.uk/irc
Via IRC Client pgardner.net:6667
room #PHP





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help required for data entry format Creatoronline SQL Server 2000 1 May 27th, 2008 01:58 PM
data entry pre-fix value mateenmohd Access 5 February 17th, 2008 07:52 AM
Automating Data Entry - subform sbraudrick Access VBA 4 March 22nd, 2007 06:22 AM
Data Entry from Repeater m_t_clayton ASP.NET 2.0 Professional 0 March 20th, 2006 06:13 PM
error in data entry vickyj SQL Server 2000 6 September 13th, 2004 10:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.