In Progress

MYSQL- PHP TO EXCEL FILE

for current PHP version 5.3 or above

1) I need to pass some JSON object to generate an excel file

2) I need to generate the excel file from SQL query MYSQL

IN BOTH CASES i will set the column names Hard coded

$column_names=array("my_col1","my_col2",...)

in case 1:

I send the data in a form with JQUERY

datos=[url removed, login to view](datos);

$('#excelData').val(datos);

$('#dataType').val('json');

$('#formaExcel').submit();

on the processing page

$data=json_decode($data, true);

i can prevent a column to be displayed by erasing the correspondant $key-$value from the array

create excel file.

in case 2 execute a mysql query and get the excel file.

Skills: Javascript, MySQL, PHP

See more: val , php json , mysql query, mysql php, json php, excel file, excel submit, php jquery file, json jquery page, php file array, excel file mysql, php excel json, excel json php, php json excel, jquery sql form, value json php, mysql excel query, jquery file, jquery excel, submit mysql page, excel array, jquery json page, excel sql query, excel sql create, mysql object

About the Employer:
( 6 reviews ) ***************, Mexico

Project ID: #2521347

Awarded to:

sampathcse5816

Hi I am ready to start your work right now. Please provide further details. Waiting for your response....

$30 USD in 0 days
(15 Reviews)
3.4

4 freelancers are bidding on average $110 for this job

inzaghi2006

Hi, I'm very interested in your project. Please contact me

$60 USD in 2 days
(63 Reviews)
5.7
smartphp5

Have created excel and pdf files by fecting data from DB and jquery. I can do this job also easily. Lets discuss your table structure.

$200 USD in 4 days
(6 Reviews)
3.4
hemsingh1

Hi, understood the requirement. Ready to start. Regards

$150 USD in 2 days
(2 Reviews)
2.2