Содержимое файла | Последнее изменение | Открыть журнал | 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 | $mas_section_delete_id = array(); |
||
| 15 | if (count($_GET['section_delete_id']) > 0) |
||
| 16 | { |
||
| 17 | foreach ($_GET['section_delete_id'] as $val) |
||
| 18 | { |
||
| 19 | $mas_section_delete_id[] = $val; |
||
| 20 | } |
||
| 21 | } |
||
| 22 | $program_id = $_GET['program_id']; |
||
| 23 | $program_manufacturer = $_GET['program_manufacturer']; |
||
| 24 | $program_name = $_GET['program_name']; |
||
| 25 | $program_description = $_GET['program_description']; |
||
| 26 | if ($_GET['save_program'] == "save") |
||
| 27 | { |
||
| 28 | $db = mysql_connect("localhost", "linwin"); |
||
| 29 | mysql_select_db("linwin", $db); |
||
| 30 | mysql_query("SET NAMES 'utf8';", $db); |
||
| 31 | $sql = "UPDATE program SET manufacturer = '". $program_manufacturer. "', name = '". $program_name. "', description = '". $program_description. "' WHERE id = ". $program_id; |
||
| 32 | if (mysql_query($sql, $db)) |
||
| 33 | { |
||
| 34 | echo "<br/>Данные о программе успешно обновлены<br/>"; |
||
| 35 | } |
||
| 36 | else |
||
| 37 | { |
||
| 38 | echo "Данные о программе не обновлены<br/>"; |
||
| 39 | } |
||
| 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 (count($mas_section_delete_id) <> 0) |
||
| 56 | { |
||
| 57 | for ($i = 0; $i < count($mas_section_delete_id); $i++) |
||
| 58 | { |
||
| 59 | $sql = "DELETE FROM prog_in_sect WHERE pid = ". $program_id. " and sid =". $mas_section_delete_id[$i]; |
||
| 60 | if (mysql_query($sql, $db)) |
||
| 61 | { |
||
| 62 | echo "<br/>Данные из таблицы prog_in_sect успешно удалены<br/>"; |
||
| 63 | } |
||
| 64 | else |
||
| 65 | { |
||
| 66 | echo "Данные из таблицы prig_in_sect не удалены<br/>"; |
||
| 67 | } |
||
| 68 | } |
||
| 69 | } |
||
| 70 | mysql_close($db); |
||
| 71 | } |
||
| 72 | if ($_GET['delete_program'] == "delete") |
||
| 73 | { |
||
| 74 | $db = mysql_connect("localhost", "linwin"); |
||
| 75 | mysql_select_db("linwin", $db); |
||
| 76 | mysql_query("SET NAMES 'utf8';", $db); |
||
| 77 | $sql = "SELECT id FROM prog_in_sect WHERE pid = '". $program_id. "'"; |
||
| 78 | $query=mysql_query($sql, $db); |
||
| 79 | if (mysql_num_rows($query)) |
||
| 80 | echo "<br/>Ошибка!!! Программа содержится в группе!!!<br/>"; |
||
| 81 | else |
||
| 82 | { |
||
| 83 | $sql = "DELETE FROM program WHERE id = ". $program_id; |
||
| 84 | if (mysql_query($sql, $db)) |
||
| 85 | { |
||
| 86 | echo "<br/>Программа успешно удалена<br/>"; |
||
| 87 | } |
||
| 88 | else |
||
| 89 | { |
||
| 90 | echo "Программа не удалена<br/>"; |
||
| 91 | } |
||
| 92 | } |
||
| 93 | mysql_close($db); |
||
| 94 | } |
||
| 95 | include "foot.php"; |
||
| 96 | ?> |