Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | session_start(); |
||
3 | if ($_SESSION['$user_privileges'] < 16) |
||
4 | header("Location: index.php"); |
||
5 | include "head.php"; |
||
6 | include "config.php"; |
||
7 | $program_id = $_GET['program_id']; |
||
8 | $db = mysql_connect("localhost", "linwin"); |
||
9 | mysql_select_db("linwin", $db); |
||
10 | mysql_query("SET NAMES 'utf8';", $db); |
||
11 | $sql = "SELECT manufacturer, name, description FROM program WHERE id = ". $program_id; |
||
12 | $query=mysql_query($sql, $db); |
||
13 | $program_manufacturer = mysql_result($query,0,0); |
||
14 | $program_name = mysql_result($query,0,1); |
||
15 | $program_description = mysql_result($query,0,2); |
||
16 | $sql = "SELECT id, url, description FROM url WHERE pid = ". $program_id. " ORDER BY description"; |
||
17 | $query = mysql_query($sql, $db); |
||
18 | $mas_url_id = array(); |
||
19 | $mas_url_url = array(); |
||
20 | $mas_url_description = array(); |
||
21 | $num_record = mysql_num_rows($query); |
||
22 | for ($i = 0; $i < $num_record; $i++) |
||
23 | { |
||
24 | $mas_url_id[] = mysql_result($query, $i, 0); |
||
25 | $mas_url_url[] = mysql_result($query, $i, 1); |
||
26 | $mas_url_description[] = mysql_result($query, $i, 2); |
||
27 | } |
||
28 | |||
29 | |||
30 | print " |
||
31 | <form action = \"edit_program_sql.php\"> |
||
32 | <table> |
||
33 | <tr><td valign = \"top\"> |
||
34 | <table align = \"center\"> |
||
35 | <tr><td colspan = \"2\" align = \"center\"><b>Общие данные о программе:</b></td></tr> |
||
36 | <tr><td><input type = \"hidden\" name = \"program_id\" value = \"$program_id\"/></td><td></td></tr> |
||
37 | <tr><td>Производитель</td><td><input type = \"text\" class = \"text\" size = \"40\" name = \"program_manufacturer\" value = \"$program_manufacturer\"/></td></tr> |
||
38 | <tr><td>Название программы</td><td><input type = \"text\" class = \"text\" size = \"40\" name = \"program_name\" value = \"$program_name\"/></td></tr> |
||
39 | <tr><td>Описание программы</td><td><textarea cols = \"40\" name = \"program_description\" rows = \"6\">$program_description</textarea></td></tr> |
||
40 | </table> |
||
41 | </td> |
||
42 | <td valign = \"top\"> |
||
43 | <table>"; |
||
44 | print "<tr><td align = \"center\"><b>URL связанные с программой:</b></td></tr>"; |
||
45 | for ($i = 0; $i < count($mas_url_url); $i++) |
||
46 | { |
||
47 | print " |
||
48 | <tr><td><a href = \"$base_url_software$mas_url_url[$i]\">$mas_url_description[$i]</td> |
||
49 | <td><a href = \"edit_program_url.php?program_id=$program_id&url_id=$mas_url_id[$i]\"><img width=\"16\" height=\"16\" src=\"image/edit.png\" alt=\"\"/></a></td> |
||
50 | <td><a href = \"del_program_url_sql.php?url_id=$mas_url_id[$i]\"><img src=\"image/del.png\" alt=\"\"/></a></td></tr>"; |
||
51 | } |
||
52 | print " |
||
53 | <tr><td align = \"center\" colspan = \"3\"><hr/></td></tr> |
||
54 | <tr><td align = \"center\" colspan = \"3\"><a href = \"insert_program_url.php?program_id=$program_id\">Добавить новый URL</a></td></tr></table> |
||
55 | </td></tr> |
||
56 | </table>"; |
||
57 | |||
58 | |||
59 | $sql = "SELECT sid FROM prog_in_sect WHERE pid = ". $program_id; |
||
60 | $query=mysql_query($sql, $db); |
||
61 | $mas_sect_id = array(); |
||
62 | $num_record = mysql_num_rows($query); |
||
63 | for($i = 0; $i < $num_record; $i++) |
||
64 | $mas_prog_in_sect_id[$i] = mysql_result($query,$i,0); |
||
65 | $sql = "SELECT id, name FROM section ORDER BY name"; |
||
66 | $query = mysql_query($sql, $db); |
||
67 | $mas_section_id = array(); |
||
68 | $mas_section_name = array(); |
||
69 | $num_record = mysql_num_rows($query); |
||
70 | $mas_prog_in_sect = array(); |
||
71 | for ($i = 0; $i < $num_record; $i++) |
||
72 | { |
||
73 | $mas_section_id[$i] = mysql_result($query, $i, 0); |
||
74 | $mas_section_name[$i] = mysql_result($query, $i, 1); |
||
75 | $mas_prog_in_sect[$i] = ""; |
||
76 | } |
||
77 | mysql_close($db); |
||
78 | for ($i = 0; $i < count($mas_prog_in_sect_id); $i++) |
||
79 | for ($j = 0; $j < count($mas_section_id); $j++) |
||
80 | if ($mas_prog_in_sect_id[$i] == $mas_section_id[$j]) |
||
81 | $mas_prog_in_sect[$j] = "checked"; |
||
82 | print " |
||
83 | <table> |
||
84 | <tr><td width = \"50%\"><b>В эти группы программа еще не входит:</b></td><td width = \"50%\"><b>В эти группы программа уже входит</b>:</td></tr> |
||
85 | <tr><td>"; |
||
86 | for ($i = 0; $i < count($mas_section_id); $i++) |
||
87 | if ($mas_prog_in_sect[$i] <> "checked") |
||
88 | print "<input type = \"checkbox\" name = \"section_insert_id[]\" value = \"$mas_section_id[$i]\">$mas_section_name[$i]</input><br/>"; |
||
89 | print "</td><td>"; |
||
90 | for ($i = 0; $i < count($mas_section_id); $i++) |
||
91 | if ($mas_prog_in_sect[$i] == "checked") |
||
92 | print "<input type = \"checkbox\" name = \"section_delete_id[]\" value = \"$mas_section_id[$i]\" >$mas_section_name[$i]</input><br/>"; |
||
93 | print " |
||
94 | </td></tr></table> |
||
95 | <table> |
||
96 | <tr><td><br/><input type = \"submit\" class = \"submit\" name = \"delete_program\" value = \"delete\"/></td> |
||
97 | <td><br/><input type = \"submit\" class = \"submit\" name = \"save_program\" value = \"save\"/></td></tr> |
||
98 | </table> |
||
99 | </form>"; |
||
100 | include "foot.php"; |
||
101 | ?> |