Export data mysql table to csv file using PHP
Welcome to the In Pakainfo.com website! You will Step By Step learn web programming, easy and very fun. This website allmost provides you with a complete web programming tutorial presented in an easy-to-follow manner. Each web programming tutorial has all the practical examples with web programming script and screenshots available.In My Export data mysql table to csv file using PHP
How to Import and Export CSV Files Using PHP and MySQL
// download invoice csv sheet if ($action == 'download_csv'){ header("Content-type: text/csv"); // any output any to connection error display if ($mysqli->connect_error) { die('Error : ('.$mysqli->connect_errno .') '. $mysqli->connect_error); } $fname = 'invoice-data-'.date('d-m-Y').'.csv'; // simple file name $fileuserpath = 'downloads/'.$fname; // here file path put $file = fopen($fileuserpath, "w"); // php file handling to open a file in write mode chmod($fileuserpath, 0777); //php file handling to set the file permission $query_table_columns = "SELECT * FROM products i JOIN users c ON c.productname = i.productname WHERE i.productname = c.productname ORDER BY i.productname"; if ($result_column = mysqli_query($mysqli, $query_table_columns)) { // fetch the table fields data in mysql while ($column_data = $result_column->fetch_row()) { $collumdata = array(); foreach($column_data as $data) { $collumdata[] = $data; } // her Format array like as CSV data and write to all file pointer fputcsv($file, $collumdata, ",", '"'); } } }
$result_data = mysqli_query($con, 'SELECT * FROM productmst'); $row_data = mysqli_fetch_array($result_data, MYSQLI_ASSOC); $fipeopen = fopen('myfile.csv', 'w'); foreach ($row_data as $val) { fputcsv($fipeopen, $val); } fclose($fipeopen);