[SOLVED] Image not saving into MySQL database

[Bopo]

Hi

 

Well I really don't know where to go from this, but basically I'm getting no errors, and the pages refreshes but there are never any new records, therefore it's not working, but I don't know what else to do

 

<?php

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

include ("blogconnect.php");

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0) {
  
  // Temporary file name stored on the server
      $tmpName  = $_FILES['image']['tmp_name'];  
       
      // Read the file 
      $fp      = fopen($tmpName, 'r');
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);
  
  $sql = "INSERT INTO userimage (image) VALUES ('$data')";
  $query = mysql_query($sql, $connect); 
  
  echo 'Your image has been uploaded!';

}
else
echo 'No image selected or uploaded';
}
?>

[Maq]

Change this line to and tell me if you see any errors when you try to insert again.

 

     $query = mysql_query($sql, $connect) or die(mysql_error()); 

 

You are also missing a '}' from your first if statement.

[Bopo]

Many thanks for your help, everything seems to act exactly the same, however it's my form I believe could be the issue

 

					<form enctype="multipart/form-data" form id="form1" name="form1" method="post" action="" class="form">
<input name="MAX_FILE_SIZE" value="1002400" type="hidden">
<input name="image" accept="image/jpeg" type="file">
<input value="Submit" type="submit">
</form>

 

I am checking that I'm only trying to upload a jpeg, and it's quite a small image, as I don't know the unit of measurement for the max file size value.

[chmpdog]

for future reference, I found the easiest way to find an error when modifying a table is echo your variable ("$sql" in this case).

[Bopo]

Thanks for the help, managed to get it working

[Maq]

Thanks for the help, managed to get it working

 

Hmm yeah, file uploading scripts can be tricky sometimes.