douji8017 2018-05-20 18:26
浏览 41
已采纳

如何在行中显示MySQL数据?

So I have a code in PHP to display MySQL database information. This is the PHP code:

<?php
$servidor = mysqli_connect ("localhost","root","");
mysqli_select_db($servidor, "produtos");

if (isset($_GET['texto'])) {
    $pesquisa = $_GET['texto'];
    $query = mysqli_query($servidor, "SELECT * FROM produtos WHERE Nome LIKE '%$pesquisa%' OR Referencia LIKE '%$pesquisa%'");

    if(mysqli_num_rows($query) > 0) {
        while($resultados = mysqli_fetch_array($query)) {
            echo "<h3>Nome: ".$resultados['Nome']."</h3>Referência: ".$resultados['Referencia']."";
        }
    } else {
        echo "<h3>Não foram encontrados resultados!</h3>";
    }
}
?>

But right now, that information is displayed in one single line, like this:

enter image description here

and I want to display it in rows, like this:

enter image description here

How can I do this in PHP?

Thank you

  • 写回答

2条回答 默认 最新

  • dongtangu8403 2018-05-20 18:35
    关注

    This part can be achieved usign HTML + CSS as @Bernhard said. Or, something that I DON'T RECOMMEND, like this:

    <div style="width:25%;float:left;padding:10px;">{item}</div>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
  • ¥15 ETLCloud 处理json多层级问题
  • ¥15 matlab中使用gurobi时报错
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么