时间戳

首页 > 解决方案 > 在页面上显示来自数据库的照片的问题

php - 在页面上显示来自数据库的照片的问题

问题描述

我在页面上显示数据库中的照片时遇到问题。我在数据库列 image_src = "../GameForest/gamephoto/gta5.jpg" 中创建了一个路径。而且路径是正确的，我检查了几次。

//这是一个显示数据库中所有数据的类

<?php
    class Game extends Dbh {

        public function gameDiv() {
            $id = $_GET['id'];
            $stmt = $this->connect()->query("SELECT g.game_id, g.game_name, g.image_src, g.genre_id, g.developer_id, g.release_date, g.platfrom_id, g.game_price,  g.game_description, g.processor, g.graphic, g.ram\n" . "FROM game AS g\n" . "LEFT JOIN genre AS z\n" . "ON g.genre_id = z.id WHERE game_id = '$id'");
            while ($row = $stmt->fetch()) {

                echo "<div class='gameName'><h2>" . $row['game_name'] . "</h2></div>";

                echo "<div class='buying'><p>" . $row['game_price'] . "&euro;</p><a href='bought.php'><button>Buy Game</button></a></div>";


//This next echo is for displaying photo from database:
                echo "<div class='gamePhoto'><img>" . $row['image_src'] . "</img></div>";

                echo "<div class='gameGenre'><b>Genre: </b><p>" . $row['genre_id'] . "</p></div>";

                echo "<div class='gameDeveloper'><b>Created by: </b><p>" . $row['developer_id'] . "</p></div>";

                echo "<div class='gamePlatform'><b>Platform: </b><p>" . $row['platfrom_id'] . "</p></div>";

                echo "<div class='gameRdate'><b>Release date: </b><p>" . $row['release_date'] . "</p></div>";

                echo "<div class='gameDescription'><b>Description: </b><p>" . $row['game_description'] . "</p></div>";

                echo "<div class='sysRequirements'><p>Recommended System Requirements:</p><b>Processor:</b><p>" . $row['processor'] . "</p>" . "  Heading <b>Graphic:</b><p>" . $row['graphic'] . "</p>" . " <b>RAM:</b><p>" . $row['ram'] . "</p>";
            }
        }
}

**//This is instance for previous class:**
<?php
    #istance for printing information about a Game
    $game = new Game;
    echo $game->gameDiv();
?>

**//This is CSS code of that photo:**

.gamePhoto {
        margin: 10px 0 20px 10%;
        width: 200px;
        height: 400px;
        float: left;
    }

    .gamePhoto img {
        width: 500px;
        height: 600px;    
    }

?>

我希望有一张来自数据库的图片，但我只得到一个灰色框架，其中图像实际上应该低于它写的“../GameForest/gamephoto/gta5.jpg”（我在基础中写的路径）。其余的数据库数据显示正常，只是图像有问题。在另一个页面（和其他类）上，来自同一个数据库的相同图片正常显示，我没有问题。

标签： phpcsssql

解决方案

img 是内联块，像这样使用<img src="" />

推荐阅读