blocks|key|1206375|text|首先，创建一个MySQL表来存储图像，例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1206376|create+table+testblob+(
++++image_id++++++++tinyint(3)++not+null+default+'0',
++++image_type++++++varchar(25)+not+null+default+'',
++++image+++++++++++blob++++++++not+null,
++++image_size++++++varchar(25)+not+null+default+'',
++++image_ctgy++++++varchar(25)+not+null+default+'',
++++image_name++++++varchar(50)+not+null+default+''
);|code-block|syntax|javascript|1206377|然后，您可以将图像写入数据库，如下所示：|1206378|/***
+*+All+of+the+below+MySQL_+commands+can+be+easily
+*+translated+to+MySQLi_+with+the+additions+as+commented
+***/+
$imgData+=+file_get_contents($filename);
$size+=+getimagesize($filename);
mysql_connect("localhost",+"$username",+"$password");
mysql_select_db+("$dbname");
//+mysqli+
//+$link+=+mysqli_connect("localhost",+$username,+$password,$dbname);+
$sql+=+sprintf("INSERT+INTO+testblob
++++(image_type,+image,+image_size,+image_name)
++++VALUES
++++('%25s',+'%25s',+'%25d',+'%25s')",
++++/***
+++++*+For+all+mysqli_+functions+below,+the+syntax+is:
+++++*+mysqli_whartever($link,+$functionContents);+
+++++***/
++++mysql_real_escape_string($size['mime']),
++++mysql_real_escape_string($imgData),
++++$size[3],
++++mysql_real_escape_string($_FILES['userfile']['name'])
++++);
mysql_query($sql);|1206379|您可以使用以下命令在网页中显示数据库中的图像：|1206380|$link+=+mysql_connect("localhost",+"username",+"password");
mysql_select_db("testblob");
$sql+=+"SELECT+image+FROM+testblob+WHERE+image_id=0";
$result+=+mysql_query("$sql");
header("Content-type:+image/jpeg");
echo+mysql_result($result,+0);
mysql_close($link);|1206381|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

First you create a MySQL table to store images, like for example:

<pre><code>create table testblob (
 image_id tinyint(3) not null default '0',
 image_type varchar(25) not null default '',
 image blob not null,
 image_size varchar(25) not null default '',
 image_ctgy varchar(25) not null default '',
 image_name varchar(50) not null default ''
);
</code></pre>

Then you can write an image to the database like:

<pre><code>/***
 * All of the below MySQL_ commands can be easily
 * translated to MySQLi_ with the additions as commented
 ***/ 
$imgData = file_get_contents($filename);
$size = getimagesize($filename);
mysql_connect("localhost", "$username", "$password");
mysql_select_db ("$dbname");
// mysqli 
// $link = mysqli_connect("localhost", $username, $password,$dbname); 
$sql = sprintf("INSERT INTO testblob
 (image_type, image, image_size, image_name)
 VALUES
 ('%s', '%s', '%d', '%s')",
 /***
 * For all mysqli_ functions below, the syntax is:
 * mysqli_whartever($link, $functionContents); 
 ***/
 mysql_real_escape_string($size['mime']),
 mysql_real_escape_string($imgData),
 $size[3],
 mysql_real_escape_string($_FILES['userfile']['name'])
 );
mysql_query($sql);
</code></pre>

You can display an image from the database in a web page with:

<pre><code>$link = mysql_connect("localhost", "username", "password");
mysql_select_db("testblob");
$sql = "SELECT image FROM testblob WHERE image_id=0";
$result = mysql_query("$sql");
header("Content-type: image/jpeg");
echo mysql_result($result, 0);
mysql_close($link);
</code></pre>

blocks|key|1421514|text|我还建议仔细考虑一下，然后选择将图像存储在您的文件系统中，而不是DB中。查看此处：Storing+Images+in+DB+-+Yea+or+Nay?|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1421515|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay^0|15|Y|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

i also recommend thinking this thru and then choosing to store images in your file system rather than the DB .. 
see here: <a href="https://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay">Storing Images in DB - Yea or Nay?</a>

blocks|key|1206509|text|就我个人而言，我不会将图像存储在数据库中，而是将其放在一个无法从外部访问的文件夹中，并使用数据库来跟踪其位置。保持较小的数据库大小，您可以通过使用PHP将其包含在内。如果没有PHP，将无法访问该图像|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1206510|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Personally i wouldnt store the image in the database, Instead put it in a folder not accessable from outside, and use the database for keeping track of its location. keeps database size down and you can just include it by using PHP. There would be no way without PHP to access that image then

blocks|key|1421633|text|不是将图像存储在数据库中，而是将它们存储在磁盘文件夹中，并将它们的位置存储在数据库中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1421634|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Instead of storing images in database store them in a folder in your disk and store their location in your data base.

blocks|key|1421685|text|不是将图像存储在数据库中，而是将其存储在手机和pc中，并使用其路径，因为它将保存您的数据库|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1421686|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

instead of storing image in the database, store it in your phone and pc and just use its path as it will save your database

How can I insert an image in MySQL and then retrieve it using PHP?

I have limited experience in either area, and I could use a little code to get me started in figuring this out.

How can I store and retrieve images from a MySQL database using PHP?

如何在MySQL中插入图像，然后使用PHP检索它？我在这两个领域的经验都有限，我可以使用一些代码来开始弄清楚这一点。

问如何使用PHP从MySQL数据库中存储和检索图像？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PHP从MySQL数据库中存储和检索图像？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PHP从MySQL数据库中存储和检索图像？
EN