Home >Backend Development >PHP Problem >How to display pictures in database in php

How to display pictures in database in php

(*-*)浩
(*-*)浩Original
2019-09-29 13:30:238419browse

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:

How to display pictures in database in php

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)

How to display pictures in database in phpThe 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     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:

How to display pictures in database in php

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn