PHP(6)各类问题集，比如查询mysql

foreach 循环体嵌入html的写法

摘自https://blog.csdn.net/tglhmily1/article/details/79665582

<?php foreach ($data as $k => $v): ?>
            <tr class="tron">
                <td align="center"><?php echo $v['id']; ?></td>
                <td align="center" class="first-cell"><span><?php echo $v['goods_name']; ?></span></td>
                <td align="center"><?php showImage($v['sm_logo']); ?></td>
                <td align="center"><?php echo $v['market_price']; ?></td>
                <td align="center"><?php echo $v['shop_price']; ?></td>
                <td align="center"><?php echo $v['is_on_sale']; ?></td>
                <td align="center"><?php echo $v['addtime']; ?></td>
                <td align="center">
                    <a href="<?php echo U('edit?id='.$v['id']); ?>">修改</a>
                    <a onclick="return confirm('确定要删除吗？');" href="<?php echo U('delete?id='.$v['id']); ?>">删除</a>
               </td>
            </tr>
            <?php endforeach; ?>

查询mysql

function mysqlScript(con=init();
result = mysqli_query(sql);
if (mysqli_num_rows(row = mysqli_fetch_assoc(result_list,result_list;
} else {
return [''];
}
}