我的数据库中的表中有许多行(成分),我使用以下代码迭代并使用每个的名称填充我的视图,但我希望能够显示子/父(列DB),我能够正确注销这些值,但是当我尝试如下回显时,我收到“消息:未定义索引:父母”和“消息:未定义索引:儿童”;<?php foreach ($ingredient as $row => $key) { ?> <tr> <td><?php echo $row + 1; ?> </td> <td><?php echo $key['name']; ?> </td> <?php ChromePhp::log($key['parents']); ?> <td><?php echo $key['parents']; ?> </td> <?php ChromePhp::log($key['children']); ?> <td><?php echo $key['children']; ?> </td> <td> </tr><?php } ?>我很困惑,因为我没有问题将其注销。我认为这可能是由于空值,所以我为孩子/父母为每一行分配了一个字符串值,如下所示;但错误仍然存在。这是浏览器中记录的输出;输出 <?php ChromePhp::log($key); ?>编辑:这是我如何构建 $ingredients 数组;<?php function get_ingredient() { $qry = "SELECT CONCAT(UPPER(LEFT(i.name, 1)), LCASE(SUBSTRING(`name`, 2))) as name,i.id as id,'ingredient' as type, i.parents as parents, i.children as children FROM `ingredient` i WHERE i.is_del=0 order by i.name asc"; $qry = $this->db->query($qry); if ($qry->num_rows() > 0) { $ingr = $qry->result_array(); } else { $ingr = array(); } } ?>我想我错过了一些基本的东西,任何建议都将不胜感激。干杯。
3 回答
慕村225694
TA贡献1880条经验 获得超4个赞
<?php foreach ($ingredient as $row => $key) { ?>
<tr>
<td><?php echo $row + 1; ?> </td>
<?php if(isset($key['name']) && !empty($key['name'])):?>
<td><?php echo $key['name']; ?> </td>
<?php endif;?>
<?php if(isset($key['parents']) && !empty($key['parents'])):?>
<?php ChromePhp::log($key['parents']); ?>
<td><?php echo $key['parents']; ?> </td>
<?php endif;?>
<?php if(isset($key['children']) && !empty($key['children'])):?>
<?php ChromePhp::log($key['children']); ?>
<td><?php echo $key['children']; ?> </td>
<?php endif;?>
</tr>
- 3 回答
- 0 关注
- 189 浏览
添加回答
举报
0/150
提交
取消