在数据库mysql php中存储和检索图像路径 [英] Storing and Retrieving image path in database mysql php

问题描述

我正在使用PHP，mysql和phpmyadmin开发一个网站。我有一些数据库，我想用html使用PHP和mysql检索它。我想知道如何从数据库中存储和检索图像路径并显示它。我在互联网上看到有一种方法，比如使用文件系统存储和检索图像或者将我的笔记本电脑作为服务器。
什么是最好的方式和方式？
我将不胜感激任何帮助，谢谢。

I am developing a website using PHP, mysql and phpmyadmin. I have some database that I what want to retrieve it in html using PHP and mysql. I want to know how I can store and retrieve image paths from database and display it. I saw on the internet that there is a way, such as using the filesystem to store and retrieve images or making my laptop a server. what is the best way and how? I would be grateful for any help, Thanks.

推荐答案

因为你没有正确描述你的问题或没有提供任何代码。
所以，我以我的方式提出了你的问题并发布了我的答案。
按照步骤操作。

Since, you didn't described your question properly or didn't provided any code. So, i assumed your question in my way and posted my answer. Follow the step.

1）用于上传图片

1) For Uploading Image

<form method='POST' action='UploadImage.php' enctype="multipart/form-data">
    <input type='file' name='UploadImage'>
    <input type='submit' value="submit">
</form>

假设您的项目文件夹名称为：MyProject（所有项目文件都存在），
在MyProject文件夹中创建一个文件夹，即MyUploadImages
现在，

Suppose your Project Folder Name Is : MyProject (Where all project files are present), Make one folder inside "MyProject" Folder namely "MyUploadImages" Now,

UploadImage.php

<?php
include('connect.php'); // Do Database Connection in this file (create a file namely connect.php inside MyProject Folder)
extract($_POST);

$UploadedFileName=$_FILES['UploadImage']['name'];
if($UploadedFileName!='')
{
  $upload_directory = "MyUploadImages/"; //This is the folder which you created just now
  $TargetPath=time().$UploadedFileName;
  if(move_uploaded_file($_FILES['files']['tmp_name'], $upload_directory.$TargetPath)){    
    $QueryInsertFile="INSERT INTO TableName SET ImageColumnName='$TargetPath'"; 
    // Write Mysql Query Here to insert this $QueryInsertFile   .                   
  }
}
?>

现在，在数据库表中，您可以找到ImageColumnName，将图像路径设置为MyUploadImages / 1417Flower。 jpg

Now, In your Database Table, you can find ImageColumnName that image path is set as MyUploadImages/1417Flower.jpg

2）从数据库中恢复图像

2) Retreiving Image from database

AnyPage.php

<?
$Query="SELECT * FROM TableName";
// Write mysql query to fetch $Query

store that ImageColumnName value to any variable say $MyPhoto.
?>

<img src="<?echo $MyPhoto;?>">

这篇关于在数据库mysql php中存储和检索图像路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！