Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | session_start(); |
||
3 | if ($_SESSION['$user_privileges'] < 16) |
||
4 | header("Location: index.php"); |
||
5 | include "head.php"; |
||
6 | $mas_section_insert_id = array(); |
||
7 | if (count($_GET['section_insert_id']) > 0) |
||
8 | { |
||
9 | foreach ($_GET['section_insert_id'] as $val) |
||
10 | { |
||
11 | $mas_section_insert_id[] = $val; |
||
12 | } |
||
13 | } |
||
14 | $program_manufacturer = $_GET['program_manufacturer']; |
||
15 | $program_site = $_GET['program_site']; |
||
16 | $program_mirror = $_GET['program_mirror']; |
||
17 | $program_name = $_GET['program_name']; |
||
18 | $program_description = $_GET['program_description']; |
||
19 | $db = mysql_connect("localhost", "linwin"); |
||
20 | mysql_select_db("linwin", $db); |
||
21 | mysql_query("SET NAMES 'utf8';", $db); |
||
22 | $sql = "SELECT id, name FROM program WHERE name = '". $program_name. "'"; |
||
23 | $query=mysql_query($sql, $db); |
||
24 | if (mysql_num_rows($query)) |
||
25 | echo "<br/>Ошибка!!! Программа с таким именем уже существует!!!<br/>"; |
||
26 | else |
||
27 | { |
||
28 | $sql = "INSERT INTO program(manufacturer, name, description) values ('". $program_manufacturer. "','". $program_name. "','". $program_description. "')"; |
||
29 | if (mysql_query($sql, $db)) |
||
30 | { |
||
31 | echo "<br/>Данные о программе успешно добавлены<br/>"; |
||
32 | } |
||
33 | else |
||
34 | { |
||
35 | echo "Данные о программе не добавлены<br/>"; |
||
36 | } |
||
37 | $sql = "SELECT id FROM program WHERE manufacturer = '". $program_manufacturer. "' and name = '". $program_name. "';"; |
||
38 | $query=mysql_query($sql, $db); |
||
39 | $program_id = mysql_result($query, 0, 0); |
||
40 | if (count($mas_section_insert_id) <> 0) |
||
41 | { |
||
42 | for ($i = 0; $i < count($mas_section_insert_id); $i++) |
||
43 | { |
||
44 | $sql = "INSERT INTO prog_in_sect(pid, sid) values ('". $program_id. "','". $mas_section_insert_id[$i]. "');"; |
||
45 | if (mysql_query($sql, $db)) |
||
46 | { |
||
47 | echo "<br/>Данные в таблицу prog_in_sect успешно внесены<br/>"; |
||
48 | } |
||
49 | else |
||
50 | { |
||
51 | echo "Данные в таблицу prog_in_sect не внесены<br/>"; |
||
52 | } |
||
53 | } |
||
54 | } |
||
55 | if ($program_site <> "") |
||
56 | { |
||
57 | $sql = "INSERT INTO url(pid, url, description) values ('". $program_id. "','". $program_site. "','". "Сайт программы". "');"; |
||
58 | if (mysql_query($sql, $db)) |
||
59 | { |
||
60 | echo "<br/>Данные в таблицу URL успешно внесены<br/>"; |
||
61 | } |
||
62 | else |
||
63 | { |
||
64 | echo "Данные в таблицу URL не внесены<br/>"; |
||
65 | } |
||
66 | } |
||
67 | if ($program_mirror <> "") |
||
68 | { |
||
69 | $sql = "INSERT INTO url(pid, url, description, local_mirror) values ('". $program_id. "','". $program_mirror. "','". "Локальное зеркало". "', 1);"; |
||
70 | if (mysql_query($sql, $db)) |
||
71 | { |
||
72 | echo "<br/>Данные в таблицу URL успешно внесены<br/>"; |
||
73 | } |
||
74 | else |
||
75 | { |
||
76 | echo "Данные в таблицу URL не внесены<br/>"; |
||
77 | } |
||
78 | } |
||
79 | mysql_close($db); |
||
80 | } |
||
81 | include "foot.php"; |
||
82 | ?> |