Error in Data Export from Mysql Query

WPTables Version: 1.3.8

Problem:
1. I added a table using MySQL query. But it couldn’t export data existed in table.
2. It appeared garbled fonts in CSV file when there were fonts like Chinese or Korean.

Possible Solution:
1. /includes/export/class-wptables-csv-export.php, at line 21, add codes to support mysql query:

if ($post->post_mime_type == 'mysql/db-table') {
  ...
} elseif ($post->post_mime_type == 'mysql/mysql-query') {
  $query_str = $post->post_content;
  $loader = new WPTables_MySqlLoader();
  $this->data = $loader->load_query($query_str);
else {
  ...
}

2. /admin/class-wptables-admin.php, at line 399, output BOM characters before exported data:

echo chr(0xEF).chr(0xBB).chr(0xBF);
echo $csv->export();

• This topic was modified 6 years, 9 months ago by varpenny.