Export the database as in the format of CSV to open it in the Microsft office (MS)-Excel. Most the social media sites and E-commerce site and more sites or this kind of database export coding for without going to admin panel, just in one click export the database table as in the format of CSV to open it in MS-Excel. Just on a click export the database table, using PHP code. let see how it works.
This operation need some PHP code and header code make the operation successful from the browser, that's why we have to use the header code in this. and this code need some files those files are,
as in the db.php file, make this.
database name --> 2my4edge
table name--> export_table
column names --> id,name,place
and as you, here i just declare what i have given in.
this file is just for do the download, just give the link anchor tag, usually you know to make just click export the data, for that just give the link on anchor link, that will export the data table.
as given in the above line. just do it as i mentioned the above.