使用php从mysql数据库导出csv文件

Question

<?php
    include("includes/config.php"); 
    if ($_POST['frmCsv']) {
        $strSelect = doSelectCsv();
        header( 'Content-Type: text/csv' );
        header( 'Content-Disposition: attachment;filename=export.csv' );
        $strRow = mysql_fetch_assoc( $strSelect );
        printArray($strRow);
        if ( $strRow ) {
            outputcsv( array_keys( $strRow ) );
        }
        while ( $strRow ) {
            outputcsv( $strRow ); 
        }
    }

    function doSelectCsv()
    {
        $strSql = "SELECT * FROM tbl_member";
        $strResult = SelectQry($strSql);
    }

    function outputcsv( $fields )
    {
        $separator = '';
        foreach ( $fields as $field ) {
            echo $separator . $field;
            $separator = ',';     
        }
    }
?>

This is my code to export a csv file from the database. but it could not select the datas. select query did not works correctly. please help me.

Answer 1

Just use it brother :)

<?php

if($_POST["download"]){ 
        $output="";
        $line_termineted="
";

        if( $_POST["download"] =="CSV") $field_termineted=","; else $field_termineted="\t"; 
            $enclosed='"';
            $escaped="\\";

            $export_schema="SR No".$field_termineted."Student ID".$field_termineted."First Name".$field_termineted."Middle Name".$field_termineted."Last Name";
            $dataQuery=mysql_query("select * from sof_student ");
            $output.=$export_schema;
            $p=0;
            while($data=mysql_fetch_array($dataQuery)) {
             $p++;
                $output.= $line_termineted.$p.$field_termineted;
                $output.=$enclosed.$data["id"].$enclosed.$field_termineted;
                $output.=$enclosed.$data["first_name"].$enclosed.$field_termineted;
                $output.=$enclosed.$data["middle_name"].$enclosed.$field_termineted;
                $output.=$enclosed.$data["last_name"].$enclosed.$field_termineted;
              }

    header("Content-Description: File Transfer");
   if( $_POST["download"] =="CSV"){
        header("Content-Type: application/csv");
        header("Content-Disposition: attachment; filename=report".date("d_m_Y_H_i_s").".csv");
    } else {
        header("Content-Type: application/vnd.ms-excel");
        header("Content-disposition: attachment; filename=report".date("d_m_Y_H_i_s").".xls");
    }

    header("Content-Transfer-Encoding: binary");
    header("Expires: 0");
    header("Cache-Control: must-revalidate");
    header("Pragma: public");
    header("Content-Length: ".strlen($output));
    ob_clean();
    flush();
    echo $output;
    exit;
}
 ?>