1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / dealer /
Filename : edit-product.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
$title="Edit Item";

if(isset($_GET) && !empty($_GET)){
	$pid = intval($_GET['id']); // get product id
} else {
	echo "<script>window.location.href='products.php';</script>";
}

if(isset($_POST) && !empty($_POST)){
	$category = mysqli_real_escape_string($con, $_POST['category']);
	$brand = mysqli_real_escape_string($con, $_POST['brand']);
	$stock = mysqli_real_escape_string($con, $_POST['stock']);
	$description = mysqli_real_escape_string($con, $_POST['description']);
	$currency = mysqli_real_escape_string($con, $_POST['currency']);
	$productname = mysqli_real_escape_string($con, $_POST['productName']);
	$productprice = mysqli_real_escape_string($con, $_POST['productprice']);
	$productkeywords = mysqli_real_escape_string($con, $_POST['product_keywords']);
	$free_shipping = mysqli_real_escape_string($con, $_POST['free_shipping']);
	$weight = mysqli_real_escape_string($con, $_POST['weight']);
	$distance = mysqli_real_escape_string($con, $_POST['distance']);
	$vehicle = mysqli_real_escape_string($con, $_POST['vehicle']);
	$shipping_country = mysqli_real_escape_string($con, $_POST['shipping_country']);

	$sql = "UPDATE products 
			SET 
				product_title = '$productname', 
				currency = '$currency', 
				product_cat_id = '$category', 
				product_desc = '$description', 
				product_price = '$productprice', 
				stock = '$stock', 
				product_brand_id = '$brand', 
				product_keywords = '$productkeywords', 
				free_shipping = '$free_shipping', 
				shipping_weight = '$weight', 
				shipping_distance = '$distance', 
				vehicle_price = '$vehicle', 
				shipping_country = '$shipping_country'
			WHERE product_id = $pid";

	$res = mysqli_query($con, $sql);
	if($res){
		$msg = "Product Updated Successfully!";
		$type = "success";
	} else {
		$msg = "Failed to Update product";
		$type = "warning";
	}
}
?>

<?php include('include/header.php');?>
<?php include('include/sidebar.php');?>

