为什么不使用SELECT INTO OUTFILE 语法：

$wpdb->query("SELECT * INTO OUTFILE \'/path/to/file\' 
 FIELDS TERMINATED BY \'\\t\' 
 LINES TERMINATED BY \'\\n\' 
 FROM tracking");

将其创建为“export\\u data”。php文件。然后从链接调用此php

<?php
    $host = \'localhost\';
    $user = \'mysqlUser\';
    $pass = \'myUserPass\';
    $db = \'myDatabase\';
    $table = \'products_info\';
    $file = \'export\';

    $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");

    $result = mysql_query("SHOW COLUMNS FROM ".$table."");
    $i = 0;
    if (mysql_num_rows($result) > 0) {
        while ($row = mysql_fetch_assoc($result)) {
            $csv_output .= $row[\'Field\']."; ";
            $i++;
        }
    }
    $csv_output .= "\\n";

    $values = mysql_query("SELECT * FROM ".$table."");
    while ($rowr = mysql_fetch_row($values)) {
        for ($j=0;$j<$i;$j++) {
            $csv_output .= $rowr[$j]."; ";
        }
        $csv_output .= "\\n";
    }

    $filename = $file."_".date("Y-m-d_H-i",time());
    header("Content-type: application/vnd.ms-excel");
    header("Content-disposition: csv" . date("Y-m-d") . ".csv");
    header( "Content-disposition: filename=".$filename.".csv");
    print $csv_output;
    exit;
?>

我肯定来不及帮你回答问题了。。我希望：），但我的目标是其他任何需要更新WordPress函数才能将自定义表导出到一个漂亮干净的行显示CSV文件的人

    function ns_contact_form_csv_pull() {

       global $wpdb;

       $table = \'ns_contact_form\';// table name
       $file = \'ns_contact_form_csv\'; // csv file name
       $results = $wpdb->get_results("SELECT * FROM $wpdb->prefix$table",ARRAY_A );

       if(count($results) > 0){
          foreach($results as $result){
          $result = array_values($result);
          $result = implode(", ", $result);
          $csv_output .= $result."\\n";
        }
      }

      $filename = $file."_".date("Y-m-d_H-i",time());
      header("Content-type: application/vnd.ms-excel");
      header("Content-disposition: csv" . date("Y-m-d") . ".csv");
      header( "Content-disposition: filename=".$filename.".csv");
      print $csv_output;
      exit;

    }
   add_action(\'wp_ajax_csv_pull\',\'ns_contact_form_csv_pull\');

您可以使用以下命令在WordPress中的任何位置调用它：

$ajax_url = admin_url(\'admin-ajax.php?action=csv_pull\');

如果您有phpmyadmin，那么只需转到export并选择Excel 而不是SQL.

类似这样：

$results = $wpdb->get_results(\'SELECT * FROM tracking;\');

不确定如何最好地实现指向此的链接，使用自定义命名模板的页面可能会起作用。