如何使用PHP显示数据库中的照片？ [英] How to display photo from database using PHP?
问题描述
我很难弄清楚如何使用php显示数据库中的照片。所以，除了显示文本之外，我还能成功地将文本和照片添加到数据库中，但是我无法从数据库中显示我的照片。我有一种感觉，这与我无法将任何上传的照片添加到我的图像文件夹或该文件夹的路径不正确这一事实有关。请看下面我的代码，如果我能得到一些帮助那就太棒了：
这是我的uploadtest.php文件：
<？php
if（isset（$ _ POST ['upload']））{//如果按下上传按钮< br $> b $ b
//存储上传图片的路径
$ target =images /。basename（$ _FILES ['image'] ['name']）;
//连接数据库
$ conn = mysqli_connect（'127.0.0.1'，'root'，''，'photos'）;
//从表格中获取所有提交的数据
$ image = $ _ FILES ['image'] ['name'];
$ text = $ _ POST ['text'];
$ sql =INSERT INTO images（image，text）VALUES（'$ image'，'$ text' ）;
mysqli_query（$ conn，$ sql）; //将数据存储到数据库表图像中
//将上传的图像移动到文件夹中
if（move_uploaded_file（$ _ FILES ['image' ] ['tmp_name']。$ target，images /））{
$ msg =图片上传成功。;
}其他{
$ msg =上传图片时出现问题;
}
}
？>
<！DOCTYPE html>
< title>图片上传
< meta charset =UTF-8>
< meta name =viewportcontent =width = device-width，initial-scale = 1.0>
Hi,
I am having a hard time figuring out how to display photos from the database using php. So, far I can successfully add text and photos into the database, in addition to displaying the text, however I am just not able to display my photos from the database. I have a feeling that it has to do with the fact that I am not able to add any of the uploaded photos into my images folder or the path to this folder is not correct. Please see my code below, and it would be great if I could get some help:
Here is my uploadtest.php file:
<?php
if(isset($_POST['upload'])){//if upload button is pressed
//the path to store uploaded images
$target = "images/" .basename($_FILES['image']['name']);
//connect to database
$conn = mysqli_connect('127.0.0.1', 'root', '', 'photos');
// get all the submitted data from the form
$image=$_FILES['image']['name'];
$text =$_POST['text'];
$sql ="INSERT INTO images (image, text) VALUES ('$image', '$text')";
mysqli_query($conn, $sql); //stores data into database table images
//lets move uploaded image into folder
if(move_uploaded_file($_FILES['image']['tmp_name']. $target, "images/")){
$msg="Image uploaded successfully.";
}else{
$msg="There was a problem uploading the image";
}
}
?>
<!DOCTYPE html>
<title>Image upload
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<？php
$ conn = mysqli_connect（'127.0.0.1'，'root'， ''， '相片'）;
$ sql =SELECT * FROM images;
$ result = mysqli_query（$ conn，$ sql）;
while（$ row = mysqli_fetch_array（$ result））{
echo
<?php
$conn = mysqli_connect('127.0.0.1', 'root', '', 'photos');
$sql="SELECT * FROM images";
$result = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($result)){
echo "
echo< img src ='images /'\".$ row ['image']。'>;
echo
。$ row ['text']。
echo "<img src='images/'".$row['image']."'>";
echo "
".$row['text']."
;
}
？>
";
}
?>
这是我的css文件：
#content {
宽度：50％;
保证金：20px auto;
border ：1px solid #cbcbcb;
}
表格{
宽度：50％;
保证金：20px auto ;
}
表格div {
margin-top：5px;
}
#img_div {
宽度：80％;
填充：5px;
保证金：15px auto;
边框：1px solid #cbcbcb;
}
#img_div：在{
内容：;
$ b $之后b显示：块;
清除：两者;
}
img {
float：left;
保证金：5px;
宽度：300px;
身高：140px
}
再次感谢！
我的尝试：
我一直在观看很多youtube视频，但我仍然在努力解决这个问题。
And here is my css file:
#content{
width:50%;
margin:20px auto;
border:1px solid #cbcbcb;
}
form{
width:50%;
margin:20px auto;
}
form div{
margin-top:5px;
}
#img_div{
width:80%;
padding:5px;
margin:15px auto;
border:1px solid #cbcbcb;
}
#img_div:after{
content:"";
display:block;
clear:both;
}
img{
float:left;
margin:5px;
width:300px;
height:140px
}
Thanks again!
What I have tried:
I have been watching many youtube videos but am still struggling with this problem.
推荐答案
_POST ['upload']））{//如果uploa按下d按钮
//存储上传图像的路径
_POST['upload'])){//if upload button is pressed
//the path to store uploaded images
target =images /。basename（
target = "images/" .basename(
_FILES ['image'] ['name']）;
//连接数据库
_FILES['image']['name']);
//connect to database
这篇关于如何使用PHP显示数据库中的照片？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
