doupu9251 2017-11-13 11:51
浏览 36

如何显示php echo产生不同的样式?

I have 2 php echo results from my mysql database. Their request is common and wrapped into one line :

$sql = "SELECT * FROM test WHERE id IN ('9','10')";

I want only the first result to be displayed in h3 style, and the second result to be displayed in normal p style. Using the code below the 2 results are displayed in h3 style.

How do I fix it ?

Thank you in advance.

enter code here

<div class="one-third wow fadeIn">
<span class="circle"><span class="ico pig"></span></span>
<h3>

<?php
$conn = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
if ($conn->connect_error)
{
echo "connection error" ;
}

$sql = "SELECT * FROM test WHERE id IN ('9','10')";
$result = $conn->query($sql);

?>
<?php
if ($result->num_rows > 0) { while($data = $result->fetch_assoc())
{echo $data ['FR']."<br>"; }    } else {echo "---"; }?></h3>
<p>
  • 写回答

1条回答 默认 最新

  • dongzhaoshi8497 2017-11-13 12:00
    关注

    Try this

        <?php
            $conn = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
            if ($conn->connect_error)
            {
                    echo "connection error" ;
            }
            $sql = "SELECT * FROM test WHERE id IN ('9','10')";
            $result = $conn->query($sql);
        ?>
        <?php
        $i = 0;
        if ($result->num_rows > 0) { 
                while($data = $result->fetch_assoc()){
                      if($i == 0){
                            echo "<h3>".$data ['FR']."<br></h3>"; 
                        }else{
                            echo "<p>".$data ['FR']."<br></p>"; 
                        }
                         $i++;
                }    
        } else {
            echo "---"; 
        }
        ?>
    
    评论

报告相同问题?

悬赏问题

  • ¥20 易康econgnition精度验证
  • ¥15 线程问题判断多次进入
  • ¥15 msix packaging tool打包问题
  • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致