duandi8852752
2016-09-30 09:51
浏览 20
已采纳

使用数据库中的数据创建CSV文件,给出“马赛克,散乱”的结果

First part of code works fine, but the second one (displaying results), works wrongly. If i am inserting $slugs = explode(',', $slugs) inside foreach ($pma...), it gives me explode() expects parameter 2 to be string, array given error. If i keep it as it now, it works, but the results is given in "mosaic, straggly" mode, with multiple same results. Even print_r() shows 800 results per one row (it is nonsense).

How to fix this?

$data = fopen('php://output', 'w');

$fields = rtrim($_GET['fieldnames'], ",");
$slugs = rtrim($_GET['slugs'], ",");

$fieldnames = array();
$fieldslugs = array();

$pma = DB::table... // long query

$fields = explode(',', $fields);
   foreach ($fields as $field) {
      $fieldnames[] = $field;
}

fputcsv($data, $fieldnames);


$slugs = explode(',', $slugs);

foreach ($pma as $p) {

  foreach ($slugs as $slug) {
    $fieldslugs[] = $p->$slug;
  }

  fputcsv($data, $fieldslugs);

}

Sorry for bad english, and tanks for any answers!

2条回答 默认 最新

相关推荐 更多相似问题