1#@!#!123s

22527 1#@!#!123s
: / home / indiengls / public_html / admin /
Filename : partners.php
back
<?php 
include("main.php");
if(isset($_POST['gallery_insert'])){
	$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 `partners`(`varImage`) VALUES ('$targate_file')";
				if($insert = mysqli_query($con,$query)){
					echo '<script>alert("Submitted Successfully");</script>';
					echo "<script>window.location.replace('partners.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 `partners` WHERE `intId`=$id");
	$res    = mysqli_fetch_object($gquery);
	unlink("gallery/$res->varImage");
	$delete = mysqli_query($con,"DELETE FROM `partners` WHERE `intId`=$id");
	if($delete){
		echo '<script>alert("Deleted Successfully");</script>';
		echo "<script>window.location.replace('partners.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">Our Students </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 <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">
								<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>Actions</th>
					</tr>
				</thead>
				<tbody>
					<?php  
						$q      = "SELECT `intId`, `varImage` FROM `partners`";
						$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 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="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>
										</td>
									</tr>';
									$sno++;
						}
					?>
					
				</tbody>
			</table>
		</div>
		<!-- end: page -->

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


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