php - PHP 中的 EOT 仅显示一行

Question

我有一个名为 products 的表当我尝试显示表中的所有产品时，它只显示一项。我的代码有什么问题吗？

当我尝试 echo $obj->product_id在 while 循环内，它工作正常并返回所有行。

这是我的代码:

<!-- Products List Start -->
<?php
$results = $connection->query("SELECT product_id, product_name, product_desc, product_buyp, product_quantity FROM products ORDER BY product_id ASC");
if($results){ 
//fetch results set as object and output HTML
while($obj = $results->fetch_object())
{
$products_item = <<<EOT
    <form method="post" action="cartUpdate.php">
    <table class="table table-condensed table-hover">
        <thead>
            <tr>
                <th>Product ID</th>
                <th>Product Name</th>
                <th>Description</th>
                <th>Instock</th>
                <th>Buy Price</th>
                <th>Qty</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>{$obj->product_id}</td>
                <td>{$obj->product_name}</td>
                <td>{$obj->product_desc}</td>
                <td>{$obj->product_quantity}</td>
                <td>{$obj->product_buyp}</td>
                <td><input type="number" size="2" maxlength="6" name="product_qty"></td>
            </tr>
        </tbody>
    </table>
    <input type="hidden" name="product_id" value="{$obj->product_id}" />
    <input type="hidden" name="type" value="add" />
    <input type="hidden" name="return_url" value="{$current_url}" />
    <button type="submit" class="add_to_cart">Add</button>
    </form>
EOT;
}
echo $products_item;
}
?>    
<!-- Products List End -->

这是我的数据架构

无论如何，当我尝试向 .=<<<EOT 添加连接符号时它返回所有行，但也创建一个新表。

Answer 1

试试这个刚刚向 $products_item 添加了串联

<!-- Products List Start -->
<?php
$results = $connection->query("SELECT product_id, product_name,       product_desc, product_buyp, product_quantity FROM products ORDER BY     product_id ASC");
if($results){ 
//fetch results set as object and output HTML
while($obj = $results->fetch_object())
{
$products_item.= <<<EOT //added conc
   ....
   ....