We need a PHP script that will archive (csv file) and delete records from a MySQL database using mysqldump.exe. The PHP page should accept a date value and archive/delete everything up to that date. Some of the tables do not require archiving.. only delete is necessary. These will run on a Windows server running XAMPP.
Our design idea is to have two sections with a single drop down that contains the table names to process as well as a date field to fill out and a submit button that will initiate the process.
Section one will contain the table names where only delete is necessary.
Section two will contain the table names where archive AND delete is required.
The user would select each table they wish to process, provide the date to delete records for, and process each table that way.
I have attached a screenshot to illustrate this better.
For reference, here are the tables that would be required in this script. (D = DELETE ONLY, A/D = ARCHIVE & DELETE) - All tables have date fields to use as a reference for processing:
label_requests - D
label_requests_zpl - D
pick_timecard - D
shipment_details - A/D
shipment_headers - A/D
so_salesorderhistorydetail - A/D
so_salesorderhistoryheader - A/D
pick_history - A/D
pick_history_headers - A/D
Hi, I'm an experienced PHP developer. I'm willing to do this project for you for 120 bucks. I'll use PDO library to interact with the MySQL database instead of relying on [login to view URL] utility. I'll create a layout for Daha Fazla
Bu iş için 35 freelancer ortalamada $139 teklif veriyor
Hi, Php mysql expert here with 8 years of experience in development. Gone through the details of the project and can create a script which will work exactly the same as described by you. Lets do it thanks
I read your project description very carefully. I can create required PHP Script as per your requirements. I am available and I can start immediately. Thank You, Amanat
Greetings sir, I have read your project details and i will develop the script to archive and delete the mySQL data. Sir, i can deliver this project sooner than you expect and will be over your satisfaction level. Daha Fazla
Hello sir, i checked attachment, sir i delete records from MySQL database use in [login to view URL] i can understood PHP script that will archive csv file archive/delete everything up to that date sir i read all i only Daha Fazla
Hello, I can do your project in a day and I can start work right now. As I worked many php & query projects, this is really piece of cake for me So I hope you can hire me and let’s make a deal. Thanks.
Hello, I am php mysql expert, i can help you to make the php script based on your requirement, i will complete this project within 48 hours timeline Kindly ping me for further disucssion Thanks
Hello I'm very interested in your project and will provide you 100% quality work. I have enough experience in php, mysql. I want to discuss further via chat. I'm ready to start work immediately. Thanks
Hello, How are you? I checked your job description carefully. *****I am a PHP,MySQL expert*****. I have 7+ years rich experience in web development using these skills. My main skill is to create user-friendly UI and fa Daha Fazla