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