<!-- Content wrapper -->
<div class="content-wrapper">
	<!-- Content -->
	<div class="container-xxl flex-grow-1 container-p-y">
		<h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Products/</span> Edit Product</h4>

		<div class="card mb-4">
			<!-- Account -->
			<div class="card-body">
				<?php if(isset($msg)){ ?>
				<div class="alert alert-<?php echo $type?>">
					<h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
					<p class="mb-0"><?php echo $msg?></p>
				</div>
				<?php }?>

				<?php 
				$query3 = mysqli_query($con, "SELECT * FROM products WHERE product_id = $pid");
				while($r = mysqli_fetch_array($query3)) {
				?>

				<div class="text-box">
					<h4>Edit <?php echo $r['product_title']; ?></h4>
					<form class="form-horizontal row-fluid" name="insertproduct" method="post" enctype="multipart/form-data">
						<div class="row">
							<!-- Category -->
							<div class="mb-3 col-md-6">
								<label class="" for="basicinput">Category</label>
								<select name="category" class="form-control" required>
									<?php 
									$query = mysqli_query($con, "select * from categories");
									while($row = mysqli_fetch_array($query)) { ?>
										<option value="<?php echo $row['cat_id']; ?>" <?php if( $row['cat_id'] == $r['product_cat_id']) { echo "selected"; } ?>><?php echo $row['cat_title']; ?></option>
									<?php } ?>
								</select>
							</div>

							<!-- Brand -->
							<div class="mb-3 col-md-6">
								<label class="" for="basicinput">Brand</label>
								<select name="brand" class="form-control" required>
									<?php 
									$query = mysqli_query($con, "select * from brands");
									while($row = mysqli_fetch_array($query)) { ?>
										<option value="<?php echo $row['brand_id']; ?>" <?php if( $row['brand_id'] == $r['product_brand_id']) { echo "selected"; } ?>><?php echo $row['brand_title']; ?></option>
									<?php } ?>
								</select>
							</div>

							<!-- Product Name -->
							<div class="mb-3 col-md-6">
								<label class="form-label" for="basicinput">Name</label>
								<input type="text" class="form-control" name="productName" value="<?php echo $r['product_title']; ?>" required>
							</div>

							<!-- Product Price -->
							<div class="mb-3 col-md-6">
								<label class="form-label" for="basicinput">Price</label>
								<input type="text" class="form-control" name="productprice" value="<?php echo $r['product_price']; ?>" required>
							</div>

							<!-- Currency -->
							<div class="mb-3 col-md-6">
								<label class="form-label" for="basicinput">Currency</label>
								<input type="text" class="form-control" name="currency" value="<?php echo $r['currency']; ?>">
							</div>

							<!-- Stock -->
							<div class="mb-3 col-md-6">
								<label class="form-label" for="basicinput">Qty in Stock</label>
								<input type="number" class="form-control" name="stock" value="<?php echo $r['stock']; ?>" required>
							</div>

							<!-- Free Shipping -->
							<div class="mb-3 col-md-6">
								<label class="control-label" for="discount_type">Free Shipping</label>
								<select name="free_shipping" class="form-control">
									<option value="0" <?php if($r['free_shipping'] == '0') echo 'selected'; ?>>No</option>
									<option value="1" <?php if($r['free_shipping'] == '1') echo 'selected'; ?>>Yes</option>
								</select>
							</div>

							<!-- Shipping Weight -->
							<div class="mb-3 col-md-6">
								<label class="control-label" for="basicinput">Shipping Weight (KG)</label>
								<input type="text" class="form-control" name="weight" value="<?php echo $r['shipping_weight']; ?>">
							</div>

							<!-- Shipping Distance -->
							<div class="mb-3 col-md-6">
								<label class="control-label" for="basicinput">Shipping Distance</label>
								<input type="text" class="form-control" name="distance" value="<?php echo $r['shipping_distance']; ?>">
							</div>

							<!-- Vehicle Price -->
							<div class="mb-3 col-md-6">
								<label class="control-label" for="basicinput">Vehicle Price (£)</label>
								<input type="text" class="form-control" name="vehicle" value="<?php echo $r['vehicle_price']; ?>">
							</div>

							<!-- Shipping Country -->
							<div class="mb-3 col-md-6">
								<label class="control-label" for="basicinput">Shipping Country</label>
								<input type="text" class="form-control" name="shipping_country" value="<?php echo $r['shipping_country']; ?>">
							</div>

							<!-- Description -->
							<div class="mb-3 col-md-6">
								<label class="form-label" for="basicinput">Description</label>
								<textarea name="description" class="form-control"><?php echo $r['product_desc']; ?></textarea>
							</div>
					<div class="mb-3 col-md-6">
					<label class="form-label" for="basicinput"> Keywords</label>
					<div class="controls">
					<input type="text" class="form-control"   name="product_keywords"  value="<?php echo $r['product_keywords']; ?>" class="span8 tip" required>
					</div>
					</div>



					<div class="mb-3 col-md-6">
									<label for="productimage">Image</label>
									<?php if(isset($r['product_image']) & !empty($r['product_image'])){ ?>
									<br>
										<img src="../admin/uploads/<?php echo $r['product_image'] ?>" widht="100px" height="100px">
										<a href="delproductimg.php?id=<?php echo $r['product_id']; ?>">Delete Image</a> <br>
										<a href="updateproductimg.php?id=<?php echo $r['product_id']; ?>" 
										style="margin-left:70px;">Update Image</a>

									<?php }else{ ?>
									
										<a href="updateproductimg.php?id=<?php echo $r['product_id']; ?>">Add Image</a>

									<?php  }?>
								</div>

								
						<div class="">
																<div class="form-group">
																	<button type="submit" name="submit" class="btn btn-o btn-primary" >Update Item</button>
																</div>
															</div>
														</form>
												</div>
											</div>


											

						<?php }?>
						
						
					</div><!--/.content-->
				</div><!--/.span9-->
			</div>
		</div><!--/.container-->
	</div><!--/.wrapper-->
	</div><!--/.content-->
				</div><!--/.span9-->
			</div>
		</div><!--/.container-->
	</div><!--/.wrapper-->




<?php include('include/footer.php');?>