Gecko [ www.stclareschooldimapur.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
vendors	[ DIR ]	drwxr-xr-x
activitycalendar.php	9.01 KB	-rw-r--r--
add10topper.php	7.01 KB	-rw-r--r--
add12topper.php	7.01 KB	-rw-r--r--
addaboutus.php	6.13 KB	-rw-r--r--
addaward.php	4.1 KB	-rw-r--r--
addbanner.php	5.38 KB	-rw-r--r--
adddetailmessage.php	6.19 KB	-rw-r--r--
addevent.php	7.61 KB	-rw-r--r--
addfacility.php	4.2 KB	-rw-r--r--
addfeesdata.php	8.46 KB	-rw-r--r--
addfeesheading.php	6.37 KB	-rw-r--r--
addgeninfo.php	5.12 KB	-rw-r--r--
addhistory.php	4.19 KB	-rw-r--r--
addintro.php	4.15 KB	-rw-r--r--
addmissionwithdrawal.php	9.05 KB	-rw-r--r--
addmoment.php	5.41 KB	-rw-r--r--
addnotice.php	6.29 KB	-rw-r--r--
addphotogallery.php	5.44 KB	-rw-r--r--
addphotos.php	4.89 KB	-rw-r--r--
addschoolinformation.php	4.26 KB	-rw-r--r--
addvision.php	4.19 KB	-rw-r--r--
admin.php	5.24 KB	-rw-r--r--
administration.php	8.99 KB	-rw-r--r--
assesment.php	8.94 KB	-rw-r--r--
booklist.php	8.93 KB	-rw-r--r--
cocurricular.php	9.01 KB	-rw-r--r--
contactlist.php	5.53 KB	-rw-r--r--
curriculum.php	9.36 KB	-rw-r--r--
dashboard.php	40.13 KB	-rw-r--r--
editfooter.php	18.56 KB	-rw-r--r--
examination.php	8.96 KB	-rw-r--r--
find.php	4.27 KB	-rw-r--r--
geninfo.php	5.03 KB	-rw-r--r--
index.php	31.9 KB	-rw-r--r--
list10topper.php	5.68 KB	-rw-r--r--
list12topper.php	5.68 KB	-rw-r--r--
listaboutus.php	5.36 KB	-rw-r--r--
listaward.php	5.23 KB	-rw-r--r--
listbanner.php	5.35 KB	-rw-r--r--
listdetailmessage.php	5.54 KB	-rw-r--r--
listevent.php	5.77 KB	-rw-r--r--
listfacility.php	5.25 KB	-rw-r--r--
listfeesdata.php	5.57 KB	-rw-r--r--
listfeesheading.php	5.37 KB	-rw-r--r--
listhistory.php	5.25 KB	-rw-r--r--
listintro.php	5.25 KB	-rw-r--r--
listmoment.php	5.36 KB	-rw-r--r--
listnotice.php	5.57 KB	-rw-r--r--
listphotogallery.php	5.4 KB	-rw-r--r--
listphotos.php	5.58 KB	-rw-r--r--
listschoolinformation.php	5.33 KB	-rw-r--r--
listvision.php	5.24 KB	-rw-r--r--
logout.php	302 B	-rw-r--r--
profile.php	9.74 KB	-rw-r--r--
rules.php	8.94 KB	-rw-r--r--
sportcorner.php	8.9 KB	-rw-r--r--
studenttcdetails.php	5.87 KB	-rw-r--r--

Code Editor : studenttcdetails.php

<?php
require('include/header.php');

// for category status "Active & Deactive"-----------------------------------------------------------------------------

if(isset($_GET['type']) && $_GET['type']!=''){
   $type=get_safe_value($con, $_GET['type']);
   if($type=='status'){
      $operation=get_safe_value($con, $_GET['operation']);
      $id=get_safe_value($con, $_GET['id']);

if($operation=='active'){
         $status=1;

}else{
         $status=0;
      }

$update_status_sql="update tc set status='$status' where id='$id'";
      mysqli_query($con,$update_status_sql);

}

//For Delete categories-----------------------------------------------------------------------------------
   if($type=='delete'){
           $id=get_safe_value($con, $_GET['id']);

$delete_sql="delete from tc where id='$id'";
      mysqli_query($con,$delete_sql);

}

}
//For Delete categories------------------------------------------------------------------------------------
$sql="select * from tc order by id asc";
$res=mysqli_query($con, $sql); 
?>

<div class="breadcrumbs">
            <div class="col-sm-4">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1>Student Tc Details</h1>
                    </div>
                </div>
            </div>
          
        </div>

<div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <strong class="card-title">Contact us List</strong>

</div>

</div>
                          
                            <div class="card-body">
                                <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                    <thead>
                                        <tr>
                                        <th class="serial">#</th>
                                            <th>Name</th>
                                            <th>Admission No.</th>
                                               <th>Class</th>
                                                  <th>Mobile No.</th>
                                                     <th>Date</th>
                                                        <th>Resson</th>
                                                           <th>Address</th>
                                            <th>Status</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    $i=1;
                                    while($row=mysqli_fetch_assoc($res)){ ?>
                                       
                                    <tr>
                                        <tr>
                                        <td class="serial"><?php echo $i ?></td>
                                               
                                       <td> <?php echo $row['name'] ?></td>
                                        <td> <?php echo $row['admission'] ?></td>
                                         <td> <?php echo $row['class'] ?></td>
                                          <td> <?php echo $row['mobile'] ?></td>
                                           <td> <?php echo $row['date'] ?></td>
                                        <td> <?php echo $row['resson'] ?></td>
                                       
                                        <td> <?php echo $row['address'] ?></td>
                                       
                                         
                                       
                                      
                                       
                                            <td> <?php
                                          if($row['status']==1){
                                             echo "<span class='badge badge-complete'><a href='?type=status&operation=deactive&id=".$row['id']."'>Active</a></span>&nbsp &nbsp";

}else{
                                             echo "<span class='badge badge-pending'><a href='?type=status&operation=active&id=".$row['id']."'> Deactive</a></span>&nbsp &nbsp";

}
                     // for edit button code
                                          
                                          echo "<span class='badge badge-edit'><a href='addaboutus.php?id=".$row['id']."'> Edit</a></span> ";
                                          
                                          
                                          //for delete button code
                                          // echo "<a href='?type=delete&id=".$row['id']."'> Delete</a> ";
                                          echo "<span class='badge badge-delete'><a href='?type=delete&id=".$row['id']."'> Delete</a></span>&nbsp ";

?>
                                       </td>                                      
                                    </tr>
                                    <?php $i++; }  ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>
            </div>
        </div>

</div>

<?php
require('include/footer.php');
?>

${this.title}

Code Editor : studenttcdetails.php