Файловый менеджер - Редактировать - /home/umudio/public_html/repo/listphotos.php.tar
Назад
home/umudio/public_html/OLD/listphotos.php 0000644 00000014430 14773626201 0014651 0 ustar 00 <?php if (!$_SESSION){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; if(isset($acc) && ($acc=="administratoroftheUmuahiasiteDiocese2016Byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php if (isset($_GET['deltab'])) { unset($temp); if(isset($_GET['deltab'])){ $_GET['deltab']=trim($_GET['deltab']); if(preg_match('/^[0-9]/u',$_GET['deltab'])){ settype($_GET['deltab'], 'int'); $temp=(int)$_GET['deltab']; } } if(!isset($temp)){echo "Sorry! Wrong Data!"; exit();} $deltab=$temp; $sql=sprintf("delete from photos where sn = %s", mysql_real_escape_string($deltab)); $result=mysql_query($sql,$csn) or die(mysql_error()); } $query_dio = "SELECT * FROM photos order by sn desc"; $dio = mysql_query($query_dio, $csn) or die(mysql_error()); $row_dio = mysql_fetch_assoc($dio); $totalRows_dio = mysql_num_rows($dio); $query_dio5 = "SELECT * FROM photocategory where archived='No' order by titler asc"; $dio5 = mysql_query($query_dio5, $csn) or die(mysql_error()); $row_dio5 = mysql_fetch_assoc($dio5); $totalRows_dio5 = mysql_num_rows($dio5); $query_dio3 = "SELECT * FROM photocategory where archived='No' order by titler asc"; $dio3 = mysql_query($query_dio3, $csn) or die(mysql_error()); $row_dio3 = mysql_fetch_assoc($dio3); $totalRows_dio3 = mysql_num_rows($dio3); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <?php include("head.php"); ?> </head> <body> <?php include("top.php"); ?> <?php include("titlebar.php"); ?> <?php include("mast.php"); ?> <?php include("navbar.php"); ?> <?php include("contenttop.php"); ?> <?php include("sidebar.php"); ?> <?php include("mainbartop.php"); ?> <!--Content Goes here--> <div class="headingstyled2">Photo Gallery…</div> <p class="headingbiggest"><b>Add New Photo</b></p> <form id="form1" name="form1" method="post" action="dadmin.php" enctype="multipart/form-data"> <table width="100%"> <tr valign="top"> <td style="font-weight:bold; text-align:right">Title</td> <td align="left" ><input name="titler" type="text" size="50" /></td> </tr> <tr valign="top"> <td style="font-weight:bold; text-align:right">Category</td> <td align="left" > <select name="category" id="category"> <option value="0" selected="selected" >No Category</option> <?php if ($totalRows_dio5>0) { ?> <?php do { ?> <option value="<?php echo ($row_dio5['sn']); ?>" ><?php echo ($row_dio5['titler']); ?></option> <?php } while ($row_dio5 = mysql_fetch_assoc($dio5)); ?> <?php } ?> </select> </td> </tr> <tr valign="top"> <td style="font-weight:bold; text-align:right">Photo</td> <td align="left" ><input type="file" name="uploader" size="40"></td> </tr> <tr valign="top"> <td style="text-align:right; font-size:10px;" colspan="2"><a href="dadmin.php">Cancel</a> <input name="addphoto" type="submit" style="font-size:12px;" id="addphoto" value=" Add Photo " /> </td> </tr> </table> </form> <hr /> <div class="headingbiggest">Existing Photos</div> <div class="headingnormal" style="background-color:#990000; color:#fff; padding: 5px 10px 5px 10px; margin:20px 0px 5px 0px;">No Category</div> <?php $query_dio = "SELECT * FROM photos where category=0 order by sn desc"; $dio = mysql_query($query_dio, $csn) or die(mysql_error()); $row_dio = mysql_fetch_assoc($dio); $totalRows_dio = mysql_num_rows($dio); ?> <?php if ($totalRows_dio>0) { ?> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo $row_dio['titler']; ?></td> <td style="border-bottom:1px solid #333333;"> <a href="editphoto.php?tab=<?php echo $row_dio['sn']; ?>">Edit</a> | <a href="listphotos.php?deltab=<?php echo $row_dio['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio = mysql_fetch_assoc($dio)); ?> </table> <?php } else { echo ("No Photo Added Yet!"); } ?> <?php if ($totalRows_dio3>0) { ?> <?php do { ?> <div class="headingnormal" style="background-color:#990000; color:#fff; padding: 5px 10px 5px 10px; margin:20px 0px 5px 0px;"><?php echo $row_dio3['titler']; ?></div> <?php $query_dio = "SELECT * FROM photos where category=" . $row_dio3['sn'] . " order by sn desc"; $dio = mysql_query($query_dio, $csn) or die(mysql_error()); $row_dio = mysql_fetch_assoc($dio); $totalRows_dio = mysql_num_rows($dio); ?> <?php if ($totalRows_dio>0) { ?> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo $row_dio['titler']; ?></td> <td style="border-bottom:1px solid #333333;"> <a href="editphoto.php?tab=<?php echo $row_dio['sn']; ?>">Edit</a> | <a href="listphotos.php?deltab=<?php echo $row_dio['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio = mysql_fetch_assoc($dio)); ?> </table> <?php } else { echo ("No Photo Added Yet!"); } ?> <?php } while ($row_dio3 = mysql_fetch_assoc($dio3)); ?> <?php } ?> <p> </p><hr /> <a href="dadmin.php">Back to Admin Page</a> <!--Content Ends here--> <?php include("mainbarbottom.php"); ?> <?php include("contentbottom.php"); ?> <?php include("footbar.php"); ?> <?php include("bottom.php"); ?> </body> </html> <?php } else { include("ddadmin.php"); }?>
| ver. 1.4 |
Github
|
.
| PHP 5.6.40 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка