1#@!#!123s

22527 1#@!#!123s
: / home / realforcepumps / public_html / admin /
Filename : product-edit.php
back
<?php 
include("main.php");
if(isset($_GET['id'])){
	$id = mysqli_real_escape_string($con,$_GET['id']);
	$query = mysqli_query($con,"SELECT  `intId`,`intCategoryId`, `varProductName`, `varImage`, `txtDescription`, `varFeatured` FROM `product` WHERE `intId`=$id" );
	$row   = mysqli_fetch_object($query);
	
}else{
	echo "<script>window.location.replace('product.php');</script>";
}
if(isset($_POST['product_update'])){
	
	$pid 	  = mysqli_real_escape_string($con,$_POST['product_update']);
	$name 	  = mysqli_real_escape_string($con,$_POST['name']);
	$category = mysqli_real_escape_string($con,$_POST['category']);
	$content  = mysqli_real_escape_string($con,$_POST['content']);
	$featured = mysqli_real_escape_string($con,$_POST['featured']);
	$pic  	  =  $_FILES['picture']['name'];
	
	$update = "UPDATE `product` SET `intCategoryId`=$category,`varProductName`='$name',`txtDescription`='$content',`varFeatured`='$featured'";
	 if($_FILES['picture']['name']!= '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'],"product/".$targate_file)){
				 $update .= ",`varImage`='$targate_file'";
			}
	   }
	   
	     $update .= " WHERE `intId`=$pid";
		if($up = mysqli_query($con,$update))
		{
			echo "<script>window.location.replace('product.php');</script>";
		}else{
			echo "<script>alert('Something went wrong');</script>";
			echo "<script>window.location.replace('product-edit.php?id=$pid');</script>";
		} 
	   
}


?>
<!--  page-wrapper -->
<div id="page-wrapper">
	<div class="row">
		<!-- Page Header -->
		<div class="col-lg-12">
			<h1 class="page-header">Product</h1>
		</div>
		<!--End Page Header -->
	</div>
	<div class="row">
		<div class="col-sm-12">
			<div class="panel panel-default">
				<div class="panel-heading"><h3 class="panel-title">Insert Product</h3></div>
				<div class="panel-body">
					<div class=" form">
						<form role="form" method="post" action="" enctype="multipart/form-data">	
							<fieldset>	
								<div class="form-group">	
									<div class="col-sm-12">
										<label for="disabledSelect ">Name</label>
										<input class="form-control" required="" name="name" type="text" value="<?php echo $row->varProductName;?>" >
									</div>
								</div>
								<div class="form-group">	
									<div class="col-sm-12">
										<label for="disabledSelect ">Category</label>
										<select class="form-control" required="" name="category" >
										<?php 
											$category = mysqli_query($con,"SELECT `intId`, `varName` FROM `category`");
											if(mysqli_num_rows($category) > 0){
												while($crow = mysqli_fetch_object($category) ){
													if($crow->intId == $row->intCategoryId){
														echo '<option value="'.$crow->intId.'" selected>'.$crow->varName.'</option>';
													}else{
														echo '<option value="'.$crow->intId.'">'.$crow->varName.'</option>';
													}
													
												}
											}
										?>
										</select>
									</div>
								</div>	
								<div class="form-group">	
									<div class="col-sm-12">
										<label for="disabledSelect ">Product Show on Home Page</label>
										<select class="form-control" required="" name="featured" >
											<option value="<?php echo $row->varFeatured;?>"><?php echo $row->varFeatured;?></option>
											<option value="Yes">Yes</option>
											<option value="No">No</option>
										</select>
									</div>
								</div>								
								<div class="form-group">							
									<div class="col-sm-7">
										<label for="disabledSelect ">Image</label>
										<input class="form-control" name="picture" type="file" >
									</div>
									<div class="col-sm-5">
										<img src="product/<?php echo $row->varImage;?>" height="250" width="250">
									</div>
								</div>
								<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Content</label>
										<textarea class="form-control" name="content" required=""  placeholder="Enter The Content" ><?php echo $row->txtDescription;?></textarea>
									</div>
								</div>
								<br/><br/>
								<div class="form-group">
									<div class="col-sm-12">		
										<button type="submit" name="product_update" class="btn btn-primary" value="<?php echo $row->intId;?>">Update</button>
									</div>
								</div>			
							</fieldset>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->
	</div> <!-- End row -->
</div>
        <!-- end page-wrapper -->

<?php include("footer.php"); ?>