Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | session_start(); |
||
3 | if ($_SESSION['$user_privileges'] < 16) |
||
4 | header("Location: index.php"); |
||
5 | include "head.php"; |
||
6 | $search = $_GET['search']; |
||
7 | $db = mysql_connect("localhost", "linwin"); |
||
8 | mysql_select_db("linwin", $db); |
||
9 | mysql_query("SET NAMES 'utf8';", $db); |
||
10 | |||
11 | $sql = "SELECT id, name, description FROM program WHERE name like '%". $search. "%' or description like '%". $search. "%' ORDER BY name"; |
||
12 | $query = mysql_query($sql, $db); |
||
13 | $num_program = mysql_num_rows($query); |
||
14 | $mas_program_id = array(); |
||
15 | $mas_program_name = array(); |
||
16 | for ($i = 0; $i < $num_program; $i++) |
||
17 | { |
||
18 | $mas_program_id[$i] = mysql_result($query, $i, 0); |
||
19 | $mas_program_name[$i] = mysql_result($query, $i, 1); |
||
20 | $mas_program_description[$i] = mysql_result($query, $i, 2); |
||
21 | } |
||
22 | |||
23 | $sql = "SELECT id, name, description FROM section WHERE name like '%". $search. "%' or description like '%". $search. "%' ORDER BY name"; |
||
24 | $query = mysql_query($sql, $db); |
||
25 | $num_section = mysql_num_rows($query); |
||
26 | $mas_section_id = array(); |
||
27 | $mas_section_name = array(); |
||
28 | $mas_section_description = array(); |
||
29 | for ($i = 0; $i < $num_section; $i++) |
||
30 | { |
||
31 | $mas_section_id[$i] = mysql_result($query, $i, 0); |
||
32 | $mas_section_name[$i] = mysql_result($query, $i, 1); |
||
33 | $mas_section_description[$i] = mysql_result($query, $i, 2); |
||
34 | } |
||
35 | mysql_close($db); |
||
36 | print " |
||
37 | <p><b>Найденные группы:</b></p> |
||
38 | <hr/> |
||
39 | <table width = \"100%\"> |
||
40 | <tr> |
||
41 | <td><b>Название группы</b></td> |
||
42 | <td><b>Описание</b></td> |
||
43 | </tr> |
||
44 | <tr> |
||
45 | <td><br/></td> |
||
46 | <td><br/></td> |
||
47 | </tr>"; |
||
48 | for ($i = 0; $i < $num_section; $i++) |
||
49 | { |
||
50 | print " |
||
51 | <tr><td><a href = edit_section.php?section_id=$mas_section_id[$i]>$mas_section_name[$i]</td> |
||
52 | <td>$mas_section_description[$i]</td></tr>"; |
||
53 | } |
||
54 | print "</table>"; |
||
55 | |||
56 | print " |
||
57 | <p><b>Найденные программы:</b></p> |
||
58 | <hr/> |
||
59 | <table width = \"100%\"> |
||
60 | <tr> |
||
61 | <td><b>Название программы</b></td> |
||
62 | <td><b>Описание</b></td> |
||
63 | </tr> |
||
64 | <tr> |
||
65 | <td><br/></td> |
||
66 | <td><br/></td> |
||
67 | </tr>"; |
||
68 | for ($i = 0; $i < $num_program; $i++) |
||
69 | { |
||
70 | #echo "<tr><td class = \"border-tb\">$mas_program_name[$i]</td></tr>"; |
||
71 | print " |
||
72 | <tr><td><a href = edit_program.php?program_id=$mas_program_id[$i]>$mas_program_name[$i]</td> |
||
73 | <td>$mas_program_description[$i]</td></tr>"; |
||
74 | } |
||
75 | print "</table>"; |
||
76 | include "foot.php"; |
||
77 | ?> |