Devam Ediyor

MySQL / [login to view URL] - Archive and Delete Script

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

Beceriler: PHP, MySQL

Daha fazlasını gör: delete script php project, simple delete script, php mysql photo gallery code delete file, mysqldump data only, mysqldump to file, mysql dump all-databases, mysqldump options, mysqldump single-transaction, mysqldump table, mysqldump restore, mysqldump windows, mysql registration membership pay paypal script, php mysql database insert edit delete, phpbb3 protect forum post delete script, youtube account delete script, delete script mysql add, delete script mysql php, mysql show query results generic script, delete script messenger, php mysql table insert delete script

İşveren Hakkında:
( 124 değerlendirme ) huntley, Canada

Proje NO: #27849271

Seçilen:

kanwalrafique

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

%selectedBids___i_period_sub_7% gün içinde 120%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(43 Değerlendirme)
6.1

Bu iş için 35 freelancer ortalamada $139 teklif veriyor

morff

Hi, my name is Josef, i'm professional developer from Czechia, and i would like to offer you my services. I understand your requirements, and i'm completely confident i can easily deliver this project to your full sati Daha Fazla

$140 USD in 2 gün içinde
(269 Değerlendirme)
7.3
phpraza

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(229 Değerlendirme)
7.2
maxpl

Hi, Hope you are fine. I am an experienced web and mobile app developer. I am working as a developer for last 8+ years. Daha Fazla

$200 USD in 7 gün içinde
(31 Değerlendirme)
6.6
witscomputing

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

$100 USD in 2 gün içinde
(388 Değerlendirme)
6.9
ineedWorkJob

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(139 Değerlendirme)
6.7
BizzCreator

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(107 Değerlendirme)
6.7
Jee1980

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(33 Değerlendirme)
6.1
goodwork20k

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

$120 USD in 7 gün içinde
(42 Değerlendirme)
5.5
vipinjain1213

Hello, I have 10+ years of experience as Website Designer/Developer. I believe I will be suitable for this job and serving you with all my hard work, creativity and skills. I am well versed in Html, CSS, Bootstrap, Co Daha Fazla

$200 USD in 7 gün içinde
(20 Değerlendirme)
5.4
arnoldb

Hello, I hope you are doing well. I am a full stack developer from Poland with 8 years of experience in mobile app and web technologies. I have Daha Fazla

$200 USD in 7 gün içinde
(12 Değerlendirme)
5.5
scriptzguru

Okay sir, I will provide user interface with dropdown for mysql table selection . a Button to initiate archive/delete process of table records as per CSV file and conditions . I have some doubts about CSV . Please le Daha Fazla

$180 USD in 4 gün içinde
(36 Değerlendirme)
5.3
eliaa

Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can hel Daha Fazla

$180 USD in 5 gün içinde
(29 Değerlendirme)
5.0
rukshanlancer

Hi, there. I just read your job description properly and understand what you want. If you want I can start your work right now. I am highly interested to work for you. We have finished many projects like this. If you Daha Fazla

$140 USD in 7 gün içinde
(10 Değerlendirme)
4.8
lesjakondreva

Hi there, Thank you for this wonderful opportunity. I am Lesia. I have reviewed your project requirements very carefully. I am an experienced web developer. Over the last 6 years, I have developed & designed a wide ran Daha Fazla

$250 USD in 3 gün içinde
(9 Değerlendirme)
4.9
vovakovalkov80

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
4.4
strop55golf

Hello Craig, This is Aleksandr, PHP, MySQL expert. I carefully read your job description and it appeals me so much. I can do your database work to delete tables using mysqldump. So you want to execute mysqldump using p Daha Fazla

$100 USD in 7 gün içinde
(10 Değerlendirme)
4.4
naveed254

Good Day use my 10 years of experience My areas of Specialization includes: . Website Designing / Development (ReactJs, PHP, Laravel, WordPress, HTML5, CSS, AngularJs) will send you details about my past project just Daha Fazla

$220 USD in 5 gün içinde
(12 Değerlendirme)
4.0
fischersdelivery

Hello, I have read your task specification carefully and I am very interested in your job. As a senior web developer, I can do your task in a short time successfully. Please feel free to discuss about your task details Daha Fazla

$150 USD in 2 gün içinde
(3 Değerlendirme)
3.6
bobrovpavelwork

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
3.6
sayanthanpera

Dear client, I have lot experience in same kind of task.. I can do.. Please contact me.. Thank you.

$40 USD in 2 gün içinde
(20 Değerlendirme)
3.8