Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // The name of the table
- $db_record = '';
- // optional where query
- $where = 'WHERE 1 ORDER BY 1';
- $csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
- $hostname = "";
- $user = "";
- $password = "";
- $database = "";
- $port = ;
- $conn = mysqli_connect($hostname, $user, $password, $database, $port);
- if (mysqli_connect_errno()) {
- die("Failed to connect to MySQL: " . mysqli_connect_error());
- }
- $csv_export = '';
- $query = mysqli_query($conn, "SELECT * FROM ".$db_record." ".$where);
- $field = mysqli_field_count($conn);
- for($i = 0; $i < $field; $i++) {
- $csv_export.= mysqli_fetch_field_direct($query, $i)->name.';';
- }
- $csv_export.= '
- ';
- while($row = mysqli_fetch_array($query)) {
- // create line with field values
- for($i = 0; $i < $field; $i++) {
- $csv_export.= '"'.$row[mysqli_fetch_field_direct($query, $i)->name].'";';
- }
- $csv_export.= '
- ';
- }
- header("Content-type: text/x-csv");
- header("Content-Disposition: attachment; filename=".$csv_filename."");
- echo($csv_export);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement