Skip to content

Instantly share code, notes, and snippets.

Avatar

Alvaro Artagaveytia alvaroarta

View GitHub Profile
@alvaroarta
alvaroarta / gist:83543d5c2e3cdf01cb31d83548451d85
Last active Apr 10, 2019
Export MySQL to Excel using php (mysqli version)
View gist:83543d5c2e3cdf01cb31d83548451d85
<?php
/*******EDIT LINES 5-10*******/
$DB_Server = "localhost"; //MySQL Server
$DB_Username = "username"; //MySQL Username
$DB_Password = "yourpassword"; //MySQL Password
$DB_DBName = "dbname"; //MySQL Database Name
$DB_TBLName = "tblname"; //MySQL Table Name
$filename = "filename"; //File Name
You can’t perform that action at this time.