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 安装svn网络有问题怎么办
  • ¥15 Python爬取指定微博话题下的内容,保存为txt
  • ¥15 vue2登录调用后端接口如何实现
  • ¥65 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥15 latex怎么处理论文引理引用参考文献