1#@!#!123s

https 1#@!#!123s
: / proc / self / root / home / mahadevanandsiva / www / admin /
Filename : career.php
back
<?php 
include "header.php";

include "connection.php";
$editflag= (isset($_REQUEST['flag']) ? strip_tags($_REQUEST['flag']): 0);
if ($editflag==2)
{   echo "yes";
    $cid = (isset($_REQUEST['id']) ? strip_tags($_REQUEST['id']): 0);
    $sqli = "delete  from career where id='$cid'";
    mysqli_query($con,$sqli);
    echo '<script>location.href="career.php"</script>';
}


?>
<div class="app-content content">
      <div class="content-wrapper">
      	<div class="col-md-12 bg-white"style="height:100%;">
      		<div class="col-md-4">
      			<h4> Careers</h4>    	
      		</div>
      		<br>
      		<br>
      		<table id="dtBasicExample" class="table table-striped table-bordered table-sm" cellspacing="0" width="100%">
  <thead style="background:#136285;color:white;">
    <tr>
      <!-- <th scope="col">#</th> -->
      <th scope="col">Date</th>
      <th scope="col">Name</th>
      <th scope="col">Email</th>
      <th scope="col">Phone</th>
      <th scope="col">Subject</th>
      <th scope="col">Message</th>
      <th scope="col">Actions</th>
    </tr>
  </thead>
  <tbody>
  	<?php 
    $sql = mysqli_query($con,"select * from career order by id desc");
	while ($row = mysqli_fetch_assoc($sql))
	{
    $cnt = mysqli_num_rows($sql); // Get the number of rows in the result set
    ?>
			<tr>
		      <!-- <th scope="row"></th> -->
		      <td><?php echo date('d/m/Y',strtotime($row['date'])); ?></td>
		      <td><?php echo $row['name'];?></td>
              <td><?php echo $row['email'];?></td>
              <td><?php echo $row['phone'];?></td>
              <td><?php echo $row['subject'];?></td>
              <td><?php echo $row['message'];?></td>
              <td><a href="career.php?id=<?php echo $row['id']; ?>&flag=2" class="btn btn-danger">Delete</button></td>
		    </tr>
			<?php

		}
  	?>

    
    
  </tbody>
</table>
<?php 
      $to=($cnt/6)+1;
        for($i=1;$i<=$to;$i++)
        {
      ?>
      <a class="btn btn-secondary text-white" href="career.php?page=<?php echo $i; ?>"><?php echo $i; ?></a>
      <?php   
        }
      ?>
      		
      	</div>
      </div>
  </div>
  <?php
  include "footer.php";
  ?>
  <script type="text/javascript">
  	
      function del(val)
      {
         $.ajax({
          url: "ajax.php",
          type:"post",
          data:{v:val,type:'5'},
           success: function(result){
               alert(result);
               location.reload();
          }
        });
      } 
      
   function edit(val)
   {
      $.ajax({
          url: "ajax.php",
          type:"post",
          data:{v:val,type:'6'},
           success: function(result){
            $("#frm").html(result);
               
          }
        });
      }
       
       
  </script>