CODEWITHSUNDEEP
php
roi
roi

Reputation: 47

import email data to the DB

I built support system (web) where my helpdesk can open new tickets/issues. I want my clients to be able to send email with the issue text and file attache, to specific email address, and new ticket will be opened in my system. For that I need to know how to scan the folder and how to add the email data to my DB.

what do I need to look for, in the internet, for that? what is the subject? (I'm using PHP)

Upvotes: 0

Views: 774

Answers (3)

Jarrett Barnett
Jarrett Barnett

Reputation: 803

As the other's have commented, it's likely a larger task than you're ready to handle. But it doesn't hurt to try.

If I was tasked with the job, I'd take advantage of Gmail (for it's spam reducing features and large storage) to accept incoming email. From there, you simply need to setup a script that connects to your email account and processes the email for storage in your database.

Normally I recommend a solid library for making the job easier and cleaner, but I have a suspicion that you may not be familiar with OOP. If you at least know how to utilize classes, then check out Github: https://github.com/search?l=PHP&q=imap&ref=searchresults&type=Repositories

Otherwise, if you're new and don't mind writing something "messy" then the following should at least point you in a good direction:

Connecting & retrieving emails for IMAP:

Fetching/processing attachments:

(note that attachments are part of the email body)

Storing attachments (in the filesystem):

There's plenty of Googling left for you to do. So go forth and make a lot of mistakes. Read the manual. Kick yourself for not having read it sooner, then go make more mistakes. Isn't that how most of us learn?

Upvotes: 2

Fern Nguyen
Fern Nguyen

Reputation: 11

You can use this method, using the cURL to fetch the emails from Gmail server through feed atom. XML response will return and we can convert it to HTML.

http://www.code4share.net/items/get-unread-email-in-gmail-by-php/XRGXVVh.html

Upvotes: 1

maximx1
maximx1

Reputation: 89

The first thing that comes to mind is to pop the most recent emails if you have pop3 set up or use imap functions. I did something similar to this using c# using openpop.net. So that could be a starting point.

Upvotes: 1

Related Questions