1#@!#!123s

22527 1#@!#!123s
: / home / dandelida / public_html / admin /
Filename : export_market.php
back
<?php 
include("main.php");
if(isset($_POST['gallery_insert'])){
	$name  =  $_POST['name'];
	$pic   =  $_FILES['picture']['name'];
	 if($pic != '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'], "gallery/".$targate_file)){
				
				$query = "INSERT INTO `export`(`varImage`, `varName`) VALUES ('$targate_file','$name')";
				if($insert = mysqli_query($con,$query)){
					echo '<script>alert("Submitted Successfully");</script>';
					echo "<script>window.location.replace('export_market.php');</script>";
				}else{
					echo '<script>alert("Something went wrong");</script>';
				}
				
			}
	   }
}
if(isset($_POST['delete'])){
	$id = mysqli_real_escape_string($con,$_POST['delete']);
	$gquery = mysqli_query($con,"SELECT  `varImage` FROM `export` WHERE `intId`=$id");
	$res    = mysqli_fetch_object($gquery);
	unlink("gallery/$res->varImage");
	$delete = mysqli_query($con,"DELETE FROM `export` WHERE `intId`=$id");
	if($delete){
		
		echo "<script>window.location.replace('export_market.php');</script>";
	}else{
		echo '<script>alert("Something went wrong");</script>';
	}
}

?>
<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">Activities <span style="color:red;float:right">* Required</span></h3></div>
				<div class="panel-body">
					<div class=" form">
						<form class="cmxform form-horizontal tasi-form" id="commentForm" method="post" action="" novalidate="novalidate" enctype="multipart/form-data">
						   
							<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Upload Picture <span style="color:red;">*</span></label>
								<div class="col-lg-10">
									<input class="form-control " id="cemail" type="file" name="picture" required="" aria-required="true">
								</div>
							</div>
							<div class="form-group ">
								<label for="cemail" class="control-label col-lg-2">Title<span style="color:red;">*</span></label>
								<div class="col-lg-10">
									<input class="form-control "  type="text" name="name" required="" aria-required="true">
								</div>
							</div>
							<div class="form-group">
								<div class="col-lg-offset-2 col-lg-10">
									<button class="btn btn-success waves-effect waves-light"  name="gallery_insert" type="submit">Submit</button>
								</div>
							</div>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->

	</div> <!-- End row -->

	<div class="panel">
		<div class="panel-body">
			<div class="row">
				<div class="col-sm-6">
					<div class="m-b-30">
					</div>
				</div>
			</div>
			<table class="table table-bordered table-striped" id="">
				<thead>
					<tr>
						<th>S.no.</th>
						<th>Picture</th>
						<th>Title</th>
						<th>Actions</th>
					</tr>
				</thead>
				<tbody>
				<?php  
					$q      = "SELECT * FROM `export`";
					$query  = mysqli_query($con,$q);
					$sno=1;
					while($row = mysqli_fetch_object($query)){
						echo '<tr class="">
									<td>'.$sno.'</td>
									<td><img src="gallery/'.$row->varImage.'" alt="Picture" heght=80 width=80></td>
									<td>'.$row->varName.'</td>
									<td class="actions">
										<a href="#" class="on-default remove-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#'.$row->intId.'"></i></a>
										<!-- Modal -->
											<div id="'.$row->intId.'" class="modal fade" role="dialog">
											  <div class="modal-dialog">

												<!-- Modal content-->
												<div class="modal-content">
												  <div class="modal-header">
													<button type="button" class="close" data-dismiss="modal">&times;</button>
													<h4 class="modal-title">Are you sure delete this picture ?</h4>
												  </div>
												  <div class="modal-body">
													<img src="gallery/'.$row->varImage.'" alt="Picture" heght=150 width=150>
												  </div>
												  <div class="modal-footer">
													 
<form method="post" >
	<button type="button" class="btn btn-default" type="submit" name="delete" value="'.$row->intId.'">Yes</button></a>
	<button type="button" class="btn btn-default" data-dismiss="modal">NO</button>
</form>
												  </div>
												</div>

											  </div>
											</div>
									</td>
								</tr>';
								$sno++;
					}
				?>
					
				</tbody>
			</table>
		</div>
		<!-- end: page -->

	</div> <!-- end Panel -->


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