dqm4675 2019-07-04 09:23
浏览 70
已采纳

如何在sql表的右栏中显示图像?

I am inserting values to an sql table and displaying it through AJAX. The values get displayed properly but the image does not come in the right column, instead it comes on top. Why does this happen?

Although the image is shown in the webpage, it is however aligned in different position. enter image description here

<?php
...
...
...
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
 $output .= '
  <div class="table-responsive">
   <table class="table table bordered">
    <tr>
     <th>ID</th>
     <th>Name</th>
     <th>Time</th>
     <th>Img</th>
    </tr>
 ';
 while($row = mysqli_fetch_array($result))
 {
  $output .= '
   <tr>
    <td>'.$row["ID"].'</td>
    <td>'.$row["Name"].'</td>
    <td>'.$row["Time"].'</td>
    <td>' ?> <img src="<?php echo $row['Img']; ?>" alt="my picture" height="100" width="100" /> <?php '</td>  //Here is the problem where I am trying to display the image
   </tr>
  ';

 }
 echo $output;
}
else
{
 echo 'Data Not Found';
}

?>

  • 写回答

1条回答 默认 最新

  • duanbinmi8970 2019-07-04 09:39
    关注
    if(mysqli_num_rows($result) > 0)
    {
     $output .= '
      <div class="table-responsive">
       <table class="table table bordered">
        <tr>
         <th>ID</th>
         <th>Name</th>
         <th>Time</th>
         <th>Img</th>
        </tr>
     ';
     while($row = mysqli_fetch_array($result))
     {
      $output .= '
       <tr>
        <td>'.$row["ID"].'</td>
        <td>'.$row["Name"].'</td>
        <td>'.$row["Time"].'</td>
        <td> <img src="' .$row["Img"] . '" alt="my picture" height="100" width="100" /> </td>  //Here is the problem where I am trying to display the image
       </tr>';
     }
     $output .= '</table></div>';
     echo $output;
    }
    else
    {
     echo 'Data Not Found';
    }
    

    try this way.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 使用Java milo连接Kepserver服务端报错?
  • ¥15 用ADS设计一款的射频功率放大器
  • ¥15 怎么求交点连线的理论解?
  • ¥20 软件开发方法学习来了
  • ¥15 微信小程序商城如何实现多商户收款 平台分润抽成
  • ¥15 HC32L176调试了一个通过TIMER5+DMA驱动WS2812B
  • ¥15 cocos的js代码调用wx.createUseInfoButton问题!
  • ¥15 关于自相关函数法和周期图法实现对随机信号的功率谱估计的matlab程序运行的问题,请各位专家解答!