Databases
StackOverflow2013
Postsdbo
POImages/file upload to mysql database not working
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POImages/file upload to mysql database not working
    primarykey
    data
    text
    <p>I'm currently having a bit of a rough time uploading an image to my database. I currently have multiple variables/inputs being uploaded from one form - one if these inputs is an image file upload. The file seems to make it do the database, but when I try to retrieve the image via a PHP script, it simply returns "Array", rather than the image. Any help? Thanks!</p> <p>Here's the upload code:</p> <pre><code> // if the form's submit button is clicked, we need to process the form if (isset($_POST['submit'])) { // get the form data $projectname = htmlentities($_POST['projectname'], ENT_QUOTES); $item = htmlentities($_POST['item'], ENT_QUOTES); $description = htmlentities($_POST['description'], ENT_QUOTES); $neededby = htmlentities($_POST['neededby'], ENT_QUOTES); $shipping= htmlentities($_POST['shipping'], ENT_QUOTES); $revisions = htmlentities($_POST['revisions'], ENT_QUOTES); $price = htmlentities($_POST['price'], ENT_QUOTES); $paid = htmlentities($_POST['paid'], ENT_QUOTES); $ordered1 = htmlentities($_POST['ordered1'], ENT_QUOTES); $ordered2 = htmlentities($_POST['ordered2'], ENT_QUOTES); $ordered3 = htmlentities($_POST['ordered3'], ENT_QUOTES); $received1 = htmlentities($_POST['received1'], ENT_QUOTES); $received2 = htmlentities($_POST['received2'], ENT_QUOTES); $received3 = htmlentities($_POST['received3'], ENT_QUOTES); $shipped1 = htmlentities($_POST['shipped1'], ENT_QUOTES); $shipped2 = htmlentities($_POST['shipped2'], ENT_QUOTES); $shipped3 = htmlentities($_POST['shipped3'], ENT_QUOTES); $tracking = htmlentities($_POST['tracking'], ENT_QUOTES); $delivered = htmlentities($_POST['delivered'], ENT_QUOTES); $thestatus = htmlentities($_POST['thestatus'], ENT_QUOTES); $photo=($_FILES['photo']); if ($projectname == '') { // if they are empty, show an error message and display the form $error = 'ERROR: Please fill in project name!'; renderForm($projectname, $item, $description, $neededby, $shipping, $revisions, $price, $paid, $ordered1, $ordered2, $ordered3, $received1, $received2, $received3, $shipped1, $shipped2, $shipped3, $tracking, $delivered, $thestatus, $photo, $error, $id); } else { // insert the new record into the database if ($stmt = $mysqli-&gt;prepare("INSERT todo (projectname, item, description, neededby, shipping, revisions, price, paid, ordered1, ordered2, ordered3, received1, received2, received3, shipped1, shipped2, shipped3, tracking, delivered, photo, thestatus) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) { $stmt-&gt;bind_param("sssssssssssssssssssss", $projectname, $item, $description, $neededby, $shipping, $revisions, $price, $paid, $ordered1, $ordered2, $ordered3, $received1, $received2, $received3, $shipped1, $shipped2, $shipped3, $tracking, $delivered, $photo, $thestatus); $stmt-&gt;execute(); $stmt-&gt;close(); } // show an error if the query has an error else { echo "ERROR: Could not prepare SQL statement."; } // redirec the user header("Location: main.php"); } } </code></pre> <p>And the file retrieve code:</p> <pre><code>&lt;?php mysql_connect("localhost","MYUSER","MYPASS"); mysql_select_db("MYDB"); $query = "SELECT photo FROM todo where id=$id"; $result = MYSQL_QUERY($query); $data = MYSQL_RESULT($result,0,"photo"); Header( "Content-type: $type"); print $data; ?&gt; </code></pre> <p>The mysql column is a BLOB type.</p> <p>Here is an image so you can get some visuals on what I'm saying: <a href="http://i.imgur.com/DYHHx.png" rel="nofollow">http://i.imgur.com/DYHHx.png</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex
    1. USAlex
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POImages/file upload to mysql database not working
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POImages/file upload to mysql database not working
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POImages/file upload to mysql database not working
      1. USMatisse VerDuyn
      1. VTFavorite
    1. COIs there a particular reason why you want to store the image in the database rather than just saving the file to a directory and saving the path of the file to the database? Saving the file path would be much nice to the database than storing the entire image.
      singulars
      1. POImages/file upload to mysql database not working
      1. USknittledan
    2. COThat's first and foremost because `$_FILES['photo']` *is* an array which contains information about the uploaded file. It's not the uploaded file itself. Have you tried [consulting the manual](http://php.net/manual/en/features.file-upload.php) about file uploads?
      singulars
      1. POImages/file upload to mysql database not working
      1. USdeceze
    3. CO@knittledan I believe that BLOB data types are stored outside the table proper, and the table just includes a pointer to the information. So storing an image in the database shouldn't cause issues for normal queries (though it might slow down backup and replication).
      singulars
      1. POImages/file upload to mysql database not working
      1. USoctern
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload