pdo

Question

我用的是流利的https://github.com/lichtner/fluentpdo

我试图用下面的代码将表中的结果循环到html中

$bxslider = $fpdo->from('bxslider')->select('box_img, box_link, box_title, box_desc');

但是我只得到了一个结果

foreach ($bxslider as $bx) {
    $BXSLIDER = "<li>";
    $BXSLIDER .= "<em>";
    $BXSLIDER .= "<img src='{$bx['box_img']}' alt='{$bx['box_title']}' />";
    $BXSLIDER .= "<a href='{$bx['box_link']}'><i class='fa fa-link icon-hover icon-hover-1'></i></a>";
    $BXSLIDER .= "<a href='{$bx['box_img']}' class='fancybox-button' title='{$bx['box_title']}' data-rel='fancybox-button'><i class='fa fa-search icon-hover icon-hover-2'></i></a>";
    $BXSLIDER .= "</em>";
    $BXSLIDER .= "<a class='bxslider-block' href='#'>";
    $BXSLIDER .= "<strong>{$bx['box_title']}</strong>";
    $BXSLIDER .= "<b>{$bx['box_desc']}</b>";
    $BXSLIDER .= "</a>";
    $BXSLIDER .= "</li>";
}

print $BXSLIDER;

如何显示所有结果？

问题不是来自fluentpdo类，因为我使用了另一个类，甚至使用了来自PHP的简单pdo类，而且我在所有的.

提前谢谢..。

Answer 1

您正在用每个foreach循环覆盖$BXSLIDER。你需要这样做：

$BXSLIDER = "";
foreach ($bxslider as $bx) {

$BXSLIDER .= "<li>";
                        $BXSLIDER .= "<em>";
                            $BXSLIDER .= "<img src='{$bx['box_img']}' alt='{$bx['box_title']}' />";
                            $BXSLIDER .= "<a href='{$bx['box_link']}'><i class='fa fa-link icon-hover icon-hover-1'></i></a>";
                            $BXSLIDER .= "<a href='{$bx['box_img']}' class='fancybox-button' title='{$bx['box_title']}' data-rel='fancybox-button'><i class='fa fa-search icon-hover icon-hover-2'></i></a>";
                        $BXSLIDER .= "</em>";
                        $BXSLIDER .= "<a class='bxslider-block' href='#'>";
                            $BXSLIDER .= "<strong>{$bx['box_title']}</strong>";
                            $BXSLIDER .= "<b>{$bx['box_desc']}</b>";
                        $BXSLIDER .= "</a>";
                    $BXSLIDER .= "</li>";

}

print $BXSLIDER;

Answer 2

每次迭代都要覆盖变量。

尝试：

$BXSLIDER = "<ul>";

foreach ($bxslider as $bx) {
    $BXSLIDER .= "<li>";
    $BXSLIDER .= "<em>";
    $BXSLIDER .= "<img src='{$bx['box_img']}' alt='{$bx['box_title']}' />";
    $BXSLIDER .= "<a href='{$bx['box_link']}'><i class='fa fa-link icon-hover icon-hover-1'></i></a>";
    $BXSLIDER .= "<a href='{$bx['box_img']}' class='fancybox-button' title='{$bx['box_title']}' data-rel='fancybox-button'><i class='fa fa-search icon-hover icon-hover-2'></i></a>";
    $BXSLIDER .= "</em>";
    $BXSLIDER .= "<a class='bxslider-block' href='#'>";
    $BXSLIDER .= "<strong>{$bx['box_title']}</strong>";
    $BXSLIDER .= "<b>{$bx['box_desc']}</b>";
    $BXSLIDER .= "</a>";
    $BXSLIDER .= "</li>";
}
$BXSLIDER .= "</ul>";

print $BXSLIDER;