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 : booklist.php

<?php
require('include/header.php');
$heading='';
$discription='';
$msg='';
if(isset($_GET['id']) && $_GET['id']!=''){
   $image_required='';
   $id=get_safe_value($con,$_GET['id']);
   $res=mysqli_query($con,"select * from booklist where id='$id'");
   
   $check=mysqli_num_rows($res);
   if($check>0){
      $row=mysqli_fetch_assoc($res);
      $heading=$row['title'];
      $discription=$row['discription'];
      $image=$row['image'];
     
   }else{ 
     die();
   }
  
  
}

if(isset($_POST['submit'])){
   $heading=get_safe_value($con,$_POST['heading']);
   $discription=get_safe_value($con,$_POST['discription']);
   //$image=get_safe_value($con,$_POST['image']);

// 
$msg="";
if($msg==''){
   if(isset($_GET['id']) && $_GET['id']!=''){

$update_sql="update booklist set title='$heading',discription='$discription' where id='$id'";
      
      mysqli_query($con,$update_sql);

}
   
   else{
    
   mysqli_query($con,"insert into booklist(heading,discription,status,date_created) values('$heading','$discription',1, current_timestamp())");
}
}
}

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 booklist 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 booklist where id='$id'";
      mysqli_query($con,$delete_sql);

}

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

<div class="col-lg-12" style="display:block;">
                                                    <div class="card">
                                                        <div class="card-header">Add Booklist details
                                                        <div class="page-header float-right">
           
                </div>

</div>
                                                        <div class="card-body card-block">
                                                        <form method="post" enctype="multipart/form-data">
                                                                <div class="form-group">
                                                                    <div class="input-group">
                                                                        <div class="input-group-addon"><i class="fa fa-user"></i></div>
                                                                        <input type="text" id="heading" name="heading" placeholder="Heading" class="form-control" value="<?php echo $heading ?>">
                                                                    </div>
</div>
<div class="form-group">
                                                                    <div class="input-group">
                                                                        <div class="input-group-addon"><i class="fa fa-user"></i></div>
                                                                        <input type="text" id="discription" name="discription" placeholder="Subheading" class="form-control"  value="<?php echo $discription ?>">
                                                                    </div>
</div>

<div class="form-actions form-group"><button type="submit" name="submit" class="btn btn-success btn-sm">Submit</button></div>
                                                            </form>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="breadcrumbs">
            <div class="col-sm-4">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1>Booklist List</h1>
                    </div>
                </div>
            </div>
          
        </div>

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

<div class="page-header float-right">
                  
                </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>heading</th>
                                            <th>Discription</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['heading'] ?></td>
                                       <td> <?php echo $row['discription'] ?></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='booklist.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 : booklist.php