wordpress 导出export.php,php – 导出到csv wordpress

这现在完美地运作了.我们可以将它用作插件.我修改了

this帖子.感谢sruthi sri.

希望这有助于一些:)

class CSVExport

{

/**

* Constructor

*/

public function __construct()

{

if(isset($_GET['download_report']))

{

$csv = $this->generate_csv();

header("Pragma: public");

header("Expires: 0");

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Cache-Control: private", false);

header("Content-Type: application/octet-stream");

header("Content-Disposition: attachment; filename=\"report.csv\";" );

header("Content-Transfer-Encoding: binary");

echo $csv;

exit;

}

// Add extra menu items for admins

add_action('admin_menu', array($this, 'admin_menu'));

// Create end-points

add_filter('query_vars', array($this, 'query_vars'));

add_action('parse_request', array($this, 'parse_request'));

}

/**

* Add extra menu items for admins

*/

public function admin_menu()

{

add_menu_page('Download Report', 'Download Report', 'manage_options', 'download_report', array($this, 'download_report'));

}

/**

* Allow for custom query variables

*/

public function query_vars($query_vars)

{

$query_vars[] = 'download_report';

return $query_vars;

}

/**

* Parse the request

*/

public function parse_request(&$wp)

{

if(array_key_exists('download_report', $wp->query_vars))

{

$this->download_report();

exit;

}

}

/**

* Download report

*/

public function download_report()

{

echo '

';

echo '

echo '

Download Report

';

//$url = site_url();

echo '

Export the Subscribers';

}

/**

* Converting data to CSV

*/

public function generate_csv()

{

$csv_output = '';

$table = 'users';

$result = mysql_query("SHOW COLUMNS FROM ".$table."");

$i = 0;

if (mysql_num_rows($result) > 0) {

while ($row = mysql_fetch_assoc($result)) {

$csv_output = $csv_output . $row['Field'].",";

$i++;

}

}

$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");

while ($rowr = mysql_fetch_row($values)) {

for ($j=0;$j

$csv_output .= $rowr[$j].",";

}

$csv_output .= "\n";

}

return $csv_output;

}

}

// Instantiate a singleton of this plugin

$csvExport = new CSVExport();