php - How to add headers in CSV when using into out file

Question

I am trying to generate CSV with custom headers like USRNAME , USER PROFILE , EMAIL .

This is the code I am using .

$path = getcwd() . '/uploads/data.csv' ;
$sql = "select username, CONCAT('<a href ="$profile',username,'">',username,'</a>') as profile_url ,email  from `engine4_user` LIMIT 5000 into outfile '$path' FIELDS TERMINATED BY ','  LINES TERMINATED BY '
' ";

But I don't know how to add custom header , Or a custom row before the DB values. Please help me to add those fields .

I wants a CSV that will out put like:
USERNAME , PROFILE , EMAIL 
Jonson1 , http://mysite/profile/jonson1 , jonson.test1@gmail.com
Jonson2 , http://mysite/profile/jonson2 , jonson.test2@gmail.com
Jonson3 , http://mysite/profile/jonson3 , jonson.test3@gmail.com
Jonson4 , http://mysite/profile/jonson4 , jonson.test4@gmail.com

Now I generate :
Jonson1 , http://mysite/profile/jonson1 , jonson.test1@gmail.com
Jonson2 , http://mysite/profile/jonson2 , jonson.test2@gmail.com
Jonson3 , http://mysite/profile/jonson3 , jonson.test3@gmail.com
Jonson4 , http://mysite/profile/jonson4 , jonson.test4@gmail.com

I need to add 
USERNAME , PROFILE , EMAIL 

Thank You in advance .

Answer 1

Add headers using fputcsv() of php...Click for Reference