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 : listphotos.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 photo 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 photo where id='$id'";

mysqli_query($con,$delete_sql);

}

//For Delete categories------------------------------------------------------------------------------------

$sql="select photo.*,photogallery.htitle from photo,photogallery where photo.photogallery_id=photogallery.id order by photo.id desc";

$res=mysqli_query($con, $sql);

<h1>Dashboard</h1>

</div>

<strong class="card-title">Photo List</strong>

<li><a href="addphotos.php">Add Photo</a></li>

</ol>

</div>

<thead>

<tr>

<th>Gallery Title</th>

<th>Title</th>

<th>Image</th>

<th>Status</th>

</tr>

</thead>

<tbody>

<?php

$i=1;

while($row=mysqli_fetch_assoc($res)){ ?>

<tr>

<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='addphotos.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>

<?php

require('include/footer.php');

${this.title}

Code Editor : listphotos.php