Файловый менеджер - Редактировать - /home/umudio/public_html/searchannrecord.php
Назад
<?php session_start(); if (isset($_POST["username"]) && isset($_POST["password"])) { $manager = $_POST["username"]; $password = $_POST["password"]; include("includes/config.php"); $cmem = "SELECT id FROM auth WHERE username='$manager' AND password='$password' LIMIT 1"; $run_cmem = mysqli_query($con, $cmem); $count_mem = mysqli_num_rows($run_cmem); if ($count_mem == 1) { while ($row = mysqli_fetch_array($run_cmem)) { $id = $row["id"]; } $_SESSION["id"] = $id; $_SESSION["manager"] = $manager; $_SESSION["password"] = $password; header("location: mod-auth"); exit(); } else { echo "<script>alert('Incorrect Password !!!')</script>"; echo "<script>window.open('./','_self')</script>"; exit(); } } ?> <?php session_start(); if (!isset($_SESSION["manager"])) { header("location: ./"); exit(); } ?> <?php if($_POST['acc']=="bir"){ $att="dob"; $searchstring="Birthday Anniversary"; } if($_POST['acc']=="rec"){ $att="dateofreception"; $searchstring="Reception Anniversary"; } if($_POST['acc']=="nov"){ $att="dateofnovitiatereception"; $searchstring="Novitiate Anniversary"; } if($_POST['acc']=="sim"){ $att="simpleprofession"; $searchstring="Simple Profession Anniversary"; } if($_POST['acc']=="sol"){ $att="solemnprofession"; $searchstring="Solemn Profession Anniversary"; } if($_POST['acc']=="ord"){ $att="ordination"; $searchstring="Priestly Ordination Anniversary"; } if($_POST['acc']=="con"){ $att="consecrationasbishop"; $searchstring="Episcopal Ordination Anniversary"; } if($_POST['valbir']=="mo"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where month(" . $att . ") = " . $_POST['mobir'] . " order by namer asc"); if($_POST['mobir']==1){ $searchstring=$searchstring . " for the month of January"; } if($_POST['mobir']==2){ $searchstring=$searchstring . " for the month of February"; } if($_POST['mobir']==3){ $searchstring=$searchstring . " for the month of March"; } if($_POST['mobir']==4){ $searchstring=$searchstring . " for the month of April"; } if($_POST['mobir']==5){ $searchstring=$searchstring . " for the month of May"; } if($_POST['mobir']==6){ $searchstring=$searchstring . " for the month of June"; } if($_POST['mobir']==7){ $searchstring=$searchstring . " for the month of July"; } if($_POST['mobir']==8){ $searchstring=$searchstring . " for the month of August"; } if($_POST['mobir']==9){ $searchstring=$searchstring . " for the month of September"; } if($_POST['mobir']==10){ $searchstring=$searchstring . " for the month of October"; } if($_POST['mobir']==11){ $searchstring=$searchstring . " for the month of November"; } if($_POST['mobir']==12){ $searchstring=$searchstring . " for the month of December"; } } if($_POST['valbir']=="da"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where month(" . $att . ") = " . $_POST['birmo'] . " and dayofmonth(" . $att . ") = " . $_POST['birda'] . " order by namer asc"); if($_POST['birmo']==1){ $searchstring=$searchstring . " for the month of January " . $_POST['birda']; } if($_POST['birmo']==2){ $searchstring=$searchstring . " for the month of February " . $_POST['birda']; } if($_POST['birmo']==3){ $searchstring=$searchstring . " for the month of March " . $_POST['birda']; } if($_POST['birmo']==4){ $searchstring=$searchstring . " for the month of April " . $_POST['birda']; } if($_POST['birmo']==5){ $searchstring=$searchstring . " for the month of May " . $_POST['birda']; } if($_POST['birmo']==6){ $searchstring=$searchstring . " for the month of June " . $_POST['birda']; } if($_POST['birmo']==7){ $searchstring=$searchstring . " for the month of July " . $_POST['birda']; } if($_POST['birmo']==8){ $searchstring=$searchstring . " for the month of August " . $_POST['birda']; } if($_POST['birmo']==9){ $searchstring=$searchstring . " for the month of September " . $_POST['birda']; } if($_POST['birmo']==10){ $searchstring=$searchstring . " for the month of October " . $_POST['birda']; } if($_POST['birmo']==11){ $searchstring=$searchstring . " for the month of November " . $_POST['birda']; } if($_POST['birmo']==12){ $searchstring=$searchstring . " for the month of December " . $_POST['birda']; } } if($_POST['valbir']=="tod"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where month(" . $att . ") = month(curdate()) and dayofmonth(" . $att . ") = dayofmonth(curdate()) order by namer asc"); $searchstring=$searchstring . " for Today"; } if($_POST['valbir']=="an"){ if($_POST['anbir']!=""){ if($_POST['lilianbir']=="equal"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where (year(curdate()) - year(" . $att . ")) = " . $_POST['anbir'] . " order by namer asc"); $searchstring="Personnel celebrating " . $_POST['anbir'] . " years of " . $searchstring; } if($_POST['lilianbir']=="greater"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where (year(curdate()) - year(" . $att . ")) > " . $_POST['anbir'] . " and " . $att . "<>0 order by namer asc"); $searchstring="Personnel celebrating greater than " . $_POST['anbir'] . " years of " . $searchstring; } if($_POST['lilianbir']=="less"){ $sql = mysqli_query($con, "SELECT namer,date_format(" . $att . ", '%M %e %Y') from priests where (year(curdate()) - year(" . $att . ")) < " . $_POST['anbir'] . " order by namer asc"); $searchstring="Personnel celebrating less than " . $_POST['anbir'] . " years of " . $searchstring; } } }
| ver. 1.4 |
Github
|
.
| PHP 5.6.40 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка