Editando: gallery.php
<?php $page = 'Gallery'; $page_icon = ""; //$employee = "active"; include("check.php"); include 'header.php'; if (@$_REQUEST['delect_id']) { $gid = @$_REQUEST['delect_id']; $delete = mysql_query("delete from gallery where gid='$gid'"); if (!$delete) { $_SESSION['msg'] = "Something is wrong..Please try again.."; $_SESSION['type'] = "Error"; } else { $_SESSION['msg'] = "Sucessefully Delete record.."; $_SESSION['type'] = "Success"; } echo '<script>window.location="gallery.php";</script>'; } ?> <!-- PAGE CONTENT WRAPPER --> <div class="page-content-wrap"> <div class="row"> <div class="col-md-12"> <!-- START DEFAULT DATATABLE --> <div class="panel panel-colorful"> <div class="panel-heading ui-draggable-handle modal-header"> <h3 class="panel-title">Gallery View</h3> <form method="post"> <div class="col-md-4" style="text-align: right"> </div> <div class="col-md-3" style="text-align: right"> <select name="pid" class="form-control" style="width: 250px" required=""> <option disabled="" selected="">Select Project</option> <?php $pid = ''; $select_project = mysql_query("select * from project where d_status!='Delete'"); while ($row_project = mysql_fetch_array($select_project)) { if (@$_REQUEST['btn_search']) { $pid = $_POST['pid']; } $check_select = ''; if ($row_project['pid'] == $pid) { $check_select = 'selected=""'; } else { $check_select = ''; } ?> <option value="<?php echo $row_project['pid']; ?>" <?php echo $check_select; ?> ><?php echo $row_project['name']; ?></option> <?php } ?> </select> </div> <div class="col-md-1"> <input type="submit" class="btn btn-primary" name="btn_search" value="Search" /> </div> <div class="col-md-1"> <a href="gallery.php" class="btn btn-primary" >All</a> </div> </form> </div> <div class="panel-body"> <div class="col-md-12"> <?php $i = 1; $all = ''; if (@$_REQUEST['btn_search']) { $pid = $_POST['pid']; $select = mysql_query("select d.*,p.name as pname, e.name as ename from gallery as d LEFT JOIN project as p ON d.pid=p.pid LEFT JOIN employees as e ON d.eid=e.eid where d.pid='$pid'"); } else { $select = mysql_query("select d.*,p.name as pname, e.name as ename from gallery as d LEFT JOIN project as p ON d.pid=p.pid LEFT JOIN employees as e ON d.eid=e.eid"); } $cout = mysql_num_rows($select); if ($cout > 0) { while ($company_emp_data = mysql_fetch_array($select)) { ?> <div class="col-md-3" style="text-align: center; padding: 10px; "> <a href="<?php echo $company_emp_data['image']; ?>" target="_blank"> <img src="<?php echo $company_emp_data['image']; ?>" height="200px" width="100%;" style="float: left;border: 2px solid #000 " /> </a> <b style="margin-top: -20px; float: left; background-color: #000; color: #fff; padding: 1px 4px"> <?php echo $company_emp_data['cdate'] . ' - ' . $company_emp_data['pname']; ?> </b> <a href="?delect_id=<?php echo $company_emp_data['gid']; ?>" class="label label-danger" style="float: right;margin-top: -23px;"> <span class="fa fa-trash-o" style="font-size: 18px"></span> </a> </div> <?php $i++; } } else { ?> <div class="col-md-12" style="text-align: center;"> ******No Data****** </div> <?php } ?> </div> </div> </div> <!-- END DEFAULT DATATABLE --> </div> </div> </div> <!-- PAGE CONTENT WRAPPER --> <?php include 'footer.php'; ?>
Cancelar
Kerym Chaeceran