如何上传图片和存储在数据库中

Question

$image = file_get_contents($_FILES['image']['tmp_name']);

$image = mysql_real_escape_string($image);


mysql_query("UPDATE ngc set pic='" . $image "' WHERE username='" . $_SESSION["username"] . "'");


<form method="post" action="" enctype="multipart/form-data">

Upload Image :<input type="file" name="image" id="file">
<br><input type="submit" name="submit" value="Update!" class="btnSubmit">

</form>

i want to upload image to database..

Answer 1

Read this very nice example here: http://www.mysqltutorial.org/php-mysql-blob/ Also see this image gallery example here: http://www.anyexample.com/programming/php/php_mysql_example__image_gallery_(blob_storage).xml

BLOBs are data types in MySql database which can help you store image files in database directly.

Although a better way would be to store the file on the disk and store the path of that variable in the database.