如何在表格中显示搜索结果，同时将其导出为CSV文件?

我以表格形式显示搜索表单的结果。当用户按名字或位置搜索时点击搜索按钮就会显示结果但现在的问题是，我想将数据导出为csv文件如何实现呢?

我已经做了这样的事情来实现它，但它现在只显示CSV文件，没有表格形式的数据在页面上:

<form class="form-horizontal" action="testclass.php" method="post" name="userform">
    <?php if($_GET[id]){?>
    <?php }else{?>
    <fieldset>
     <legend>Search</legend>
    <div class="control-group">
    <label class="control-label">Search Term</label>
    <div class="controls">
    <input type="text" class="span3 search-query" name="term" placeholder="search by name and location">
    <button type="submit" class="btn" name="search"><a href="testclass.php">Search</a></button>
    </div>
    </div>
</form>

下面是我的testclass.php文件中的代码:

<?php
     //EDIT YOUR MySQL Connection Info:
     $DB_Server = "localhost";        //your MySQL Server 
     $DB_Username = "xyz";                 //your MySQL User Name 
     $DB_Password = "";                //your MySQL Password 
     $DB_DBName = "zxse";                //your MySQL Database Name 
     $DB_TBLName = "customers";                //your MySQL Table Name 
     $term = $_POST[term];
     //$DB_TBLName,  $DB_DBName, may also be commented out & passed to the browser
     //as parameters in a query string, so that this code may be easily reused for
     //any MySQL table or any MySQL database on your server
     //DEFINE SQL QUERY:
     //you can use just about ANY kind of select statement you want - 
     //edit this to suit your needs!
    $sql = "Select * from $DB_TBLName where name like '%$term%' or location like '%$term%'";
    //die();
     //Optional: print out title to top of Excel or Word file with Timestamp
     //for when file was generated:
     //set $Use_Titel = 1 to generate title, 0 not to use title
     $Use_Title = 1;
     //define date for title: EDIT this to create the time-format you need
     $now_date = date('m-d-Y H:i');
     //define title for .doc or .xls file: EDIT this if you want
     $title = "Dump For Table $DB_TBLName from Database $DB_DBName on $now_date";
     /*
     Leave the connection info below as it is:
     just edit the above.
     (Editing of code past this point recommended only for advanced users.)
     */
     //create MySQL connection
     $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
         or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
     //select database
     $Db = @mysql_select_db($DB_DBName, $Connect)
         or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
     //execute query
     $result = @mysql_query($sql,$Connect)
         or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
     //if this parameter is included ($w=1), file returned will be in word format ('.doc')
     //if parameter is not included, file returned will be in excel format ('.xls')
     if (isset($w) && ($w==1))
     {
         $file_type = "msword";
         $file_ending = "doc";
     }else {
         $file_type = "vnd.ms-excel";
         $file_ending = "xls";
     }
     //header info for browser: determines file type ('.doc' or '.xls')
     header("Content-Type: application/$file_type");
     header("Content-Disposition: attachment; filename=$DB_TBLName.$file_ending");
     header("Pragma: no-cache");
     header("Expires: 0");
     /*    Start of Formatting for Word or Excel    */
     if (isset($w) && ($w==1)) //check for $w again
     {
         /*    FORMATTING FOR WORD DOCUMENTS ('.doc')   */
         //create title with timestamp:
         if ($Use_Title == 1)
         {
             echo("$titlenn");
         }
         //define separator (defines columns in excel & tabs in word)
         $sep = "'r"; //new line character
         while($row = mysql_fetch_row($result))
         {
             //set_time_limit(60); // HaRa
             $schema_insert = "";
             for($j=0; $j<mysql_num_fields($result);$j++)
             {
             //define field names
             $field_name = mysql_field_name($result,$j);
             //will show name of fields
             $schema_insert .= "$field_name:t";
                 if(!isset($row[$j])) {
                     $schema_insert .= "NULL".$sep;
                     }
                 elseif ($row[$j] != "") {
                     $schema_insert .= "$row[$j]".$sep;
                     }
                 else {
                     $schema_insert .= "".$sep;
                     }
             }
             $schema_insert = str_replace($sep."$", "", $schema_insert);
             $schema_insert .= "'t'n";
             print(trim($schema_insert));
             //end of each mysql row
             //creates line to separate data from each MySQL table row
             print "n----------------------------------------------------n";
         }
     }else{
         /*    FORMATTING FOR EXCEL DOCUMENTS ('.xls')   */
         //create title with timestamp:
         if ($Use_Title == 1)
         {
             echo("$titlen");
         }
         //define separator (defines columns in excel & tabs in word)
         $sep = "'t"; //tabbed character
         //start of printing column names as names of MySQL fields
         for ($i = 0; $i < mysql_num_fields($result); $i++)
         {
             echo mysql_field_name($result,$i) . "'t";
         }
         print("'n");
         //end of printing column names
         //start while loop to get data
         while($row = mysql_fetch_row($result))
         {
             //set_time_limit(60); // HaRa
             $schema_insert = "";
             for($j=0; $j<mysql_num_fields($result);$j++)
             {
                 if(!isset($row[$j]))
                     $schema_insert .= "NULL".$sep;
                 elseif ($row[$j] != "")
                     $schema_insert .= "$row[$j]".$sep;
                 else
                     $schema_insert .= "".$sep;
             }
             //$schema_insert = str_replace($sep."$", "", $schema_insert);
             //following fix suggested by Josue (thanks, Josue!)
             //this corrects output in excel when table fields contain n or r
             //these two characters are now replaced with a space
             //$schema_insert = preg_replace("/rn|nr|n|r/", " ", $schema_insert);
             $schema_insert .= "'n't";
             print(trim($schema_insert));
             print "'n'r";

         }
     }
     ?>

<button type="submit" name="search1"><a href="testclass.php">Search</a></button>
<button type="submit" name="search2"><a href="testclass.php?w=1">Search by name</a></button>

 $fp = fopen($csvFilename, "w");
 echo "<table class='table-bordered'>";
 while($record = mysql_fetch_assoc($result)){
         echo "<tr><td>".htmlspecialchars($record["field1"])."</td>";
         echo "<td>".htmlspecialchars($record["field2"])."</td>";
         //....etc
         fputcsv($fp, $record);
 }
 echo "</table>";
 fclose($fp);

if $csv!=1 show tables html code and an iframe code after html table.
in iframe source, call testclass.php?csv=1 and width=0 height=0
when testclass.php?csv=1 calls again:
if $csv==1 export csv file and dont show tables html code and iframe code.