Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
You can handle the F11 key using Javascript function, check the below javascript function.
Below script is to show errors in PHP, the error_reporting function will show all the error.You have to initialize at the start of PHP tag.
