Cancelled

PHP/MYSQL to CSV (Quick turnaround)

We have two tables in MySQL:

TABLE NAME: submission_master

COLUMNS:

----submission_id

----time_stamp

----fb_page_id

----alert_status

TABLE NAME: submission_data

COLUMNS:

----id

----submission_id

----fb_page_id

----element_name

----element_value

Every day, we would like a cronjob to run:

- that checks for new submissions (submission_master)

- that exports the new data (from submission_data, linked by submission_id) as a CSV file

- an email is sent to a user with the link the download the CSV file

This task is needed quickly

Thanks

THE CSV FILE SHOULD LOOK LIKE:

HEADER: submission_id, timestamp, element_NAME, element_name, element_name (etc)
DATA: submission_id, timestamp, element_VALUE, element_value, element_value (etc)
DATA: submission_id, timestamp, element_value, element_value, element_value (etc)

There are multiple submission_data entries, per submission. For example submission_id could have 12 pieces of submission data.

Skills: MySQL, PHP

See more: csv mysql php, download mysql, Exports, csv, csv php, php table csv, quick task, table csv, csv table, file csv php, mysql link, mysql quick, file csv, quick turnaround task, php mysql quick, mysql csv file, php file download, php mysql table, php download file, mysql data tables, csv file mysql php, drookit, download file csv, mysql task, mysql table csv

About the Employer:
( 89 reviews ) London, United Kingdom

Project ID: #1271724

29 freelancers are bidding on average $107 for this job

lightcresent

Got Expertise in doing this sort of stuff, get it done within next 4 hour max... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can start right away.. Thanks

$60 USD in 0 days
(516 Reviews)
9.1
srinichal

Delivery under a day for the bid

$80 USD in 1 day
(119 Reviews)
7.2
AlinGhinoiu

Hello ! I can develop your submissions system. I have read the cronjob algorythm and understand it. Can you please send me more details ? I see the project is urgent so I can finish in 2-3 days. Thank you !

$250 USD in 3 days
(113 Reviews)
7.0
developershut

Hi, i am aftab having lot of experience in php, mysql. special in csv to mysql. i will be glade to replay me.

$150 USD in 2 days
(123 Reviews)
6.8
netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$80 USD in 1 day
(89 Reviews)
6.8
mkinternation

Easy task! Have done it many times. I can get this ready for you in matter or minutes. Do you want the csv file to be attached to the email or just stored on your server?

$60 USD in 1 day
(83 Reviews)
6.2
diegou

I can do this fast, regards

$80 USD in 1 day
(40 Reviews)
6.0
forrestwang

hi sir, i am interested in your project,

$200 USD in 3 days
(19 Reviews)
5.6
westcowboy

hi i'm ready

$80 USD in 0 days
(22 Reviews)
5.1
SOHAILAHMAD786

Its a quick turn around about less then a day work, lets do it

$100 USD in 5 days
(18 Reviews)
4.9
hotranan

i can do this

$100 USD in 1 day
(6 Reviews)
5.0
leandrodardini

Hello, I am PHP senior developer with strong knowledge in mysql usage. I can start working right now. About me, I am from Italy.

$80 USD in 2 days
(9 Reviews)
4.6
shahmit27

Hi, I understand your requirements and interested to do this [url removed, login to view]'s start. thanks

$250 USD in 3 days
(17 Reviews)
4.5
masterratna

3 years of professional experience in data mining and warehousing with dedicated teams. Excited to start project now.

$100 USD in 2 days
(18 Reviews)
4.4
rguknet

Hello, I can do this no problem - I have produced many scripts which do the same thing. I have a query - please see PM. Thanks, Paul

$80 USD in 1 day
(8 Reviews)
4.1
krizalys

PHP/MySQL expert, it would be a pleasure to complete this project for you. Please check private message for details. Thanks.

$60 USD in 1 day
(15 Reviews)
4.2
asif03

I'm ready to start.

$85 USD in 3 days
(20 Reviews)
4.3
nukecoder

Expert in php, mysql to csv as well as cronjob. I am ready to start. Thanks

$120 USD in 1 day
(16 Reviews)
4.1
phobia82

Please4 check PM

$100 USD in 1 day
(17 Reviews)
4.2
teamvalid

Give access to your database and think done! I am saying this because, recently I have gone through this job. Check PMB

$200 USD in 1 day
(1 Review)
3.7