How to display pictures in database in php

Whether it is website design, office system, or shopping mall, pictures need to be displayed on the web page. The pictures are extracted from the database. Next, let’s take a look at how to save and display pictures through the picture path:

First, save the path of the image in the table. Note: the path is to be found from the WWW directory instead of from the disk root , / represents the WWW directory : (Recommended learning: PHP video tutorial)

The img in the table is the path to the stored image, which is the path under the WWW directory. Since the path is stored in the table , then we can get it through PHP linking to the database:

<?php
    require "DBDA.class.php";//调用封装类
    $db = new DBDA();
    $sql = "select * from book";
    $arr= $db->query($sql);
    foreach($arr as $v) // 遍历出各个列的内容
    {
        //图片用img标签获取路径，因为遍历出的img是$v[5]，所以路径就是$v[5]
        echo "<div id=&#39;hang&#39;><a href=&#39;gouwu.php?bkid={$v[0]}&#39;><img  src="/static/imghw/default1.png"  data-src="https://img.php.cn/upload/image/368/906/357/1569734866894326.png"  class="lazy"     style="max-width:90%"How to display pictures in database in php" ></a>
              <div class=&#39;jg&#39;><a href=&#39;gouwu.php?bkid={$v[0]}&#39;>{$v[1]}</a></div>
              <div class=&#39;jg&#39; style=&#39;color:red&#39;>{$v[3]}元</div>
              </div>
              ";
              
    }

?>

In this way, we can get the picture through the path, which is very convenient and efficient:

The above is the detailed content of How to display pictures in database in php. For more information, please follow other related articles on the PHP Chinese website!