Find Jobs
Hire Freelancers

Import Email into mySql from PHP/Pearl

$30-5000 USD

Completed
Posted almost 16 years ago

$30-5000 USD

Paid on delivery
I am looking for a php/pearl based script that will login to a specified email address and download all messages and insert them into a mySql database. All the information from the emails will need to be stored in the database to be referenced at a later point. Listed below are the main functions. 1. It will connect to multiple email address's at different times and need to log them (example: sales@[login to view URL], billing@[login to view URL]) 2. It will need to strip out all inline images/files and store them on the server referencing them as attachments 3. When a email is found, it should FWD the email (without changing any items where inline text etc should still work) to a specified email address 4. After the email has been FWD and imported into the database, it should remove the email from the server so it does not reimport again 5. Script will be running as a CRON. The server is currently running PHP Version 4.4.4 and i have full access to the server. If detailed specs are given, I can install anything on the server. I currently do not have a database layout for how the mail should be stored but below is my thoughts which I am open to changes to imporve the structure. Messages Message_ID Message_ParentMessageID Message_Subject Message_BodyOriginal Message_BodyHTML Message_BodyText Message_DateTime Message_From Message_To Message_Folder enum('Inbox','Outbox') Message_Read enum('Yes', 'No') Message_Status enum('New', 'Completed', 'Deleting') Message_Attachment MessageAttachment_ID MessageAttachment_MessageID MessageAttachment_FileName MessageAttachment_FileNameSaved MessageAttachment_FileSize
Project ID: 3961021

About the project

7 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (5 reviews)
2.2
2.2
7 freelancers are bidding on average $311 USD for this job
User Avatar
See private message.
$569.50 USD in 14 days
4.9 (358 reviews)
7.7
7.7
User Avatar
See private message.
$76.50 USD in 14 days
5.0 (43 reviews)
5.6
5.6
User Avatar
See private message.
$212.50 USD in 14 days
4.1 (27 reviews)
4.6
4.6
User Avatar
See private message.
$552.50 USD in 14 days
4.9 (12 reviews)
3.4
3.4
User Avatar
See private message.
$212.50 USD in 14 days
4.9 (17 reviews)
3.2
3.2
User Avatar
See private message.
$510 USD in 14 days
5.0 (7 reviews)
3.2
3.2

About the client

Flag of UNITED STATES
Oklahoma City, United States
5.0
11
Payment method verified
Member since Sep 2, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.