Question: how to export data from sql to excel in php?
Answer: Here we have sample result set from MySQL and want to export in excel file. Step 1: Created sample MySQL data in key value pair as like below. Step 2: PHP code to get options type and force to browser download file instead of display. Above code use to get format type and tells that browser to download excel file.