<?php // Database Connection $host="localhost"; $uname="root"; $pass=""; $database = "a2zwebhelp"; $connection=mysql_connect($host,$uname,$pass); echo mysql_error(); //or die("Database Connection Failed"); $selectdb=mysql_select_db($database) or die("Database could not be selected"); $result=mysql_select_db($database) or die("database cannot be selected <br>"); // Fetch Record from Database $output = ""; $table = ""; // Enter Your Table Name $sql = mysql_query("select * from $table"); $columns_total = mysql_num_fields($sql); // Get The Field Name for ($i = 0; $i < $columns_total; $i++) { $heading = mysql_field_name($sql, $i); $output .= '"'.$heading.'",'; } $output .="\n"; // Get Records from the table while ($row = mysql_fetch_array($sql)) { for ($i = 0; $i < $columns_total; $i++) { $output .='"'.$row["$i"].'",'; } $output .="\n"; } // Download the file $filename = "myFile.csv"; header('Content-type: application/csv'); header('Content-Disposition: attachment; filename='.$filename); echo $output; exit; ?>
Read CSV File using PHP
Export MySQL table to iCalendar (.ICS) using PHP
Import data from .ICS file to MySQL table