Sedang Disiapkan

PHP Script for Registrations

This is a PHP script that needs to run nightly on the server via a CHRON job. It should look up boot camp registrations in a MySQL database, pulling only those with a specific field marked with a 1, indicating recurring membership.

It should also look up (same query, different query?) the soonest upcoming 4-week boot camp from another table (camp dates), and compare the start date of that camp (which is in the camp dates table) to the current date.

If the date the script is run is exactly 7 days before the start of the new camp, it should insert a new registration for that camp and client (mirroring the original) into the registrations table.

It should also then increment by 1 a field storing the amount of camps that registration has paid for.

Finally, it should take the amount of money in the paid column of the recurring registration and divide it by the number of camps the registration has paid for, and put this amount into the paid column of the new registration being inserted.

Kemahiran: MySQL, PHP, Memasang Skrip

Lihat lebih lanjut: money on the table, it boot camps, install php script, boot camp, php script server, php mysql database query, registration insert, script registration, date days php, script mysql query php, recurring membership, paid membership script php mysql, php chron job, php script database query, install php script server, script php mysql client server, mysql php insert script, client server php, php script mysql database, divide script, php registration script mysql, mysql membership database, script run php, paid membership script php, php paid membership script

Tentang Majikan:
( 7 ulasan ) Fresno, United States

ID Projek: #1593424

Dianugerahkan kepada:

ansi2

Proposal details will follow. Thanks, 2ansi

$50 USD dalam sehari
(87 Ulasan)
6.3

4 pekerja bebas membida secara purata $83 untuk pekerjaan ini

cygital

It will be done in timely manner.

$50 USD dalam 2 hari
(35 Ulasan)
6.0
persistent

Hello, im highly interested in your project and i can do this . Let's start now. Thanks.

$80 USD dalam sehari
(31 Ulasan)
5.0
Bistechsupport

Hi, This is Jeni from bistech support. We would like to inform you that we could able to develop this project. Please find the attached document for your reference. our ball park quote is 30 USD. Plea Lagi

$150 USD dalam 7 hari
(17 Ulasan)
4.3