D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
saravanabhavan
/
domains
/
hotelshrisaravanabhavan.com
/
public_html
/
admin
/
Filename :
gallery_list.php
back
Copy
<?php include("session.php"); ?> <!DOCTYPE html> <!--[if IE 8]> <html lang="en" class="ie8"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8" /> <title>Admin</title> <meta content="width=device-width, initial-scale=1.0" name="viewport" /> <meta content="" name="description" /> <meta content="" name="author" /> <link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" /> <link href="assets/bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet" /> <link href="assets/font-awesome/css/font-awesome.css" rel="stylesheet" /> <link href="css/style.css" rel="stylesheet" /> <link href="css/style_responsive.css" rel="stylesheet" /> <link href="css/style_default.css" rel="stylesheet" id="style_color" /> <link href="assets/fancybox/source/jquery.fancybox.css" rel="stylesheet" /> <link rel="stylesheet" type="text/css" href="assets/uniform/css/uniform.default.css" /> </head> <?php include("connection.php"); ?> <!-- END HEAD --> <!-- BEGIN BODY --> <body class="fixed-top"> <!-- BEGIN HEADER --> <?php include("header.php"); ?> <!-- END HEADER --> <!-- BEGIN CONTAINER --> <div id="container" class="row-fluid"> <!-- BEGIN SIDEBAR --> <div id="sidebar" class="nav-collapse collapse"> <div class="sidebar-toggler hidden-phone"></div> <!-- BEGIN RESPONSIVE QUICK SEARCH FORM --> <div class="navbar-inverse"> <form class="navbar-search visible-phone"> <input type="text" class="search-query" placeholder="Search" /> </form> </div> <!-- END RESPONSIVE QUICK SEARCH FORM --> <!-- BEGIN SIDEBAR MENU --> <?php include("sidemenu.php"); ?> <!-- END SIDEBAR MENU --> </div> <!-- END SIDEBAR --> <!-- BEGIN PAGE --> <div id="main-content"> <!-- BEGIN PAGE CONTAINER--> <div class="container-fluid"> <!-- BEGIN PAGE HEADER--> <div class="row-fluid"> <div class="span12"> <!-- BEGIN THEME CUSTOMIZER--> <div id="theme-change" class="hidden-phone"> <i class="icon-cogs"></i> <span class="settings"> <span class="text">Theme:</span> <span class="colors"> <span class="color-default" data-style="default"></span> <span class="color-gray" data-style="gray"></span> <span class="color-purple" data-style="purple"></span> <span class="color-navy-blue" data-style="navy-blue"></span> </span> </span> </div> <!-- END THEME CUSTOMIZER--> <!-- BEGIN PAGE TITLE & BREADCRUMB--> <h3 class="page-title"> <small></small> </h3> <ul class="breadcrumb"> <li> <a href="#"><i class="icon-home"></i></a><span class="divider"> </span> </li> <li> <a href="#">Gallery</a> <span class="divider"> </span> </li> <li><a href="#">Gallery List </a><span class="divider-last"> </span></li> </ul> <!-- END PAGE TITLE & BREADCRUMB--> </div> </div> <!-- END PAGE HEADER--> <!-- BEGIN PAGE CONTENT--> <!-- BEGIN ADVANCED TABLE widget--> <div class="row-fluid"> <div class="span12"> <!-- BEGIN EXAMPLE TABLE widget--> <div class="widget"> <div class="widget-title"> <h4><i class="icon-reorder"></i>Managed Table</h4> <span class="tools"> <a href="javascript:;" class="icon-chevron-down"></a> <a href="javascript:;" class="icon-remove"></a> </span> </div> <div class="widget-body"> <form name="form1" method="post" action="gallery_list.php" id="frm1" > <table class="table table-striped table-bordered" id="#sample_1"> <thead> <tr> <th style="width:8px;"><input type="checkbox" class="group-checkable" data-set="#sample_1 .checkboxes" /></th> <th style="color:#000;">Gallery Title</th> <th style="color:#000;">Image 1</th> <th style="color:#000; display:none;">Gallery Sub Title</th> <th class="hidden-phone" style="color:#000;">Edit</th> </tr> </thead> <?php $sql="SELECT * FROM gallery, gallery_title where gallery.GalleryTitleID=gallery_title.GalleryTitleID order by gallery.GalleryID DESC"; $result=mysql_query($sql); ?> <tbody> <?php if (@mysql_num_rows($result)!=0) while($row = mysql_fetch_array($result)) { ?> <tr class="odd gradeX"> <td><input class="checkboxes" name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['GalleryID']; ?>" /></td> <td style="color:#000;"><?php echo $row['GalleryTitle']; ?></td> <td style="color:#000;"><?php echo $row['GalleryImg']; ?></td> <td style="color:#000; display:none;"><?php echo $row['GallerySubtitle']; ?></td> <td class="hidden-phone"><a href="gallery_edit.php?id=<?php echo $row['GalleryID']; ?>"><i class="icon-edit"></i></a></td> </tr> <?php } ?> </tbody> </table> <div><input type="submit" class="btn btn-success" name="delete" value="Delete"></div> </form> </div> </div> <!-- END EXAMPLE TABLE widget--> </div> </div> <!-- END ADVANCED TABLE widget--> <!-- END PAGE CONTENT--> </div> <!-- END PAGE CONTAINER--> </div> <!-- END PAGE --> </div> <!-- END CONTAINER --> <?php // Check if delete button active, start this if(isset($_POST['delete'])){ for($i=0;$i<count($_POST['checkbox']);$i++){ $del_id=$_POST['checkbox'][$i]; $sql = "SELECT * FROM gallery WHERE GalleryID='$del_id'"; $result = mysql_query($sql); $rrow=@mysql_fetch_array($result); if(result) { unlink('images/gallery/'.$rrow['GalleryImg'].''); if($del_id=$_POST['checkbox'][$i]) { $sql = "DELETE FROM gallery WHERE GalleryID ='$del_id'"; $result = mysql_query($sql); } } } // if successful redirect to delete_multiple.php if($result){ echo "<meta http-equiv=\"refresh\" content=\"0;URL=gallery_list.php\">"; } } mysql_close(); ?> <!-- BEGIN FOOTER --> <?php include("footer.php"); ?> <!-- END FOOTER --> <!-- BEGIN JAVASCRIPTS --> <!-- Load javascripts at bottom, this will reduce page load time --> <script src="js/jquery-1.8.3.min.js"></script> <script src="assets/bootstrap/js/bootstrap.min.js"></script> <script src="js/jquery.blockui.js"></script> <!-- ie8 fixes --> <!--[if lt IE 9]> <script src="js/excanvas.js"></script> <script src="js/respond.js"></script> <![endif]--> <script type="text/javascript" src="assets/uniform/jquery.uniform.min.js"></script> <script type="text/javascript" src="assets/data-tables/jquery.dataTables.js"></script> <script type="text/javascript" src="assets/data-tables/DT_bootstrap.js"></script> <script src="js/scripts.js"></script> <script> jQuery(document).ready(function() { // initiate layout and plugins App.init(); }); </script> </body> <!-- END BODY --> </html>