Editing file: edit-productimage3.php

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');
if(strlen($_SESSION['odmsaid'])==0)
{	
	header('location:index.php');
}
if(isset($_POST['updateimage3']))
{
	$caid = $_SESSION['subcid'];
	$image3=$_FILES["imageUpload3"]["name"];
	move_uploaded_file($_FILES["imageUpload3"]["tmp_name"],"productimages/".$_FILES["imageUpload3"]["name"]);
	$sql3="update tblproducts set ProductImage3=:image3 where id = :caid ";
	$query=$dbh->prepare($sql3);
	$query->bindParam(':image3',$image3,PDO::PARAM_STR);
	$query->bindParam(':caid',$caid,PDO::PARAM_STR);
	$query->execute();
	if ( $query->execute()) {
		echo '<script>alert("image has been updated.")</script>';
		echo "<script>window.location.href ='product-edit.php?productid=<?php echo ('$caid') ?>'</script>";
	}else{
		echo '<script>alert("Something Went Wrong. Please try again")</script>';
}
}
?>
<form method="post" id="subcategory-form" enctype="multipart/form-data">
	<div id="form_status"></div>
	<?php
	$pid= $_POST['edit_id3'];
	$sql="SELECT * from tblproducts where id=:pid ";
	$query2 = $dbh -> prepare($sql);
	$query2-> bindParam(':pid', $pid, PDO::PARAM_STR);
	$query2->execute();
	$results2=$query2->fetchAll(PDO::FETCH_OBJ);
	if($query2->rowCount() > 0)
	{
		foreach($results2 as $row2)
		{ 
			$_SESSION['subcid']=$row2->id;
			?>
			<div class="row mb-2">
<div class="col-lg-12">
					<div class="form-group">
						<label for="brandName">Product Name</label>
						<input type="text" class="form-control" name="category" value="<?php  echo $row2->ProductName;?>" id="subcategory">
					</div>
				</div>
				<div class="col-lg-12">
					<div class="form-group">
						<input type='file' name="imageUpload3" id="imageUpload3" class="ec-image-upload"
						accept=".png, .jpg, .jpeg, .avif" />
					</div>
				</div>
				
				<div class="modal-footer px-4">
					<button type="button" class="btn btn-secondary btn-pill"
					data-bs-dismiss="modal">Cancel</button>
					<button type="submit" name="updateimage3" class="btn btn-primary btn-pill">Update</button>
				</div>
				<?php 
			}
		} ?>
	</form>
Back