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

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

Назад
<?php include("Connecter/dataconn.php"); ?> <?php $added=" where archived='No'"; $added2=" where archived='Yes'"; $ss="Displaying All"; if(isset($_POST['dmonth2'])){ if ($_POST['dmonth2']=='All') { $added=$added; $added2=$added2; $ss= "Displaying All"; } else { $added=$added . " and dob LIKE '%" . $_POST['dmonth2'] . "%'"; $added2=$added2 . " and dob LIKE '%" . $_POST['dmonth2'] . "%'"; $ss= "Displaying Priests Born in " . $_POST['dmonth2']; } } if(isset($_POST['dmonth'])){ if ($_POST['dmonth']=='All') { if ($_POST['dyear']=='') { $added=$added; $added2=$added2; $ss= "Displaying All"; } else { $added=$added . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dyear'] . "%'"; $added2=$added2 . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dyear'] . "%'"; $ss= "Displaying Priests Ordained in " . $_POST['dyear']; } } else { if ($_POST['dyear']=='') { $added=$added . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dmonth'] . "%'"; $added2=$added2 . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dmonth'] . "%'"; $ss= "Displaying Priests Ordained in " . $_POST['dmonth']; } else { $added=$added . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dmonth'] . "%' and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dyear'] . "%'"; $added2=$added2 . " and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dmonth'] . "%' and date_format(ordination,'%Y %b %d') LIKE '%" . $_POST['dyear'] . "%'"; $ss= "Displaying Priests Ordained in " . $_POST['dmonth'] . " " . $_POST['dyear']; } } } ?> <!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="headingbiggest">Umuahia Diocesan Priests</div> <hr /> <form method="post" name="search" id="search"> <table width="86%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#F7F7F7"> <tr> <td align="center" bgcolor="#E9E9E9"><b>Search By Ordination</b></td> <td align="center" valign="middle" bgcolor="#E9E9E9"><strong>Month: <select name="dmonth" id="dmonth"> <option value="All">All</option> <option value="Jan">January</option> <option value="Feb">February</option> <option value="Mar">March</option> <option value="Apr">April</option> <option value="May">May</option> <option value="Jun">June</option> <option value="Jul">July</option> <option value="Aug">August</option> <option value="Sep">September</option> <option value="Oct">October</option> <option value="Nov">November</option> <option value="Dec">December</option> </select> </strong></td> <td align="center" valign="middle" bgcolor="#E9E9E9"><strong>Year: <input name="dyear" id="dyear" type="number" maxlength="4" size="5" min="1900" max="3000"> </strong></td> <td align="center" valign="middle" bgcolor="#E9E9E9"> <input name="button2" type="submit" class="style14" id="button2" value=" Search " /></td> <td align="center" valign="middle" bgcolor="#E9E9E9"><b><a href="priests1.php">Show All</a></b></td> </tr> </table> </form> <!-- <form method="post" name="search2" id="search2"> <table width="86%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#F7F7F7"> <tr> <td align="center" bgcolor="#E9E9E9"><b>Search By Birthday   </b></td> <td align="center" valign="middle" bgcolor="#E9E9E9"><strong>Month: <select name="dmonth2" id="dmonth2"> <option value="All">All</option> <option value="Jan">January</option> <option value="Feb">February</option> <option value="Mar">March</option> <option value="Apr">April</option> <option value="May">May</option> <option value="Jun">June</option> <option value="Jul">July</option> <option value="Aug">August</option> <option value="Sep">September</option> <option value="Oct">October</option> <option value="Nov">November</option> <option value="Dec">December</option> </select> </strong></td> <td align="center" valign="middle" bgcolor="#E9E9E9"> <input name="button3" type="submit" class="style14" id="button3" value=" Search " /></td> <td align="center" valign="middle" bgcolor="#E9E9E9"><b><a href="priests1.php">Show All</a></b></td> </tr> </table> </form> --> <hr /><div class="headingbigger"><?php echo $ss; ?></div><hr /> <div class="headingstyled">Priests of the Diocese</div> <?php $query_dio = "SELECT ,date_format(ordination,'%Y %b %d') FROM priests" . $added . " and status='Umuahia Diocesan Priest' order by namer asc"; $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) { $gv=1; ?> <table width="100%" cellspacing="2" cellpadding="3" style="border-collapse: separate; border-spacing: 2px;"> <tr valign="top"> <td width="2%" style="background-color:#333333; color:#FFFFFF"> </td> <td width="40%" style="background-color:#333333; color:#FFFFFF"><b>Name</b></td> <td width="18%" style="background-color:#333333; color:#FFFFFF"><b>Ordination</b></td> <!--<td width="10%" style="background-color:#333333; color:#FFFFFF"><b>Birthday</b></td>--> <td width="20%" style="background-color:#333333; color:#FFFFFF"><b>E-mail</b></td> <!--<td width="10%" style="background-color:#333333; color:#FFFFFF"><b>Phone</b></td>--> </tr> <?php do { ?><tr valign="top"> <td bgcolor="#d9d9d9"><?php echo $gv; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio['namer']; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio["date_format(ordination,'%Y %b %d')"]; ?></td> <!--<td bgcolor="#d9d9d9"><?php echo $row_dio['dob']; ?></td>--> <td bgcolor="#d9d9d9"><?php echo $row_dio['email']; ?></td> <!--<td bgcolor="#d9d9d9"><?php echo $row_dio['phone']; ?></td>--> </tr> <?php $gv++; } while ($row_dio = mysql_fetch_assoc($dio)); ?> </table> <?php } else { echo ("None!"); } ?> <!-- <?php $query_dio = "SELECT ,date_format(ordination,'%Y %b %d') FROM priests" . $added2 . " and status='Umuahia Diocesan Priest' order by namer asc"; $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) { $gv=1; ?> <hr /><div class="headingbigger">Deceased Priests</div><hr /> <table width="100%" cellspacing="2" cellpadding="3"> <tr valign="top"> <td width="2%" style="background-color:#333333; color:#FFFFFF"> </td> <td width="40%" style="background-color:#333333; color:#FFFFFF"><b>Name</b></td> <td width="18%" style="background-color:#333333; color:#FFFFFF"><b>Ordination</b></td> <td width="10%" style="background-color:#333333; color:#FFFFFF"><b>Birthday</b></td> <td width="20%" style="background-color:#333333; color:#FFFFFF"><b>E-mail</b></td> <td width="10%" style="background-color:#333333; color:#FFFFFF"><b>Phone</b></td> </tr> <?php do { ?><tr valign="top"> <td bgcolor="#d9d9d9"><?php echo $gv; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio['namer']; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio["date_format(ordination,'%Y %b %d')"]; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio['dob']; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio['email']; ?></td> <td bgcolor="#d9d9d9"><?php echo $row_dio['phone']; ?></td> </tr> <?php $gv++; } while ($row_dio = mysql_fetch_assoc($dio)); ?> </table> <?php } ?> --> <!--Content Ends here--> <?php include("mainbarbottom.php"); ?> <?php include("contentbottom.php"); ?> <?php include("footbar.php"); ?> <?php include("bottom.php"); ?> </body> </html>

| ver. 1.4 | Github | . | PHP 5.6.40 | Генерация страницы: 0 | proxy | phpinfo | Настройка