Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

<?php
$conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
if ($_GET[act] == "del") {
    $delid = $_GET[delid];
  $image_r=mysqli_fetch_assoc(mysqli_query($conn, "select * from tbl_glance where id=$delid"));
    $imgpath="../images/glance/".$image_r['image'];
    $sql_del = mysqli_query($conn, "delete from tbl_glance where id= " . $delid . "");
   if(file_exists($imgpath)){
      @unlink($imgpath);  
    }
    $msg = "Record Deleted Successfully.";
    print "<script>";
    print "self.location = 'manage_glance.php?msg=$msg';";
    print "</script>";
}
$client_sql = mysqli_query($conn, "select * from tbl_glance order by id desc");
$total = mysqli_num_rows($client_sql);
?>

<div class="content_header">
  <div class="heading flleft">Featured & Technologies</div>
  
   <?php
  $i = 1;
  $banner_sql = mysqli_query($conn, "select * from tbl_glance order by id desc");
  while ($row = mysqli_fetch_array($banner_sql)) {
  ?>
  
  <div class="clear"></div>
</div>
<div class="bodycontent">
 <?php
    if($_GET['msg']!=''){
    ?>
    <div style="text-align:center; color: red;"><?php echo $_GET['msg'];?></div>
  <?php
  }
if($total>0) { ?>
<form action="StaffAction.php" method="post">
<input type="hidden" name="act" value="sort" />
<?php

?>
  <table width="99%" border="1" bordercolor="#CCCCCC" cellspacing="0" cellpadding="3" align="center" class="datagrid" id="pagetable">
    <thead>
  <tr>
      <th width="29" align="center">S.N.</th>
      
      <th width="142" align="left" class="sort" onclick="sortdata('f.faculty_name')">Feature Heading</th>   
      <th width="142" align="left" class="sort" onclick="sortdata('f.faculty_name')">Feature Details</th> 
    <th width="216" align="left" class="sort" onclick="sortdata('f.faculty_designation')">Photo</th> 
      
      <th  align="center">Actions</th>
    </tr>
  </thead>
  <tbody>
     <?php
  $i = 1;
  $banner_sql = mysqli_query($conn, "select * from tbl_glance order by id desc");
  while ($row = mysqli_fetch_array($banner_sql)) {
  ?>
    
    <tr>
      <td align="center"><?php echo $i;?></td>
      <td align="left"><?php echo $row['title'];?></td>  
      <td align="left"><?php echo $row['details'];?></td>  
    <td align="left">
      <?php if ($row['image']) { ?>
        <img src="../images/glance/<?php print $row['image']; ?>" width="150" height="100" />
    <?php } ?>
      </td>
    <td width="40" align="center"><a href="manage_glance.php?q=edit&id=<?php print $row['id'] ?>"> <img border="0" src="images/edit.png" align="Edit" title="Edit" /></a></td>
     
    </tr>
    <?php
  $i++;
   } 
   ?>
  </tbody>
  </table>
</form>
  <?php } 
  }
?>
</div>