Adding image to mysql using php

Question

Hello and thank you for taking the time to read this. I am having trouble saving my image to the database. The input from the comment which is a string and the input from the rating will go in but the image will not save to my database. trying to create a site that will take images from someone who is rating their haircut. The code i have come up with is below.

<form method="post" id = "bodyContainer" enctype="multipart/form-data">
<img src="" name="image" id="image"/>
<br/>
<input style="float:right;"type="file" name="dataFile" id="fileChooser" onchange="return ValidateFileUpload()" />

<SCRIPT type="text/javascript">
    function ValidateFileUpload() {
        var fuData = document.getElementById('fileChooser');
        var FileUploadPath = fuData.value;

    //To check if user upload any file
        if (FileUploadPath == '') {
            alert("Please upload an image");

        }   else {
                var Extension = FileUploadPath.substring(FileUploadPath.lastIndexOf('.') + 1).toLowerCase();

                //The file uploaded is an image
                if (Extension == "gif" || Extension == "png" || Extension == "bmp" || Extension == "jpeg" || Extension == "jpg") {

                // To Display
                    if (fuData.files && fuData.files[0]) {
                        var reader = new FileReader();

                        reader.onload = function(e) {
                            $('#image').attr('src', e.target.result);
                        }

                        reader.readAsDataURL(fuData.files[0]);
                    }

                } 

                //The file upload is NOT an image
                else {
                    alert("Photo only allows file types of GIF, PNG, JPG, JPEG and BMP. ");

                }
            }
    }
</SCRIPT>   

<textarea id="comment" name="comment" placeholder="Your comment..."></textarea><br/>
<input type="range" name="rating" min="1" max="5" id="rating"/><br/>
<input type="submit" name="submit" value="Submit" id="submitButton"/><br/>

The main issue i believe arises from the php that adds the code to the database below.

<?php
    if (isset($_POST['submit'])) {
        if ($_POST['comment']) {

            $comment = addslashes($_POST['comment']);
            $rating = $_POST['rating'];

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

            $link = mysqli_connect("localhost", "root", "root","DJP"); 
            $query = "INSERT INTO reviews (comment, image) VALUES ('$comment', '$image')";
            $result = mysqli_query($link, $query);    
            if ($result) {
                echo '<script type="text/javascript">alert("image uploaded");</script>';
            }else{
                echo '<script type="text/javascript">alert("image not uploaded");</script>';
            }
        }
    }
?>

Rajdeep Paul · Accepted Answer · 2016-02-09 05:44:39Z

1

The problem is because of your name attribute. Look at this statement here,

<input style="float:right;"type="file" name="dataFile" id="fileChooser" onchange="return ValidateFileUpload()" />
                                                ^ see here

It should be,

<input style="float:right;" type="file" name="image" id="fileChooser" onchange="return ValidateFileUpload()" />

answered Feb 9, 2016 at 5:44

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Michael Vickers Over a year ago

ok i understand i just tried that. I must have been under the assumption it would take it from the image. You were very helpful.

Rajdeep Paul Over a year ago

@MichaelVickers Glad I could help. :-)

Rajdeep Paul Over a year ago

@devpro <img> tag has nothing to do with <input> tag. The problem is, the name attribute in <input> tag is wrong.

devpro Over a year ago

thats fine, actually there r two solution for this, one u suggested and second one i suggested :) good work

Rajdeep Paul Over a year ago

@devpro Thanks buddy. ;-)

devpro · Accepted Answer · 2016-02-09 05:58:02Z

1

Your input type file name is dataFile not image. so you can get file information as

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

Note that you have defined name='image' in <img> tag. you can't get this in $_FILES.

answered Feb 9, 2016 at 5:58

devpro

16.1k3 gold badges29 silver badges39 bronze badges

1 Comment

Rajdeep Paul Over a year ago

This could be the alternative approach. +10 from me. :-)

Collectives™ on Stack Overflow

Adding image to mysql using php

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related