PHP-IMAP import script

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".