Editing file: edit-productimage2.php

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');
if(strlen($_SESSION['odmsaid'])==0)
{	
	header('location:index.php');
}
if(isset($_POST['updateimage2']))
{
	$caid = $_SESSION['subcid'];
	$image2=$_FILES["imageUpload2"]["name"];
	move_uploaded_file($_FILES["imageUpload2"]["tmp_name"],"productimages/".$_FILES["imageUpload2"]["name"]);
	$sql2="update tblproducts set ProductImage2=:image2 where id = :caid ";
	$query2=$dbh->prepare($sql2);
	$query2->bindParam(':image2',$image2,PDO::PARAM_STR);
	$query2->bindParam(':caid',$caid,PDO::PARAM_STR);
	$query2->execute();
	if ( $query2->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_id2'];
	$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="imageUpload2" id="imageUpload2" 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="updateimage2" class="btn btn-primary btn-pill">Update</button>
				</div>
				<?php 
			}
		} ?>
	</form>
Back