显示存储在 mysql 中的路径中的图像


Display Image from the path stored in mysql

我已经将图像上传到文件夹中并将路径存储到MySQL数据库中。路径已存储,图像已成功插入到文件夹中。但是我的问题是当我从存储在 db 中的路径显示图像时。它不显示。当我回显图像路径时,它会显示图像路径。我检查了我的浏览器设置,一切都很好。这是我的代码。请任何人帮忙。

$up=move_uploaded_file($_FILES['profile']['tmp_name'],dirname($_SERVER['DOCUMENT_ROOT']).'/htdocs/upload/image/'.$name);
$path = dirname($_SERVER['DOCUMENT_ROOT']).'/htdocs/upload/image/';
$location = $path . $_FILES['profile']['name'];
$ins=mysqli_query($con, "INSERT into image (url) values ('$location')");
echo 'image uploaded and stored';
echo "$location"; //It displays D:/xampp/htdocs/upload/image/Chrysanthemum.jpg
echo '<img width="250" height="250" src= "'.$location.'"/>';//It doesn't display anything.

试试这个:

尝试使用relative path而不是absolute path。相对路径可帮助您从任何服务器、任何目录运行脚本。

$path = 'upload/image/';
$location = $path . $_FILES['profile']['name'];
move_uploaded_file($_FILES['profile']['tmp_name'], $location);
$ins = mysqli_query($con, "INSERT into image (url) values ('$location')");
echo 'image uploaded and stored';
echo '<img width="250" height="250" src= "'.$location.'"/>';

注意:您需要在同一文件夹中upload/image文件夹名称 运行脚本的目录。根据您的要求,您想显示来自 mysql 的图像,但没有这样做,为此您需要再次查询表。

嘿,

您可以使用以下代码在目录中获取上传图像的路径 此代码将显示您的图像

$location ='/upload/image/'. $_FILES['profile']['name']; // write your project dir name before upload if "upload is not your project dir"
$ins=mysqli_query($con, "INSERT into image (url) values ('$location')");
echo 'image uploaded and stored';
echo '<img width="250" height="250" src= "'.$location.'"/>';//It doesn't display anything.