How to insert image in mysql database using PHP source code..?

Question

1.00/5 (1 vote)

See more:

<?php
mysql_connect("localhost", "root","") or die ("could not connect to the server");
mysql_select_db("demodemo") or die ("that database could not be found");

$file = $_FILES['image']['tmp_name'];

$image= addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name = addslashes($_FILES['image']['name']);
$image_size = getimagesize($_FILES['image']['tmp_name']);

mysql_query("INSERT INTO image (id,image) VALUES ('1','{$image}')");
?>

What I have tried:

i have a tried..

<?php
mysql_connect("localhost", "root","") or die ("could not connect to the server");
mysql_select_db("demodemo") or die ("that database could not be found");

$file = $_FILES['image']['tmp_name'];

$image= addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name = addslashes($_FILES['image']['name']);
$image_size = getimagesize($_FILES['image']['tmp_name']);

mysql_query("INSERT INTO image (id,image) VALUES ('1','{$image}')");
?>

Posted 19-Jun-18 1:41am

Dipak384

Updated 18-May-23 1:30am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ishan_shah · Answer 1 · 2020-04-08T20:40:00

You can be done it using the following code after connected to database successfully :

PHP

if(isset($_POST['btnSubmit'])){

    $target_dir = "uploads/";
    $target_file = $target_dir . basename($_FILES["image"]["name"]);
    $uploadOk = 1;
    $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);

    if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["image"]["name"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }

    $image=basename( $_FILES["image"]["name"],".jpg");
    $query= "INSERT INTO image(id,image) VALUES ('1','$image')";
    mysql_query($query);
    echo "Data Successfully Inserted";
}

Gilles Migliori (migli) · Answer 2 · 2020-03-16T23:53:00

Hi,

Storing your image data in your database is really not a good idea. Your database will become heavy with just a few images.

Usually the logic is to upload the image with PHP, then record only the filename in the database. PHP can generate thumbnails on the fly too, what you cannot do if you store the image in a BLOB field.

This said, here's the code, in case there would be a very unique special reason you still want to save BLOB data:

PHP

$fp = fopen($_FILES['image']['tmp_name'], 'r');
$filename = $_FILES['image']['name'];
$content = fread($fp, $_FILES['image']['tmp_name']);
// Insert into blob
$query = "INSERT INTO image (id, image) VALUES ('$filename', '$content')";

himanshi_gorsiya · Answer 3 · 2023-05-18T01:30:00

Solution 5

for insert:-
$image = $_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'], "image/" . $image);
$qry = "INSERT INTO dbname(image) values ( '$image')";

for more query contact on my ig:-thehiyaa or himanshigorsiya@gmail.com

Posted 18-May-23 1:30am

himanshi_gorsiya

Updated 18-May-23 1:32am

v2

Comments

Richard Deeming 18-May-23 8:48am

As with the code in the original question, your code is vulnerable to SQL Injection[^]. NEVER use string concatenation/interpolation to build a SQL query. ALWAYS use a parameterized query.

PHP: SQL Injection - Manual[^]

How to insert image in mysql database using PHP source code..?

3 solutions

Solution 4

Solution 3

Solution 5

Add your solution here

Preview 0