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];
    $sql_del = mysqli_query($conn, "delete from tbl_video where id= " . $delid . "");
    $msg = "Record Deleted Successfully.";
    print "<script>";
    print "self.location = 'video.php?msg=$msg';";
    print "</script>";
}

if($_REQUEST['act']=='enable'){
  $adsid = $_REQUEST['adsid'];
  $sqlv = mysqli_query($conn, "UPDATE `tbl_video` SET view_status=0");
  $sql = mysqli_query($conn, "UPDATE `tbl_video` SET view_status=1 WHERE id='$adsid'");
  if($sql){
    print '<script>';
    print 'self.location="video.php";';
    print '</script>';
  }
}
$project_sql = mysqli_query($conn, "select * from tbl_video order by id desc");
$total = mysqli_num_rows($project_sql);
?>

<div class="content_header">
  <div class="heading flleft">Video Management</div>
  <div class="heading flright"> &nbsp;<a href="<?=$_curpage?>?q=add">Add New Video</a></div> 
   <?php
  $i = 1;
  $project_sql = mysqli_query($conn, "select * from tbl_video order by id desc");
  while ($row = mysqli_fetch_array($project_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) { ?>
  <table width="99%" border="1" bordercolor="#CCCCCC" cellspacing="0" cellpadding="3" align="center" class="datagrid" id="pagetable">
    <thead>
  <tr>
      <th width="42" align="center">S.N.</th>
      <th width="379" align="left" class="sort" onclick="sortdata('f.faculty_name')">Video Title</th>   
    <th width="465" align="left" class="sort" onclick="sortdata('f.faculty_designation')">Video Link</th> 
      <th width="219" align="left" class="sort" onclick="sortdata('f.faculty_designation')">Created_date</th>  
      <th width="219" align="left" class="sort" onclick="sortdata('f.faculty_designation')">show in Home page</th>  
    
      <th colspan="3" align="center">Actions</th>
    </tr>
  </thead>
  <tbody>
     <?php
  $i = 1;
  $project_sql = mysqli_query($conn, "select * from tbl_video order by id desc");
  while ($row = mysqli_fetch_array($project_sql)) {
  ?>
    
    <tr>
      <td align="center"><?php echo $i;?></td>
      <td align="left"><?php echo $row['video_title'];?></td>   
    <td align="left"><?php echo $row['video_link'];?></td>
    <td align="left"><?php echo $row['created_date'];?></td>
    
     <td align="center" width="48"><?php if($row['view_status']==1){?><img border="0" src="images/enable.png" align="Enable" title="Enable" style="height:20px; width:20px" /><?php }else{?>  <a href="video.php?act=enable&adsid=<?php print $row['id'] ?>"><img border="0" src="images/disable.png" align="Disable" title="Disable" style="height:20px; width:20px" /></a><?php }?>    </td>
      
    <td align="center" width="71"><a href="video.php?q=edit&id=<?php print $row['id'] ?>"><img border="0" src="images/edit.png" align="Edit" title="Edit" /></a></td>
      <td align="center" width="78"><a href="video.php?act=del&delid=<?php print $row['id'] ?>" onClick="javascript:return confirm('Are you sure to delete ?')"><img border="0" src="images/delete.png" align="Delete" title="Delete" /></a>      </td>
    </tr>
    <?php
  $i++;
   } 
   ?>
  </tbody>
  </table>
  <?php } 
  }
?>
</div>