Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Retrieve data from email into MySQL database using PHP
Old 02-10-2005, 10:07 AM Retrieve data from email into MySQL database using PHP
Junior Talker

Posts: 2
Trades: 0
Hi

I'm quite new to PHP and haven't used it for a few months but want to improve a support call system I created by forwarding emails that come into the support email mailbox (MS Exchange) to my webserver.

I can send emails from this using mail and get the account name of nobody@server.domain I take it I can forward the emails to this address to get the emails on the server.

What I then want to do is take the from details and match it to a record in the users table to pass on the user id, search the subject line for a word relating to an entry in the subject table and send this as the subject and send the subject line and body text of the email as the problem field.

I have never done anything like this in a programming language - I've only ever sent mail from the pages.

Has anyone else done something similar who could help me with this please?

Thanks in advance!
peppy is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 02-10-2005, 11:25 AM
Republikin's Avatar
Defies a Status

Posts: 3,189
Trades: 3
I don't believe it's possible to send an email to a php script.
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
Republikin is offline
Reply With Quote
View Public Profile
 
Old 02-10-2005, 12:11 PM
Average Talker

Posts: 17
Trades: 0
What you want to do is completely possible. You should look at this page. It is actually pretty easy to get email and extract stuff from them.
bizpile is offline
Reply With Quote
View Public Profile Visit bizpile's homepage!
 
Old 02-10-2005, 01:27 PM
Republikin's Avatar
Defies a Status

Posts: 3,189
Trades: 3
Duh, I was thinking of sending that mail directly to the script. Not using my head today.
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
Republikin is offline
Reply With Quote
View Public Profile
 
Old 02-10-2005, 06:58 PM
Airkat's Avatar
Average Talker

Posts: 19
Trades: 0
Sending email to scripts is also kinda possible if you pipe them
Airkat is offline
Reply With Quote
View Public Profile
 
Old 02-11-2005, 12:32 PM
Super Talker

Posts: 121
Trades: 0
great question, i just assumed that it was impossible to do so never looked into it thanks for bringing this up!
vegancoder is offline
Reply With Quote
View Public Profile
 
Old 02-14-2005, 12:25 PM
Junior Talker

Posts: 2
Trades: 0
Thanks for you help!!!
peppy is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Retrieve data from email into MySQL database using PHP
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.31576 seconds with 12 queries