使用路径文件夹在数据库中回显图像 - echo image in database using path folder,

echo image in database using path folder,

<?php
       //connect to mysql and select database
 mysql_connect('localhost', 'root', '') or die('Could not connect: ' . mysql_error());
 mysql_select_db('4dberlin') or die("Can not select database");

 //fetch data from MySQL
 $result = mysql_query("select * from photos ");
 //iterate over each row and do what you want.
 while($row = mysql_fetch_array($result))
 {
      $location = $row['image'];
    echo "<img src='" . $row['image'] . "' height='130' width='220'> ";
 }
     ?>

我的图像在本地主机/管理员/上传中的路径。我不知道为什么不显示我的图像。

根据您的

问题，似乎$row['image']包含图像名称。

所以你的代码应该看起来像

while($row = mysql_fetch_array($result))
 {
      $location = $row['image'];
    echo "<img src='http://localhost/admin/uploads/" . $row['image'] . "' height='130' width='220'> ";
 }

其中http://localhost/admin/uploads/是映像存储的路径。

试试这个

<?php
   //connect to mysql and select database

mysql_connect('localhost', 'root', '') or die('Could not connect: ' . mysql_error());

mysql_select_db('4dberlin') or die("Can not select database");
//fetch data from MySQL

$result = mysql_query("select * from photos ");

//iterate over each row and do what you want.

while($row = mysql_fetch_array($result))
 {
  $location = $row['image'];
echo "<img src='admin/uploads/" . $row['image'] . "' height='130' width='220'> ";
 }
 ?>