Foreach显示一个额外的空回声场

The following foreach loop shows an extra empty field. It has the html markup like in the foreach, but doesn't load anything from the database. There is no extra empty field in the database, I checked.

   //  content
    $content            = "SELECT * FROM `lb_content` WHERE catid = 13";
    $contentcon         = $conn->query($content);
    $contentcr          = array();
    while ($contentcr[] = $contentcon->fetch_array());

    foreach($contentcr as $content) 
    {

        $article_images = $content['images']; // Get image parameters of the article

        $pictures = json_decode($article_images); // Split the parameters apart

        $contentje .= '<li class="job_listing">
        <a href="http://www.website.nl/_extern/website/content.php?alias='.$content['alias'].'">
            <div class="location job_img">
                <img name="images" src="/_extern/website/cms/'.$pictures->{'image_intro'}.'" alt="" class="company_logo">
            </div>
            <div class="location boldfont">
                '.$content['title'].'
            </div>
            <div class="location specificaties">
            '.$content['introtext'].'
            </div>
            <div class="rating location">
                <div class="rating-stars">
                    <i class="fa fa-star"></i>
                    <i class="fa fa-star"></i>
                    <i class="fa fa-star"></i>
                    <i class="fa fa-star"></i>
                    <i class="fa fa-star"></i>
                </div>
            </div>
            <div class="location prijs">
                '.$content['metakey'].'
                <br>
                <div class="cursief">Vanaf 2 weken</div>
            </div>
            <div class="location">
                <button type="submit" class="btn btn-primary buttonblock" onClick="location.href="http://www.website.nl/_extern/website/content.php?page="'.$content['alias'].'">Nu huren</button>
            </div>
        </a>
    </li>'; // Here
    }

echo $contentje;

Here is an image with the last working field and one extra. Where does the extra empty field come from?

This is part of the output of the array, as you can see array value '6' is empty.

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
duangelin7513 2015-12-22 12:57
关注
The line while ($contentcr[] = $contentcon->fetch_array()); will keep making trips to the database result and put something into the array, regardless.

What you then have is the last array index in $contentcr effectively being FALSE, as it can no longer gather a result set. Something is still returned, but not a result set.

Your array then looks something like:

$contentcr[0] = array(...); $contentcr[1] = array(...); $contentcr[n-1] = array(...); $contentcr[n] = FALSE;

Which is why you always end up with an empty field.

You can better get round this by replacing your foreach($contentcr as $content) line with while ($content = $contentcon->fetch_array()). This will stop when $contentcon->fetch_array() is false, and won't give you an empty field
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

PHP foreach循环记住最后一个循环变量 html mysql php
2018-07-16 01:23

回答 1 已采纳 You're instantiating a DateTime instance without any sort of condition: $D_DateComp = new datetim
php在foreach之后返回一个空数组 php
2012-07-20 07:12

回答 5 已采纳 There's an extra linebreak or other whitespace character after the last domain. Trim the text fi
foreach只显示一个元素 html php
2015-01-07 03:16

回答 1 已采纳 I suggest to use date comparison using strtotime. The main problem is that your HTML for the radio
php foreach怎么判断最后一个,在PHP中使用foreach循环时查找数组的最后一个元素
2021-03-24 10:21

Nate Hillick的博客当toEnd达到0时，表示它在循环的最后一次迭代中。$toEnd = count($arr);...}}最后一个值在循环后仍然可用，因此如果您只想在循环后将其用于更多内容，则更好：foreach($arr as $key=>$value)...
PHP组将某些结果从foreach on array转换为另一个数组 php
2018-09-27 18:34

回答 4 已采纳 Are you sure this will be the naming format? That is crucial information to have to construct a re
PHP foreach循环问题与第一个元素 php
2015-11-14 00:45

回答 2 已采纳 Just so you can understand, take a lool at this code. And more explanation: You have a variable $
foreach循环仅在循环中输出第一个值 php
2019-04-16 17:15

回答 2 已采纳 try this solution: function array_unique_multidimensional($array, $key) { $temp_array = array
php foreach详解,php foreach的用法详解,foreach怎么使用
2021-04-19 03:25

非知名数码剁主的博客 php foreach的用法详解详细解释了PHP foreach的用法，php foreach的用法：1。通过语法“foreach(array _ expression as $ value)”使用它；2.采用语法“foreach(array _ expression as $ key=$ value)”。推荐：...
声明使用PHP显示foreach输出的顺序 php sql
2018-08-14 15:47

回答 1 已采纳 I think what you are looking for is ORDER BY FIELD (MySql), this lets you order by a field in a sp
foreach中的数组仅显示第一个数组 php
2017-01-13 07:57

回答 2 已采纳 Try changing your foreach to work as followed: foreach ($terms as $term) { $array2 = array (
在php中的foreach循环中的第一个项之后添加条件 php
2019-03-04 10:47

回答 1 已采纳 // add counter in the loop. when loop count is greater than 1 button will be shown. $counter =
velocity foreach 判断是否是最后一个
2018-06-25 20:10

桑汤奈伊伏的博客经常有在循环内判断是否是最后一个元素的需求，使用 $foreach.hasNext 或 $foreach.last就可以完成这种逻辑，不需要什么count。下面是一个例子：这段代码使用velocity来生成sql代码段，其作用是遍历某张表的所有列，...
PHP - 使用foreach显示2维数组 php
2019-06-27 13:21

回答 2 已采纳 You need to apply foreach() like below:- <?php foreach($array as $arr){?> <tr>
java foreach 空指针_foreach循环报NPE空指针异常
2021-03-01 07:59

不妧的博客前言最近debug时忽然发现，如果一个集合赋值为null，那么对该集合进行foreach循环(也叫增强for循环)时，会报NPE(即空指针异常NullPointerException)。代码如下：final List list = null;// final List list = new ...
java foreach的一个细节问题，遍历出现的空指针异常
2022-05-06 20:02

itbird01的博客一直以为foreach是可以判别null和空数组的，知道今天用foreach出现了空指针才打破我的这个想法。对此还专门弄了测试 List<String> list = null; for (String str : list) {//会报空指针异常 System.out....
没有解决我的问题, 去提问

悬赏问题

¥40 图书信息管理系统程序编写
¥15 7-1 jmu-java-m02-使用二维数组存储多元线性方程组
¥20 Qcustomplot缩小曲线形状问题
¥15 企业资源规划ERP沙盘模拟
¥15 树莓派控制机械臂传输命令报错，显示摄像头不存在
¥15 前端echarts坐标轴问题
¥15 ad5933的I2C
¥15 请问RTX4060的笔记本电脑可以训练yolov5模型吗？
¥15 数学建模求思路及代码
¥50 silvaco GaN HEMT有栅极场板的击穿电压仿真问题

Foreach显示一个额外的空回声场

1条回答 默认 最新

悬赏问题

1条回答默认最新