mysqli - Uploading Image in MySQL database PHP Error

Question

The if statement is not running .It works fine with the tutorial I have followed but when i have implemented it in my code it fails.The error is Undefined index: thumbnailPic, The HTML code is :

<label >Thumbnail Picture<text>*</text></label><br>
<input type="file" name="thumbnailPic" id="pic"><br>
<label >Original Picture<text>*</text></label><br>
<input type="file" name="originalPic" id="pic"><br>

The PHP code is :

if (is_uploaded_file($_FILES['thumbnailPic']['tmp_name']) != false) {
   $spID="NULL";
   $Quant=$_POST['quantity'];
   $Siz=$_POST['Size'];
   $imgfp = fopen($_FILES['thumbnailPic']['tmp_name'],'rb');
   $stmt = $connection->prepare("INSERT INTO stitchedproduct(sp_id,quantity,size,p_id,color_id,sp_thumbnail,sp_OriginalPic) VALUES (? ,?, ?, ?,?,?,?)");
   $stmt->bindParam(1, $spID);
   $stmt->bindParam(2, $Quant);
   $stmt->bindParam(3, $Siz);
   $stmt->bindParam(4, $ProductID);
   $stmt->bindParam(5, $colour);
   $stmt->bindParam(6, $imgfp);
   $stmt->bindParam(7, $imgfp);
   $stmt->execute();
}
else
   echo "Error uploading image";

Answer 1

try something like this,may be this code could help you a bit

$image = addslashes(file_get_contents($_FILE['image']['tmp_name'])); //SQL Injection defence!
$image_name = addslashes($_FILES['image']['name']);
$sql = "INSERT INTO `product_images` (`id`, `image`, `image_name`) VALUES ('1', '{$image}', '{$image_name}')";
if (!mysql_query($sql)) { // Error handling
    echo "Something went wrong! :("; 
}

also ur form must look like something this

<form action="insert_product.php" method="POST" enctype="multipart/form-data">
    <label>File: </label><input type="file" name="image" />
    <input type="submit" />
</form>