PHP CSV File Export Using fputcsv()

Adventurous Ant answered on July 23, 2022 Popularity 9/10 Helpfulness 6/10

answer PHP CSV File Export Using fputcsv()

PHP CSV File Export Using fputcsv()

Comment

<?php
$conn = mysqli_connect("localhost", "root", "test", "phppot_examples");

$filename = "toy_csv.csv";
$fp = fopen('php://output', 'w');

$query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='phppot_examples' AND TABLE_NAME='toy'";
$result = mysqli_query($conn,$query);
while ($row = mysqli_fetch_row($result)) {
	$header[] = $row[0];
}	

header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);
fputcsv($fp, $header);

$query = "SELECT * FROM toy";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_row($result)) {
	fputcsv($fp, $row);
}
exit;
?>

Popularity 9/10 Helpfulness 6/10 Language php

Source: phppot.com

Tags: csv export file php using

Link to this answer
Share Copy Link

Contributed on Jul 23 2022

Adventurous Ant

0 Answers Avg Quality 2/10

PHP CSV File Export Using fputcsv()

Contents

More Related Answers

PHP CSV File Export Using fputcsv()

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.