MySQL数据导入模板 [英] MySQL data into template
本文介绍了MySQL数据导入模板的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我从PHP开始,并且我的这段代码可以正常工作:
I'm starting with PHP and I have this code that works fine:
<body>
<?
require("conexaoBD.php");
$sql = "SELECT * FROM tb_materia_prima";
$limite = mysql_query("$sql");
while ($sql = mysql_fetch_array($limite) ) {
$data = $sql["data"];
$lote = $sql["lote"];
$material = $sql["material"];
$cor = $sql["cor"];
$quantidade = $sql["quantidade"];
$prazo = $sql["prazo"];
echo "<div id=\"testeID\">
Data: $data<br> Lote: $lote<br> Material: $material<br> Cor: $cor<br> Quantidade: $quantidade Kilos<br> Previsão de entrega: $prazo<br><a href=\"#\">Editar</a>
</div>";
}
?>
</body>
但是,现在我想像这样将回显数据放入HTML中:
But, now I wanna put the echo data into the HTML like this:
<div>
Data: <p><?php echo $data ?></p>
<br /><br />
Lote: <p><?php echo $lote ?></p>
<br /><br />
Material: <p><?php echo $material ?></p>
<br /><br />
Cor: <p><?php echo $cor ?></p>
<br /><br />
Quantidade: <p><?php echo $quantidade ?></p>
<br /><br />
Prazo: <p><?php echo $prazo ?></p>
</div>
它也可以正常工作,但是只返回最后一个MySQL条目.如何显示所有条目?
It works fine too, but just return the last MySQL entry. How do I show all the entries?
推荐答案
先获取数据,然后再获取HTML模板
Get your data first, and then start for HTML template
<?php
require("conexaoBD.php");
$sql = "SELECT * FROM tb_materia_prima";
$limite = mysql_query($sql);
$data = array();
while ($sql = mysql_fetch_array($limite) ) {
$data[] = $sql;
}
?>
<body>
<?php foreach ($data as $row): ?>
<div id="testeID">
Data: <?=$row['data']?><br>
Lote: <?=$row['lote']?><br>
Material: <?=$row['material']?><br>
Cor: <?=$row['cor']?><br>
Quantidade: <?=$row['quantidade']?> Kilos<br>
Previsão de entrega: <?=$row['prazo']?><br>
<a href="#">Editar</a>
</div>
<?php endforeach ?>
</body>
不过,最好使用 PDO
<?php
require("conexaoBD.php");
$sql = "SELECT * FROM tb_materia_prima";
$stm = $pdo->prepare($sql);
$stm->execute();
$data = $stm->fetchAll();
?>
当然,模板部分将保持不变. 这就是模板的重点:更改程序逻辑时,模板将保持不变.反之亦然
of course, the template part will remain the same. That's the very point of the templates: while changing your program logic, your template will remain the same. The opposite is true as well
这篇关于MySQL数据导入模板的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文