PHP-IMAP-import script
I want a secure, robust script that imports mails from a remote IMAP-server into a MySQL-database using PHP7-cli. The purpose is to have an archive of all mail in a local MySQL-database. The database-layout is already ready and defined in the attachment database.txt.
The "basic" setup is pretty easy and can be done in minutes:
[login to view URL]
Then it is simple to run a "insert into... " using mysql, we are talking maybe one hour of work.
This is NOT why I outsource this project. Here is why:
What I need, is far more complex:
- Fetch IMAP emails once per day (cron-job) from a big IMAP-server with thousands of emails using PHP 7.
- Only fetch new emails and duplicaes checking the message-ID and similar details.
- This can for instance be implemented using imap_search or better
- During/before import: Check the mailserver-IP in each mail against a few known blacklist (to avoid importing/archive spam).
- Get emails from all remote IPAM-folders on the remote server (sometimes, inbox, used in connection-line, is caled different things depending on imap-server/folders).
- Mysql-insert is protected using mysqli_escape_string, force UTF-8 db connection + extra protection.
- A test [login to view URL] script that shows both html-mail (with option to load exteral images/links and text-mail (this is to check characters and html/text-mail). Body_basic should be clean no-html email, just with line shift intact.
- Character-encoding must be 100%, so no strange (???*) symbols in subject/message. This can sometimes be a problem, one must find correct way to read/store the message. This is a big part of this project.
Experience:
I want you to have worked on similar projects before or at least big PHP-projects creating advanced stuff. If you use a website or a website/wordpress-site as reference-project, I will automatically ignore you on this project.
Code-style:
Please, no object-orientated code, I like it to be function-based with logical seperated fuctions and using mysqli_query/mysqli-functions and not using prepared/dbi/mysql-variants. It is a personal preferance and a requirement. If you code similar to the php-imap fetch routine, it is fine. But you must do more error-checking before doing any inserts.
Durability:
Since there can be some struggeling with timeouts and network-outages and this should work against different IMAP-servers, I need a failproof and extremly well tested solution. It should work against Gmail, Exchange IMAP, Kerio IMAP and preferable other mailservers that supports IMAP.
If there are a lot of mails or it slows down, it should run in batches. Every failture should be logged.
The database should be as clean as possible: No strange characters and international characters should show up like them are supposed to.
On the positive side: You do not need to do subject-threading/nesting.
TESTING - You should do extensive testing before final delivery. If the program has bugs/issues - I can't use it.
Database-layout - each mail has a pointer to folder in mail_folder_id
Any experience with encrypting database/tables for extra security or suggestions are welcome.
IF YOU HAVE NOT DONE ANY IMAP-PHP HANDLING BEFORE - PLEASE, DO NOT BID. It can sometimes be more struggeling than you imagine even if you follow the "manual".
Hello,
I'm a professional programmer for web programming with php language to build the system website,
Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS
I'm always top in Vietnam freelancer
https://www.freelancer.com/freelancers/Vietnam/all/
https://www.freelancer.com/u/scriptphp87.html
I'm expert development with full stack developer, PHP
Would you like discuss more with me?
do you want to make new site or customize old site?
I'm understand clearly your requirement and i'm interested your project
I'm ready to do it now
Nice to meet you
Should you require further assistance, feel free to contact me.
Thank you
Hello,
I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further on personal chat.
Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end.
Following are my Expertise Area:
1)PHP with CodeIgniter and Laravel Framework.
2)Node JS
3)Angular JS
4)Mobile App Development
Thanks.
Hello,
Its a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work upon customization part, if we can proceed towards more discussion. I have gone through your project description and confident to accomplish your project.
I am an individual developer and you will be working directly with me if we proceed work on this project.
My key skills are -
1)Ruby
2)Ruby On Rail
3)Angular JS
4)Node JS
5)PHP with Codeigniter and Laravel Framework.
Let's initiate our chat so we can proceed towards conclusion of this project scope and give it a start as soon as possible.
Thank & Regards
Prashant Shinde
Thank you so much for this great opportunity.
I have 10+ years of experience in this field and can provide you my past work sample.
I am an expert in WordPress, Magento, Joomla, PSD to HTML conversion, LOGO Desiging, SEO Services.
I can provide you the desired work with great turn around time.
I provide you 1 year support at free of cost.
I hope you'd give me this opportunity.
Thanks
Let's start Expert PHP Developer here, With over 8 years of experience in web development & design i can guarantee you a fast and clean work using the latest web technologies. Please feel free to contact me to talk more details about your project. Thank You!
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
Here is the reason. Why you should pick me?
a) I am a very expert and have the same kind of experience of 5 years.
b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers
c) And most important part is my policy:
"I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me”
Please sir, leave a reply ASAP, as I am waiting for your kind reply
I'd be happy to help you complete your PHP-IMAP cataloging script. I can code to your specifications (functions/procedural), ensure all character sets/encoding is accurately displayed (I understand why you find this troublesome), and I can build a very detailed logging system to go with it. I have 15 years of experience building web-based apps and websites from the ground up, I've even built something very similar to this for my own uses when I was younger. Please feel free to reach out if you have any questions regarding my skill set, or questions pertaining to your project directly. Take care!
I have read your project description, I need some more clarification.
We are a group of developer, so we are available almost all time.
We are experienced in PHP, jQuery, angular and HTML 5.
Our main specialization in code igniter.
We also have expertise in CMS like wordpress, Opencart.
Message me for more details.
Thanks...