php image not uploading to database

Question

I'm trying to upload an image to a database using a form.

The problems is that when i try to upload the image, it isn't stored in the database. Also there is no error.

Thanks in advance.

<html>
<head>
    <meta charset="UTF-8" />
    <title>Images</title>
</head>
<body>
    <form action="index.php" method="POST" enctype="multipart/form-data">
        File:
        <input type="file" name="image" />
        <input type="submit" value="Upload" />
    </form>
    <?php
        require "connect.inc.php";
        @$file = $_FILES['image']['tmp_name'];

        if (!isset($file)) {
            echo "Please select an image.";
        }
        else {
            $image = file_get_contents($_FILES['image']['tmp_name']);
            $imageName = $_FILES['image']['tmp_name'];
            $imageSize = getimagesize($_FILES['image']['tmp_name']);

            if ($imageSize == FALSE) {
                echo "This is not an image.";
            }
            else {
                $sql = "INSERT INTO `afbeelding` VALUES ('', '$imageName', '$image')";
                if (!mysql_query("INSERT INTO `afbeelding` VALUES ('', '$imageName', '$image')")) {
                    echo "Problem uploading image.";
                } 
                else {
                    echo "Succes!";
                }
            }
        }
    ?>
</body>
</html>

This should help you. http://stackoverflow.com/questions/17717506/how-to-upload-images-into-mysql-database-using-php-code — momouu, Dec 10 '15 at 10:53
DO you want to upload, image or just to save name into database? — Gaurav Rai, Dec 10 '15 at 11:06
I just figured it out. The link from monaca19 showed addslashes and somehow adding that worked. — IvoryNL, Dec 10 '15 at 11:22

score 0 · Answer 1 · answered Dec 10 '15 at 11:01

You have forgot to execute your query :

<html>
<head>
    <meta charset="UTF-8" />
    <title>Images</title>
</head>
<body>
    <form action="index.php" method="POST" enctype="multipart/form-data">
        File:
        <input type="file" name="image" />
        <input type="submit" value="Upload" />
    </form>
    <?php
        require "connect.inc.php";
        @$file = $_FILES['image']['name'];

        if (!isset($file)) {
            echo "Please select an image.";
        }
        else {
            $image = file_get_contents($_FILES['image']['name']);
            $imageName = $_FILES['image']['tmp_name'];
            $img = $_FILES['image']['name'];
            $imageSize = getimagesize($_FILES['image']['name']);
//add move uploaded file function here

            if ($imageSize == FALSE) {
                echo "This is not an image.";
            }
            else {
                $sql = mysql_query("INSERT INTO `afbeelding` VALUES ('', '$img', '$image')"); // did changes here
               if($sql){
                   echo "Succes!";
                } 
                else {
                   echo "Problem uploading image.";
                }
            }
        }
    ?>
</body>
</html>

score 0 · Answer 2 · answered Dec 10 '15 at 11:04

I have not tested, but will work

<?php
require "connect.inc.php";
if(isset($_POST['submit']))
{
    @$file = $_FILES['image']['tmp_name'];

    if (!isset($file)) {
        echo "Please select an image.";
    }
    else {
        $image = file_get_contents($_FILES['image']['tmp_name']);
        $imageName = $_FILES['image']['tmp_name'];
        $imageSize = getimagesize($_FILES['image']['tmp_name']);

        if ($imageSize == FALSE) {
            echo "This is not an image.";
        }
        else {
            $sql = "INSERT INTO `afbeelding` VALUES ('', '$imageName', '$image')";
            if (!mysql_query("INSERT INTO `afbeelding` VALUES ('', '$imageName', '$image')")) {
                echo "Problem uploading image.";
            } 
            else {
                echo "Succes!";
            }
        }
    }
}
    ?>
<html>
<head>
    <meta charset="UTF-8" />
    <title>Images</title>
</head>
<body>
    <form action="index.php" method="POST" enctype="multipart/form-data">
        File:
        <input type="file" name="image" />
        <input type="submit" name="submit" value="Upload" />
    </form>

</body>
</html>

Code is not to upload file on server, just to insert image name into database — Gaurav Rai, Dec 10 '15 at 11:08

score 0 · Answer 3 · answered Dec 10 '15 at 11:23

0

The problem was not having the addslashes(). In: $image = addslashes(file_get_contents($_FILES['image']['tmp_name']));

If i remove them again it won't work but if i put them back in it succeeds.

answered Dec 10 '15 at 11:23

IvoryNL

41
1
9

php image not uploading to database

3 Answers3

Linked