Example #1
0
        if ($work == '' and $salary == 0) {
            $query = "SELECT id_employee, fio, name_post, DATE_FORMAT(datestart, '%d.%m.%Y') AS datestart, salary FROM employee INNER JOIN post ON employee.`id_post`=post.`id_post`";
        }
        $all = mysql_query($query);
    }
    if (mysql_num_rows($all) != 0) {
        for ($i = 0; $i < mysql_num_rows($all); $i++) {
            $allemployee = mysql_fetch_array($all);
            echo "\n                    <tr>\n                        <td id='paddingtd'>" . $allemployee[fio] . "</td>\n                        <td id='paddingtd'>" . $allemployee[name_post] . "</td>\n                        <td id='paddingtd' align='center'>" . $allemployee[datestart] . "</td>\n                        <td id='paddingtd'>" . $allemployee[salary] . "</td>\n                    </tr>\n                ";
        }
    }
    echo "</table>";
    exit;
}
include 'db_function.php';
echo "<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n<title> </title>\n<link rel=\"stylesheet\" type=\"text/css\" href=\"css/style.css\" />\n\n<!--Ajax-->\n<script type=\"text/javascript\" src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js\"></script>\n<script language='JavaScript' src='js/ajax.js'></script>\n\n</head><body>";
echo '<input type="radio" name="drink1" id="drink1" value="1" checked> 
     <label for="drink1" value="" id="">Поиск по ФИО и Должности</label>
   <input type="radio" name="drink1" id="drink2" value="2"> 
   <label for="drink2" value="" id="">Поиск по Дате и Окладу</label><br><br>';
echo "<input name='query' id='search_input' type='text'  size='51' maxlength='50' autocomplete='off'>\n    <a href='#' onclick='searchquery();'> Искать</a><br><br>";
sortpost(0, "", 0);
$all = mysql_query("SELECT id_employee, fio, name_post, DATE_FORMAT(datestart, '%d.%m.%Y') AS datestart, salary FROM employee INNER JOIN post ON employee.`id_post`=post.`id_post`");
if (mysql_num_rows($all) != 0) {
    for ($i = 0; $i < mysql_num_rows($all); $i++) {
        $allemployee = mysql_fetch_array($all);
        echo "\n            <tr>\n                <td id='paddingtd'>" . $allemployee[fio] . "</td>\n                <td id='paddingtd'>" . $allemployee[name_post] . "</td>\n                <td id='paddingtd' align='center'>" . $allemployee[datestart] . "</td>\n                <td id='paddingtd'>" . $allemployee[salary] . "</td>\n            </tr>\n        ";
    }
}
echo "</table></div>";
echo "</body></html>";
Example #2
0
                break;
            case "name_post":
                $post = $valorder[$k];
                break;
            case "datestart":
                $date = $valorder[$k];
                break;
            case "salary":
                $salary = $valorder[$k];
                break;
            default:
                break;
        }
    }
}
sortpost($fio, $post, $date, $salary);
// сортировка по результатам поиска
if (isset($_GET['n']) and isset($_GET['v']) or isset($_GET['s'])) {
    $nameorder = $_GET['n'];
    $valorder = $_GET['v'];
    $param = "fio,name_post,datestart,salary";
    $paramarray = array("fio", "name_post", "datestart", "salary");
    $query .= "SELECT id_employee, fio, name_post, DATE_FORMAT(datestart, '%d.%m.%Y') AS datestart, salary FROM employee INNER JOIN post ON employee.`id_post`=post.`id_post` ";
    if (isset($_GET['s']) and isset($_GET['num'])) {
        switch ($_GET['num']) {
            case 1:
                $query_where = " WHERE `fio` LIKE '%" . $_GET['s'] . "%' ";
                break;
            case 2:
                $query_where = " WHERE `name_post` LIKE '%" . $_GET['s'] . "%' ";
                break;