1#@!#!123s

22527 1#@!#!123s
: / home / dandelida / public_html / admin /
Filename : product.php
back
<?php 
include("main.php");

if(isset($_POST['product_insert'])){
	$title    	  = mysqli_real_escape_string($con,$_POST['title']);
	$keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	$headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$name 	  = mysqli_real_escape_string($con,$_POST['name']);
	$category = mysqli_real_escape_string($con,$_POST['category']);
	$price    = mysqli_real_escape_string($con,$_POST['price']);
	$content  = mysqli_real_escape_string($con,$_POST['content']);
	$featured = mysqli_real_escape_string($con,$_POST['featured']);
	$pic  	  =  $_FILES['picture']['name'];
	
	
	 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)){
				 $insert = "INSERT INTO `product`(  `varProductName`, `varPrice`,`varImage`, `txtDescription`, `varFeatured`, `varMetaTitle`, `varMetaKeywords`, `txtMetaDescription`) VALUES ( '$name','$price','$targate_file','$content','$featured','$title','$keywords','$headerdes')";
				if(mysqli_query($con,$insert))
				{
					echo "<script>window.location.replace('product.php');</script>";
				}else{
					echo "<script>alert('Something went wrong');</script>";
				} 
			}
	   }else{
		   echo "<script>alert('Something went wrong');</script>";
	   }
	   
	    
	   
}

/* product edit code */
if(isset($_POST['product_update'])){
	$title    	  = mysqli_real_escape_string($con,$_POST['title']);
	$keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	$headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$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']);
	$price    = mysqli_real_escape_string($con,$_POST['price']);
	$content  = mysqli_real_escape_string($con,$_POST['content']);
	$featured = mysqli_real_escape_string($con,$_POST['featured']);
	$pic  	  =  $_FILES['picture']['name'];
	
	$update = "UPDATE `product` SET  `varProductName`='$name',`varPrice`='$price',`txtDescription`='$content',`varFeatured`='$featured',`varMetaTitle`='$title',`varMetaKeywords`='$keywords',`txtMetaDescription`='$headerdes'";
	 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>alert('Updated Successfully');</script>";
			echo "<script>window.location.replace('product.php');</script>";
		}else{
			echo "<script>alert('Something went wrong');</script>";
			echo "<script>window.location.replace('product.php');</script>";
		} 
	   
}

/* product edit code */

/* product delete code */
if(isset($_POST['delete'])){
	
	$id = mysqli_real_escape_string($con,$_POST['delete']);
	$squery = mysqli_query($con,"SELECT `varImage` FROM `product` WHERE `intId`=$id");
	$res    = mysqli_fetch_object($squery);
	unlink("product/$res->varImage");
	$delete = mysqli_query($con,"DELETE FROM `product` WHERE `intId`=$id");
	if($delete){
		
		echo "<script>window.location.replace('product.php');</script>";
	}else{
		echo '<script>alert("Something went wrong");</script>';
	}
}
/* end product delete code */

?>
<!--  page-wrapper -->
<div id="page-wrapper">
	<div class="row">
		<!-- Page Header -->
		<div class="col-lg-12">
			<h1 class="page-header">Activities</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">Add Activity <span style="color:red;float:right">* Required</span></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-6">
										<label for="disabledSelect ">Name <span style="color:red;">*</span></label>
										<input class="form-control" required="" name="name" type="text" value="" >
									</div>
									<div class="col-sm-6">
										<label for="disabledSelect ">Image</label>
										<input class="form-control" name="picture" type="file" >
									</div>
								</div>
								 
								<!--
								<div class="form-group ">
									<div class="col-lg-12">
										<label for="ccomment">SEO Title</label>
										<input class="form-control "  type="text" name="title"  aria-required="true" value="<?php echo $res->varMetaTitle; ?>">
									</div>
								</div>
								<div class="form-group ">
									<div class="col-lg-12">
										<label for="ccomment">SEO Keywords</label>
										<textarea class="form-control"  name="keywords" required="required" aria-required="true" placeholder="Enter The Keywords">
										<?php echo $res->varMetaKeywords; ?></textarea>
									</div>
								</div>
								<div class="form-group ">
									<div class="col-lg-12">
										<label for="ccomment">SEO Description</label>
										<textarea class="form-control"  name="description" required="required" aria-required="true" placeholder="Enter The Description"><?php echo $res->txtMetaDescription; ?></textarea>
									</div>
								</div>-->
								<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Description <span style="color:red;">*</span></label>
										<textarea class="form-control ckeditor" id="js-my-textarea1" name="content" required=""  placeholder="Enter The Content" ></textarea>
									</div>
								</div>
								<br/><br/>
								<div class="form-group">
									<div class="col-sm-12">		
										<button type="submit" name="product_insert" class="btn btn-primary" style="margin-top:10px;">Submit</button>
									</div>
								</div>			
							</fieldset>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->
	</div> <!-- End row -->
			<div class="row">
				<div class="col-lg-12">
                  <!--   Kitchen Sink -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
							 All Records 
                        </div>
                        <div class="panel-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover">
                                    <thead>
                                        <tr>
                                            <th>Sno.</th>
                                            <th>Image</th> 
                                            <th>Name</th>
                                           <!-- <th>Content</th> -->                          
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tbody>
										<?php 
										
											$query = mysqli_query($con,"SELECT * FROM `product`");
											
											if($query){  
												 $sno = 1;
												while($row = mysqli_fetch_object($query)){
													
												 
													 
													echo '<tr>
															<td>'.$sno.'</td>
															<td><img src="product/'.$row->varImage.'" height="75" width="75" /></td> 
															<td>'.$row->varProductName.'</td>
															<!--<td>'.$row->txtDescription.'</td>-->
															<td>
																<a href="#" class="on-default edit-row"><i class="fa fa-pencil" data-toggle="modal" data-target="#edit_'.$row->intId.'"></i></a>
															</td>
															<td>
																<a href="#" class="on-default edit-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#del_'.$row->intId.'"></i></a>
															</td>
	<!-- Package Update Modal -->
	<div class="modal fade" id="edit_'.$row->intId.'" role="dialog">
		<div class="modal-dialog modal-lg">
		
		  <!-- Modal content-->
		  <div class="modal-content">
			<div class="modal-header">
			  <button type="button" class="close" data-dismiss="modal">&times;</button>
			  <h4 class="modal-title">Update Activity </h4>
			</div>
			<div class="modal-body">
				<form role="form" method="post" action="" enctype="multipart/form-data">	
					<fieldset>						
						<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/'.$row->varImage.'" height="75" width="75">
							</div>
						</div>
						<div class="form-group">	
							<div class="col-sm-12">
								<label for="disabledSelect ">Name <span style="color:red;">*</span></label>
								<input class="form-control" required="" name="name" type="text" value="'.$row->varProductName.'" >
							</div>
						</div>
					 	
						<!--
						<div class="form-group ">
							<div class="col-lg-12">
								<label for="ccomment" >SEO Title</label>
								<input class="form-control "  type="text" name="title"  aria-required="true" value="'. $row->varMetaTitle .'">
							</div>
						</div>
						<div class="form-group ">
							<div class="col-lg-12">
								<label for="ccomment" >SEO Keywords</label>
								<textarea class="form-control"  name="keywords" required="required" aria-required="true" placeholder="Enter The Keywords">
								'.$row->varMetaKeywords.'</textarea>
							</div>
						</div>
						<div class="form-group ">
							<div class="col-lg-12">
								<label for="ccomment">SEO Description</label>
								<textarea class="form-control"  name="description" required="required" aria-required="true" placeholder="Enter The Description">'. $row->txtMetaDescription.'</textarea>
							</div>
						</div>-->
						<div class="form-group">
							<div class="col-sm-12">
								<label for="disabledSelect">Description <span style="color:red;">*</span></label>
								<textarea class="form-control ckeditor" id="js-my-textarea1" name="content" required=""  placeholder="Enter The Content" >'.$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="'.$row->intId.'" style="margin-top:10px;">Update</button>
							</div>
						</div>			
					</fieldset>
				</form>
			</div>
			<div class="modal-footer">
			  <button type="button" class="btn btn-default" data-dismiss="modal">No</button>
			</div>
		  </div>
		  
		</div>
	</div>														
	<!-- Package Delete Modal -->
	<div class="modal fade" id="del_'.$row->intId.'" role="dialog">
		<div class="modal-dialog modal-sm">
		
		  <!-- Modal content-->
		  <div class="modal-content">
			<div class="modal-header">
			  <button type="button" class="close" data-dismiss="modal">&times;</button>
			  <h4 class="modal-title">Delete Activity </h4>
			</div>
			<div class="modal-body">
			  <p>Are you sure, you want to delete this Activity?</p>
			</div>
			<div class="modal-footer">
				<form  method="post">
					<button type="submit"  value="'.$row->intId.'" class="btn btn-danger" name="delete">Yes</button></a>
					<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
				</form>
			</div>
		  </div>
		  
		</div>
	</div>
														</tr>';
														$sno ++;
												}
											}else{
												echo "Record Not Found";
											}
										?>
                                      
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                     <!-- End  Kitchen Sink -->
                </div>
			</div>
</div>
        <!-- end page-wrapper -->

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