All Entries Tagged With: "excel"

Export Database to Excel or CSV File

The below code help you to export data from database to csv file exporttoxls To export a complete database, you should invoke all the tables via below code and apply the above code $dbname = ‘mysql_dbname’; if (!mysql_connect(‘mysql_host’, ‘mysql_user’, ‘mysql_password’)) { echo ‘Could not connect to mysql’; exit; } $sql = “SHOW TABLES FROM $dbname”; [...]