错误：foreach（）提供的参数无效 [英] Error: Invalid argument supplied for foreach()

问题描述

我想要一个行的数据库表forch它回声每个，但有以下错误：

I want for a row that get of database table forch it for echo each a but have following error:

$query = $this -> db -> query('
    SELECT
       @rownum := @rownum + 1 rownum,
       tour_foreign.id, 
       tour_foreign.name, 
       MIN(tour_foreign_residence.name_re) AS name_re, 
       tour_foreign.service, 
       tour_foreign.date_go, 
       tour_foreign.date_back, 
       tour_foreign.term,
       tour_foreign.useradmin_submit,
       tour_foreign.date_submit,
       GROUP_CONCAT( tour_foreign_residence.name_re 
                     ORDER BY tour_foreign_residence.name_re 
                     SEPARATOR " "
                   ) AS name_re_all
    FROM   tour_foreign 
      INNER JOIN tour_foreign_residence 
        ON ( tour_foreign.id = tour_foreign_residence.relation )
      JOIN (SELECT @rownum := 0) r
    WHERE  tour_foreign.name LIKE "%' . $find . '%" 
        OR tour_foreign_residence.name_re LIKE "%' . $find . '%"
    GROUP BY  tour_foreign.id ');

foreach ($query->result() as $row) {
echo $row->name_re_all //thisoutput is: 11111 22222 33333 44444 ...
    foreach ($row->name_re_all as $val) {
        echo $val . '<br>';
    }
}

PHP错误遇到

A PHP Error was encountered

严重性：警告

Severity: Warning

讯息：foreach br>

Message: Invalid argument supplied for foreach()

文件名：core / Loader.php（679）：eval（）'d代码

Filename: core/Loader.php(679) : eval()'d code

行号：86

Line Number: 86

推荐答案

Foreach 用于遍历数组，您将字符串作为参数传递

Foreach is used to iterate trough an array, you're passing a string as a parameter

这篇关于错误：foreach（）提供的参数无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！