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>";
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;