Файловый менеджер

Файловый менеджер - Редактировать - /home/umudio/public_html/OLD/listinstitutions.php

Назад
<?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 institutions where sn = %s", mysql_real_escape_string($deltab)); $result=mysql_query($sql,$csn) or die(mysql_error()); } $query_dio1 = "SELECT * FROM institutions where status='Secondary School' order by nameadd"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $query_dio2 = "SELECT * FROM institutions where status='Primary/Nursery School' order by nameadd"; $dio2 = mysql_query($query_dio2, $csn) or die(mysql_error()); $row_dio2 = mysql_fetch_assoc($dio2); $totalRows_dio2 = mysql_num_rows($dio2); $query_dio3 = "SELECT * FROM institutions where status='Health Institution' order by nameadd"; $dio3 = mysql_query($query_dio3, $csn) or die(mysql_error()); $row_dio3 = mysql_fetch_assoc($dio3); $totalRows_dio3 = mysql_num_rows($dio3); $query_dio4 = "SELECT * FROM institutions where status='Pastoral/Vocational/Social Institution' order by nameadd"; $dio4 = mysql_query($query_dio4, $csn) or die(mysql_error()); $row_dio4 = mysql_fetch_assoc($dio4); $totalRows_dio4 = mysql_num_rows($dio4); $query_dio5 = "SELECT * FROM institutions where status='Ecclesiastical Establishment' order by nameadd"; $dio5 = mysql_query($query_dio5, $csn) or die(mysql_error()); $row_dio5 = mysql_fetch_assoc($dio5); $totalRows_dio5 = mysql_num_rows($dio5); $query_dio6 = "SELECT * FROM institutions where status='Media House' order by nameadd"; $dio6 = mysql_query($query_dio6, $csn) or die(mysql_error()); $row_dio6 = mysql_fetch_assoc($dio6); $totalRows_dio6 = mysql_num_rows($dio6); $query_dio7 = "SELECT * FROM institutions where status='Book Centre' order by nameadd"; $dio7 = mysql_query($query_dio7, $csn) or die(mysql_error()); $row_dio7 = mysql_fetch_assoc($dio7); $totalRows_dio7 = mysql_num_rows($dio7); $query_dio8 = "SELECT * FROM institutions where status='Chaplaincy' order by nameadd"; $dio8 = mysql_query($query_dio8, $csn) or die(mysql_error()); $row_dio8 = mysql_fetch_assoc($dio8); $totalRows_dio8 = mysql_num_rows($dio8); $query_dio9 = "SELECT * FROM institutions where status='Tertiary Institution' order by nameadd"; $dio9 = mysql_query($query_dio9, $csn) or die(mysql_error()); $row_dio9 = mysql_fetch_assoc($dio9); $totalRows_dio9 = mysql_num_rows($dio9); $query_dio10 = "SELECT * FROM institutions where status='Seminary/Formation House' order by nameadd"; $dio10 = mysql_query($query_dio10, $csn) or die(mysql_error()); $row_dio10 = mysql_fetch_assoc($dio10); $totalRows_dio10 = mysql_num_rows($dio10); $query_dio11 = "SELECT * FROM institutions where status='Other Establishment' order by nameadd"; $dio11 = mysql_query($query_dio11, $csn) or die(mysql_error()); $row_dio11 = mysql_fetch_assoc($dio11); $totalRows_dio11 = mysql_num_rows($dio11); ?> <!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"); ?> <?php include("textare.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="headingbiggest">Institutions of the Diocese</div> <p> </p> <hr /> <p style="color:#990000"><b>Add Institutions</b></p> <form id="form1" name="form1" method="post" action="dadmin.php"> <table width="100%" cellpadding="1" cellspacing="2"> <?php for($i=1; $i<=1; $i++){ ?> <tr valign="top"> <td style="text-align:left"><span style="font-weight:bold; color:#009900; font-size:30px;"><?php echo($i); ?></span></td> <td><b>Name/Address:</b><br /><textarea name="nameadd<?php echo($i); ?>" cols="60" rows="10"></textarea></td> </tr> <tr valign="top"> <td><b>Status:</b></td> <td><select name="status<?php echo($i); ?>"> <option value="Secondary School" selected="selected">Secondary School</option> <option value="Primary/Nursery School">Primary/Nursery School</option> <option value="Tertiary Institution">Tertiary Institution</option> <option value="Health Institution">Health Institution</option> <option value="Pastoral/Vocational/Social Institution">Pastoral/Vocational/Social Institution</option> <option value="Ecclesiastical Establishment">Ecclesiastical Establishment</option> <option value="Other Establishment">Other Establishment</option> <option value="Seminary/Formation House">Seminary/Formation House</option> <option value="Media House">Media House</option> <option value="Book Centre">Book Centre</option> <option value="Chaplaincy">Chaplaincy</option> </select></td> </tr> <tr valign="top"> <td> </td> <td><b>Other Details:</b><br /><textarea name="details<?php echo($i); ?>" cols="60" rows="10"></textarea></td> </tr> <tr><td colspan="2"><hr /></td></tr> <?php } ?> <tr valign="top"> <td style="text-align:right; font-size:10px;" colspan="4"><a href="dadmin.php">Cancel</a>       <input name="addinstitution" type="submit" style="font-size:12px;" id="addinstitution" value=" Add Institutions " /> </td> </tr> </table> </form> <hr /> <p style="color:#990000"><b>Existing Secondary Schools</b></p> <?php if ($totalRows_dio1>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio1['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio1['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio1['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Primary/Nursery Schools</b></p> <?php if ($totalRows_dio2>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio2['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio2['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio2['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio2 = mysql_fetch_assoc($dio2)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Tertiary Institution</b></p> <?php if ($totalRows_dio9>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio9['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio9['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio9['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio9 = mysql_fetch_assoc($dio9)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Health Institutions</b></p> <?php if ($totalRows_dio3>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio3['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio3['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio3['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio3 = mysql_fetch_assoc($dio3)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Pastoral/Vocational/Social Institutions</b></p> <?php if ($totalRows_dio4>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio4['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio4['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio4['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio4 = mysql_fetch_assoc($dio4)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Ecclesiastical Establishment</b></p> <?php if ($totalRows_dio5>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio5['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio5['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio5['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio5 = mysql_fetch_assoc($dio5)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Media Houses</b></p> <?php if ($totalRows_dio6>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio6['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio6['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio6['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio6 = mysql_fetch_assoc($dio6)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Book Centres</b></p> <?php if ($totalRows_dio7>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio7['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio7['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio7['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio7 = mysql_fetch_assoc($dio7)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Chaplaincies</b></p> <?php if ($totalRows_dio8>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio8['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio8['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio8['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio8 = mysql_fetch_assoc($dio8)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Other Establishments</b></p> <?php if ($totalRows_dio11>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio11['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio11['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio11['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio11 = mysql_fetch_assoc($dio11)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <hr /> <p style="color:#990000"><b>Existing Seminaries/Formation Houses</b></p> <?php if ($totalRows_dio10>0) { ?> <div class="post"> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo substr(strip_tags($row_dio10['nameadd']),0,40); ?></td> <td style="border-bottom:1px solid #333333;"><a href="editinstitution.php?tab=<?php echo $row_dio10['sn']; ?>">Edit</a>        \|        <a href="listinstituions.php?deltab=<?php echo $row_dio10['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio10 = mysql_fetch_assoc($dio10)); ?> </table> </div><div class="post-bot"></div> <?php } else { echo ("None Found!"); } ?> <p> </p> <p> </p><hr /> <p><a href="dadmin.php">Back to Admin Page</a></p> <!--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 | Настройка