Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | include "head.php"; |
||
3 | include "config.php"; |
||
4 | $program_id_transfer = $_GET['program_id']; |
||
5 | $db = mysql_connect("localhost", "linwin"); |
||
6 | mysql_select_db("linwin", $db); |
||
7 | mysql_query("SET NAMES 'utf8';", $db); |
||
8 | $sql = "SELECT manufacturer, name, description FROM program WHERE id = ". $program_id_transfer; |
||
9 | $query=mysql_query($sql, $db); |
||
10 | $num_record = mysql_num_rows($query); |
||
11 | $mas_program_manufacturer = mysql_result($query,$i,0); |
||
12 | $mas_program_name = mysql_result($query,$i,1); |
||
13 | $mas_program_description = mysql_result($query,$i,2); |
||
14 | print " |
||
15 | <table> |
||
16 | <tr><td><b>Производитель:</b></td><td>$mas_program_manufacturer</td></tr> |
||
17 | <tr><td><b>Название программы:</b></td><td>$mas_program_name</td></tr> |
||
18 | <tr><td><b>Описание программы:</b></td><td>$mas_program_description</td></tr>"; |
||
19 | $sql = "SELECT sid FROM prog_in_sect WHERE pid = ". $program_id_transfer; |
||
20 | $query=mysql_query($sql, $db); |
||
21 | $num_record = mysql_num_rows($query); |
||
22 | for($i = 0; $i < $num_record; $i++) |
||
23 | $mas_prog_in_sect_id[] = mysql_result($query,$i,0); |
||
24 | $sql_part = "('". $mas_prog_in_sect_id[0]; |
||
25 | for ($i = 1; $i < count($mas_prog_in_sect_id); $i++) |
||
26 | { |
||
27 | $sql_part = $sql_part. "','". $mas_prog_in_sect_id[$i]; |
||
28 | } |
||
29 | $sql_part = $sql_part. "')"; |
||
30 | $sql = "SELECT id, name, description FROM section WHERE id in ". $sql_part. " ORDER BY name"; |
||
31 | $query = mysql_query($sql, $db); |
||
32 | $mas_section_id = array(); |
||
33 | $mas_section_name = array(); |
||
34 | $num_record = mysql_num_rows($query); |
||
35 | for ($i = 0; $i < $num_record; $i++) |
||
36 | { |
||
37 | $mas_section_id[] = mysql_result($query, $i, 0); |
||
38 | $mas_section_name[] = mysql_result($query, $i, 1); |
||
39 | $mas_section_description[] = mysql_result($query, $i, 2); |
||
40 | } |
||
41 | |||
42 | print "<tr><td><b>Группы, в которые входит программа:</b></td><td><table>"; |
||
43 | for ($i = 0; $i < count($mas_section_id); $i++) |
||
44 | { |
||
45 | print "<tr><td><a href = \"view_section_wood.php?section_id=$mas_section_id[$i]\">$mas_section_name[$i]</a></td></tr>"; |
||
46 | } |
||
47 | print " |
||
48 | </table> |
||
49 | <br/>"; |
||
50 | |||
51 | //Загружаем УРЛ связанные с программой |
||
52 | $sql = "SELECT url, description, local_mirror FROM url WHERE pid = ". $program_id_transfer; |
||
53 | $query = mysql_query($sql, $db); |
||
54 | $mas_url_url = array(); |
||
55 | $mas_url_description = array(); |
||
56 | $mas_url_local_mirror = array(); |
||
57 | $num_record = mysql_num_rows($query); |
||
58 | for ($i = 0; $i < $num_record; $i++) |
||
59 | { |
||
60 | $mas_url_url[] = mysql_result($query, $i, 0); |
||
61 | $mas_url_description[] = mysql_result($query, $i, 1); |
||
62 | $mas_url_local_mirror[] = mysql_result($query, $i, 2); |
||
63 | } |
||
64 | mysql_close($db); |
||
65 | print "<tr><td><b>URL связанные с программой:</b></td><td><table>"; |
||
66 | for ($i = 0; $i < count($mas_url_url); $i++) |
||
67 | { |
||
68 | if ($mas_url_local_mirror[$i] ==1) |
||
69 | print "<tr><td><a href = \"$base_url_software/$mas_url_url[$i]\">$mas_url_description[$i](Локальное зеркало)</a></td></tr>"; |
||
70 | else |
||
71 | print "<tr><td><a href = \"$mas_url_url[$i]\">$mas_url_description[$i]</a></td></tr>"; |
||
72 | } |
||
73 | print " |
||
74 | </table> |
||
75 | </td> |
||
76 | </tr></table>"; |
||
77 | |||
78 | include "foot.php"; |
||
79 | ?> |