The problem is the $_FILES['thumbnailPic'] is not picking values from HTML form .I have tried so many solutions but its just not working :( 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>
<input type="submit" name="AddStock" id= "formAddStock" value="Add Stock">
The php code is :
if(!isset($_FILES['thumbnailPic']))
{
echo '<p>Please select a file</p>';
}
else
{
$spID=NULL;
$Quant=$_POST['quantity'];
$Siz=$_POST['Size'];
$imgfp = fopen($_FILES['originalPic']['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->bindParam(1, $spID);
$stmt->execute();
}