{"id":135579,"date":"2026-08-11T21:49:09","date_gmt":"2026-08-11T15:49:09","guid":{"rendered":"https:\/\/rcl-radio.ru\/?p=135579"},"modified":"2026-08-11T21:49:09","modified_gmt":"2026-08-11T15:49:09","slug":"%d1%81%d0%be%d0%b7%d0%b4%d0%b0%d0%bd%d0%b8%d0%b5-%d1%80%d0%b5%d0%b4%d0%b0%d0%ba%d1%82%d0%b8%d1%80%d0%be%d0%b2%d0%b0%d0%bd%d0%b8%d0%b5-%d0%b8-%d1%83%d0%b4%d0%b0%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-%d1%81","status":"publish","type":"post","link":"https:\/\/rcl-radio.ru\/?p=135579","title":{"rendered":"\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435, \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0430\u0442\u0435\u0439"},"content":{"rendered":"<p>\u0420\u0430\u043d\u0435\u0435 \u0432 <a href=\"https:\/\/rcl-radio.ru\/?p=135550\">\u041f\u0435\u0440\u0432\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445: \u0444\u043e\u0440\u043c\u0430 \u043d\u0430 HTML + \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u043d\u0430 PHP<\/a> \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u043f\u0440\u0438\u043c\u0435\u0440 \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e, \u043d\u0438\u0436\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043d \u043a\u043e\u0434 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0439 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c, \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u0438.<\/p>\n<p>\u0424\u0430\u0439\u043b add_form.php<\/p>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #66cc66;\">&lt;<\/span>?php\r\nrequire <span style=\"color: #ff0000;\">'db_connect.php'<\/span>;\r\n\u00a0\r\n$article = <span style=\"color: #000000; font-weight: bold;\">null<\/span>;\r\n$isEdit = <span style=\"color: #000000; font-weight: bold;\">false<\/span>;\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u0415\u0441\u043b\u0438 \u0432 URL \u0435\u0441\u0442\u044c ?id=\u2026, \u0437\u0430\u0433\u0440\u0443\u0436\u0430\u0435\u043c \u0441\u0442\u0430\u0442\u044c\u044e \u0434\u043b\u044f \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $id = <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #0066cc;\">int<\/span><span style=\"color: #66cc66;\">)<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span>;\r\n    $stmt = mysqli_prepare<span style=\"color: #66cc66;\">(<\/span>$connection, <span style=\"color: #ff0000;\">'SELECT * FROM posts WHERE id = ?'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_bind_param<span style=\"color: #66cc66;\">(<\/span>$stmt, <span style=\"color: #ff0000;\">'i'<\/span>, $id<span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_execute<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n    $result = mysqli_stmt_get_result<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n    $article = mysqli_fetch_assoc<span style=\"color: #66cc66;\">(<\/span>$result<span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_close<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>$article<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">404<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        echo <span style=\"color: #ff0000;\">'\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n        exit;\r\n    <span style=\"color: #66cc66;\">}<\/span>\r\n    $isEdit = <span style=\"color: #000000; font-weight: bold;\">true<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;!<\/span>DOCTYPE html<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;<\/span><span style=\"color: #0066cc;\">html<\/span> lang=<span style=\"color: #ff0000;\">\"ru\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;<\/span>head<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>meta charset=<span style=\"color: #ff0000;\">\"utf-8\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>title<span style=\"color: #66cc66;\">&gt;&lt;<\/span>?php echo $isEdit ? <span style=\"color: #ff0000;\">'\u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span> : <span style=\"color: #ff0000;\">'\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span>; ?<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>title<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>link rel=<span style=\"color: #ff0000;\">\"stylesheet\"<\/span> href=<span style=\"color: #ff0000;\">\"site.css\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;\/<\/span>head<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;<\/span>body<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n\u00a0\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>main <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"container\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>nav<span style=\"color: #66cc66;\">&gt;&lt;<\/span>h3<span style=\"color: #66cc66;\">&gt;&lt;<\/span>a href=<span style=\"color: #ff0000;\">\".\/\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u0413\u043b\u0430\u0432\u043d\u0430\u044f<span style=\"color: #66cc66;\">&lt;\/<\/span>a<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>h3<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>nav<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>hr<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>h2<span style=\"color: #66cc66;\">&gt;&lt;<\/span>?php echo $isEdit ? <span style=\"color: #ff0000;\">'\u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span> : <span style=\"color: #ff0000;\">'\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span>; ?<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>h2<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n        <span style=\"color: #66cc66;\">&lt;!<\/span>-- action \u0432\u0435\u0434\u0451\u0442 \u043d\u0430 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a --<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>form method=<span style=\"color: #ff0000;\">\"POST\"<\/span> action=<span style=\"color: #ff0000;\">\"add_post.php\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$isEdit<span style=\"color: #66cc66;\">)<\/span>: ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n                <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"hidden\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"id\"<\/span> value=<span style=\"color: #ff0000;\">\"&lt;?php echo (int)$article['id']; ?&gt;\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">endif<\/span>; ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"title\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a <span style=\"color: #66cc66;\">(<\/span>title<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"text\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"title\"<\/span> id=<span style=\"color: #ff0000;\">\"title\"<\/span> required\r\n                value=<span style=\"color: #ff0000;\">\"&lt;?php echo htmlspecialchars($article['title'] ?? ''); ?&gt;\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"slug\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>Slug <span style=\"color: #66cc66;\">(<\/span>\u0434\u043b\u044f <span style=\"color: #0066cc;\">URL<\/span>, \u043b\u0430\u0442\u0438\u043d\u0438\u0446\u0430 \u0438 \u0434\u0435\u0444\u0438\u0441\u044b<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>small<span style=\"color: #66cc66;\">&gt;&lt;<\/span>span <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"hint\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u0417\u0430\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0438\u0437 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0430 <span style=\"color: #66cc66;\">(<\/span>\u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0430\u0446\u0438\u044f<span style=\"color: #66cc66;\">)<\/span>. \u041c\u043e\u0436\u043d\u043e \u043e\u0442\u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0432\u0440\u0443\u0447\u043d\u0443\u044e.<span style=\"color: #66cc66;\">&lt;\/<\/span>span<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>small<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"text\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"slug\"<\/span> id=<span style=\"color: #ff0000;\">\"slug\"<\/span> required\r\n                value=<span style=\"color: #ff0000;\">\"&lt;?php echo htmlspecialchars($article['slug'] ?? ''); ?&gt;\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"excerpt\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u041a\u0440\u0430\u0442\u043a\u043e\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 <span style=\"color: #66cc66;\">(<\/span>excerpt, \u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"text\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"excerpt\"<\/span> id=<span style=\"color: #ff0000;\">\"excerpt\"<\/span>\r\n                value=<span style=\"color: #ff0000;\">\"&lt;?php echo htmlspecialchars($article['meta_description'] ?? ''); ?&gt;\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"content\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u041a\u043e\u043d\u0442\u0435\u043d\u0442 <span style=\"color: #66cc66;\">(<\/span>content, \u043c\u043e\u0436\u043d\u043e <span style=\"color: #0066cc;\">HTML<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>textarea <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"content\"<\/span> rows=<span style=\"color: #ff0000;\">\"10\"<\/span> cols=<span style=\"color: #ff0000;\">\"50\"<\/span> required<span style=\"color: #66cc66;\">&gt;&lt;<\/span>?php echo <span style=\"color: #66cc66;\">(<\/span>$article<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'content'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>; ?<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>textarea<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"checkbox\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"is_published\"<\/span> id=<span style=\"color: #ff0000;\">\"is_published\"<\/span> value=<span style=\"color: #ff0000;\">\"1\"<\/span> checked<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"is_published\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u0442\u044c \u0441\u0440\u0430\u0437\u0443 <span style=\"color: #66cc66;\">(<\/span>is_published<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>label <span style=\"color: #b1b100;\">for<\/span>=<span style=\"color: #ff0000;\">\"sort_order\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\u041f\u043e\u0440\u044f\u0434\u043e\u043a \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0438<span style=\"color: #66cc66;\">&lt;\/<\/span>label<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>input <span style=\"color: #0066cc;\">type<\/span>=<span style=\"color: #ff0000;\">\"number\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"sort_order\"<\/span> id=<span style=\"color: #ff0000;\">\"sort_order\"<\/span>\r\n                value=<span style=\"color: #ff0000;\">\"&lt;?php echo (int)($article['sort_order'] ?? 0); ?&gt;\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;&lt;<\/span>br<span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span><span style=\"color: #0066cc;\">button<\/span> <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"btn-main\"<\/span><span style=\"color: #66cc66;\">&gt;&lt;<\/span>?php echo $isEdit ? <span style=\"color: #ff0000;\">'\u041e\u0431\u043d\u043e\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span> : <span style=\"color: #ff0000;\">'\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e'<\/span>; ?<span style=\"color: #66cc66;\">&gt;&lt;\/<\/span>button<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n<span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$isEdit<span style=\"color: #66cc66;\">)<\/span>: ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span><span style=\"color: #0066cc;\">button<\/span> <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"btn-main\"<\/span> <span style=\"color: #0066cc;\">name<\/span>=<span style=\"color: #ff0000;\">\"action\"<\/span> value=<span style=\"color: #ff0000;\">\"delete\"<\/span> <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"btn-danger\"<\/span> onclick=<span style=\"color: #ff0000;\">\"return confirm('\u0412\u044b \u0443\u0432\u0435\u0440\u0435\u043d\u044b, \u0447\u0442\u043e \u0445\u043e\u0442\u0438\u0442\u0435 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u044d\u0442\u0443 \u0441\u0442\u0430\u0442\u044c\u044e?');\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n        \u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e\r\n    <span style=\"color: #66cc66;\">&lt;\/<\/span>button<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">endif<\/span>; ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n\u00a0\r\n                <span style=\"color: #66cc66;\">&lt;!<\/span>-- \u0411\u043b\u043e\u043a \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u0439 --<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'msg'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>: ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>div <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"notification\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n            <span style=\"color: #66cc66;\">&lt;<\/span>?php\r\n            $msg = $_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'msg'<\/span><span style=\"color: #66cc66;\">]<\/span>;\r\n            <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$msg === <span style=\"color: #ff0000;\">'new'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n                echo <span style=\"color: #ff0000;\">'&lt;strong&gt;\u041d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0442\u044c\u044f \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430!&lt;\/strong&gt;'<\/span>;\r\n            <span style=\"color: #66cc66;\">}<\/span> <span style=\"color: #b1b100;\">elseif<\/span> <span style=\"color: #66cc66;\">(<\/span>$msg === <span style=\"color: #ff0000;\">'updated'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n                echo <span style=\"color: #ff0000;\">'&lt;strong&gt;\u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u0435\u043d\u043e!&lt;\/strong&gt;'<\/span>;\r\n            <span style=\"color: #66cc66;\">}<\/span>\r\n            ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;\/<\/span>div<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">endif<\/span>; ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;\/<\/span>form<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;\/<\/span>main<span style=\"color: #66cc66;\">&gt;<\/span>\r\n\u00a0\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>script<span style=\"color: #66cc66;\">&gt;<\/span>\r\n        const titleInput = document.<span style=\"color: #006600;\">getElementById<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'title'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        const slugInput = document.<span style=\"color: #006600;\">getElementById<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'slug'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        let isManualEdit = <span style=\"color: #000000; font-weight: bold;\">false<\/span>;\r\n\u00a0\r\n        slugInput.<span style=\"color: #006600;\">addEventListener<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'input'<\/span>, <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span> =<span style=\"color: #66cc66;\">&gt;<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n            isManualEdit = <span style=\"color: #000000; font-weight: bold;\">true<\/span>;\r\n        <span style=\"color: #66cc66;\">}<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n        const translitMap = <span style=\"color: #66cc66;\">{<\/span>\r\n            <span style=\"color: #ff0000;\">'\u0430'<\/span>: <span style=\"color: #ff0000;\">'a'<\/span>, <span style=\"color: #ff0000;\">'\u0431'<\/span>: <span style=\"color: #ff0000;\">'b'<\/span>, <span style=\"color: #ff0000;\">'\u0432'<\/span>: <span style=\"color: #ff0000;\">'v'<\/span>, <span style=\"color: #ff0000;\">'\u0433'<\/span>: <span style=\"color: #ff0000;\">'g'<\/span>, <span style=\"color: #ff0000;\">'\u0434'<\/span>: <span style=\"color: #ff0000;\">'d'<\/span>, <span style=\"color: #ff0000;\">'\u0435'<\/span>: <span style=\"color: #ff0000;\">'e'<\/span>, <span style=\"color: #ff0000;\">'\u0451'<\/span>: <span style=\"color: #ff0000;\">'yo'<\/span>,\r\n            <span style=\"color: #ff0000;\">'\u0436'<\/span>: <span style=\"color: #ff0000;\">'zh'<\/span>, <span style=\"color: #ff0000;\">'\u0437'<\/span>: <span style=\"color: #ff0000;\">'z'<\/span>, <span style=\"color: #ff0000;\">'\u0438'<\/span>: <span style=\"color: #ff0000;\">'i'<\/span>, <span style=\"color: #ff0000;\">'\u0439'<\/span>: <span style=\"color: #ff0000;\">'y'<\/span>, <span style=\"color: #ff0000;\">'\u043a'<\/span>: <span style=\"color: #ff0000;\">'k'<\/span>, <span style=\"color: #ff0000;\">'\u043b'<\/span>: <span style=\"color: #ff0000;\">'l'<\/span>, <span style=\"color: #ff0000;\">'\u043c'<\/span>: <span style=\"color: #ff0000;\">'m'<\/span>,\r\n            <span style=\"color: #ff0000;\">'\u043d'<\/span>: <span style=\"color: #ff0000;\">'n'<\/span>, <span style=\"color: #ff0000;\">'\u043e'<\/span>: <span style=\"color: #ff0000;\">'o'<\/span>, <span style=\"color: #ff0000;\">'\u043f'<\/span>: <span style=\"color: #ff0000;\">'p'<\/span>, <span style=\"color: #ff0000;\">'\u0440'<\/span>: <span style=\"color: #ff0000;\">'r'<\/span>, <span style=\"color: #ff0000;\">'\u0441'<\/span>: <span style=\"color: #ff0000;\">'s'<\/span>, <span style=\"color: #ff0000;\">'\u0442'<\/span>: <span style=\"color: #ff0000;\">'t'<\/span>, <span style=\"color: #ff0000;\">'\u0443'<\/span>: <span style=\"color: #ff0000;\">'u'<\/span>,\r\n            <span style=\"color: #ff0000;\">'\u0444'<\/span>: <span style=\"color: #ff0000;\">'f'<\/span>, <span style=\"color: #ff0000;\">'\u0445'<\/span>: <span style=\"color: #ff0000;\">'h'<\/span>, <span style=\"color: #ff0000;\">'\u0446'<\/span>: <span style=\"color: #ff0000;\">'ts'<\/span>, <span style=\"color: #ff0000;\">'\u0447'<\/span>: <span style=\"color: #ff0000;\">'ch'<\/span>, <span style=\"color: #ff0000;\">'\u0448'<\/span>: <span style=\"color: #ff0000;\">'sh'<\/span>, <span style=\"color: #ff0000;\">'\u0449'<\/span>: <span style=\"color: #ff0000;\">'sch'<\/span>,\r\n            <span style=\"color: #ff0000;\">'\u044a'<\/span>: <span style=\"color: #ff0000;\">''<\/span>, <span style=\"color: #ff0000;\">'\u044b'<\/span>: <span style=\"color: #ff0000;\">'y'<\/span>, <span style=\"color: #ff0000;\">'\u044c'<\/span>: <span style=\"color: #ff0000;\">''<\/span>, <span style=\"color: #ff0000;\">'\u044d'<\/span>: <span style=\"color: #ff0000;\">'e'<\/span>, <span style=\"color: #ff0000;\">'\u044e'<\/span>: <span style=\"color: #ff0000;\">'yu'<\/span>, <span style=\"color: #ff0000;\">'\u044f'<\/span>: <span style=\"color: #ff0000;\">'ya'<\/span>\r\n        <span style=\"color: #66cc66;\">}<\/span>;\r\n\u00a0\r\n        <span style=\"color: #000000; font-weight: bold;\">function<\/span> transliterate<span style=\"color: #66cc66;\">(<\/span>str<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n            <span style=\"color: #b1b100;\">return<\/span> str\r\n                .<span style=\"color: #0066cc;\">toLowerCase<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span>\r\n                .<span style=\"color: #0066cc;\">split<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>\r\n                .<span style=\"color: #006600;\">map<\/span><span style=\"color: #66cc66;\">(<\/span>char =<span style=\"color: #66cc66;\">&gt;<\/span> translitMap<span style=\"color: #66cc66;\">[<\/span>char<span style=\"color: #66cc66;\">]<\/span> <span style=\"color: #66cc66;\">||<\/span> char<span style=\"color: #66cc66;\">)<\/span>\r\n                .<span style=\"color: #0066cc;\">join<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        <span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n        titleInput.<span style=\"color: #006600;\">addEventListener<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'input'<\/span>, <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span> =<span style=\"color: #66cc66;\">&gt;<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n            <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isManualEdit<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #b1b100;\">return<\/span>;\r\n\u00a0\r\n            const value = titleInput.<span style=\"color: #006600;\">value<\/span>.<span style=\"color: #006600;\">trim<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n            <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>value<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n                slugInput.<span style=\"color: #006600;\">value<\/span> = <span style=\"color: #ff0000;\">''<\/span>;\r\n                <span style=\"color: #b1b100;\">return<\/span>;\r\n            <span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n            let slug = transliterate<span style=\"color: #66cc66;\">(<\/span>value<span style=\"color: #66cc66;\">)<\/span>;\r\n            slug = slug\r\n                .<span style=\"color: #006600;\">replace<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">\/<\/span><span style=\"color: #66cc66;\">[<\/span>^a-z0-<span style=\"color: #cc66cc;\">9<\/span><span style=\"color: #66cc66;\">]<\/span>+<span style=\"color: #66cc66;\">\/<\/span>g, <span style=\"color: #ff0000;\">'-'<\/span><span style=\"color: #66cc66;\">)<\/span>\r\n                .<span style=\"color: #006600;\">replace<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">\/<\/span>^-+<span style=\"color: #66cc66;\">|<\/span>-+$<span style=\"color: #66cc66;\">\/<\/span>g, <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>\r\n                .<span style=\"color: #006600;\">replace<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">\/<\/span>-+<span style=\"color: #66cc66;\">\/<\/span>g, <span style=\"color: #ff0000;\">'-'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n            slugInput.<span style=\"color: #006600;\">value<\/span> = slug;\r\n        <span style=\"color: #66cc66;\">}<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    <span style=\"color: #66cc66;\">&lt;\/<\/span>script<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;\/<\/span>body<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;\/<\/span>html<span style=\"color: #66cc66;\">&gt;<\/span><\/pre>\n<p>\u0424\u0430\u0439\u043b add_post.php<\/p>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #66cc66;\">&lt;<\/span>?php\r\nrequire <span style=\"color: #ff0000;\">'db_connect.php'<\/span>;\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>$connection <span style=\"color: #66cc66;\">||<\/span> mysqli_connect_errno<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">500<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0411\u0414: '<\/span> . <span style=\"color: #006600;\">htmlspecialchars<\/span><span style=\"color: #66cc66;\">(<\/span>mysqli_connect_error<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    exit;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u041e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u043c \u0440\u0435\u0436\u0438\u043c: \u0435\u0441\u043b\u0438 \u043f\u0440\u0438\u0441\u043b\u0430\u043b\u0438 id \u2014 \u044d\u0442\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435, \u0438\u043d\u0430\u0447\u0435 \u0432\u0441\u0442\u0430\u0432\u043a\u0430<\/span>\r\n$mode = <span style=\"color: #ff0000;\">'insert'<\/span>;\r\n$id = isset<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span> ? <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #0066cc;\">int<\/span><span style=\"color: #66cc66;\">)<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span> : <span style=\"color: #cc66cc;\">0<\/span>;\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'action'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">&amp;&amp;<\/span> $_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'action'<\/span><span style=\"color: #66cc66;\">]<\/span> === <span style=\"color: #ff0000;\">'delete'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$id === <span style=\"color: #cc66cc;\">0<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">400<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430: \u043d\u0435\u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e \u0431\u0435\u0437 ID.'<\/span>;\r\n        exit;\r\n    <span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n    $sql = <span style=\"color: #ff0000;\">'DELETE FROM posts WHERE id = ?'<\/span>;\r\n    $stmt = mysqli_prepare<span style=\"color: #66cc66;\">(<\/span>$connection, $sql<span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_bind_param<span style=\"color: #66cc66;\">(<\/span>$stmt, <span style=\"color: #ff0000;\">'i'<\/span>, $id<span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>mysqli_stmt_execute<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        mysqli_stmt_close<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n        header<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'Location: index.php'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        exit;\r\n    <span style=\"color: #66cc66;\">}<\/span> <span style=\"color: #b1b100;\">else<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">500<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u0440\u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0438: '<\/span> . <span style=\"color: #006600;\">htmlspecialchars<\/span><span style=\"color: #66cc66;\">(<\/span>mysqli_stmt_error<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        mysqli_stmt_close<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n        exit;\r\n    <span style=\"color: #66cc66;\">}<\/span>\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$id <span style=\"color: #66cc66;\">&gt;<\/span> <span style=\"color: #cc66cc;\">0<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $mode = <span style=\"color: #ff0000;\">'update'<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n$title          = trim<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'title'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n$slug           = trim<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'slug'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n$content        = $_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'content'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #ff0000;\">''<\/span>;\r\n$meta_desc      = $_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'excerpt'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #000000; font-weight: bold;\">null<\/span>; <span style=\"color: #808080; font-style: italic;\">\/\/ \u0432 \u0444\u043e\u0440\u043c\u0435 \u043f\u043e\u043b\u0435 \u043d\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f excerpt<\/span>\r\n$meta_keys      = <span style=\"color: #000000; font-weight: bold;\">null<\/span>;                      <span style=\"color: #808080; font-style: italic;\">\/\/ \u0435\u0441\u043b\u0438 \u0434\u043e\u0431\u0430\u0432\u0438\u0448\u044c \u043f\u043e\u043b\u0435 \u2014 \u0440\u0430\u0441\u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0438\u0440\u0443\u0439<\/span>\r\n$is_published   = isset<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'is_published'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span> ? <span style=\"color: #cc66cc;\">1<\/span> : <span style=\"color: #cc66cc;\">0<\/span>;\r\n$sort_order     = <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #0066cc;\">int<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'sort_order'<\/span><span style=\"color: #66cc66;\">]<\/span> ?? <span style=\"color: #cc66cc;\">0<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u0412\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u044f: title, slug, content \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$title === <span style=\"color: #ff0000;\">''<\/span> <span style=\"color: #66cc66;\">||<\/span> $slug === <span style=\"color: #ff0000;\">''<\/span> <span style=\"color: #66cc66;\">||<\/span> $content === <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">400<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430: \u043f\u043e\u043b\u044f title, slug \u0438 content \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b.'<\/span>;\r\n    exit;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f slug \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435. \u041f\u0440\u0438 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438 \u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u043a\u0430\u043a \u0432\u0432\u0451\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$mode === <span style=\"color: #ff0000;\">'insert'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $slug = preg_replace<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'\/[^a-z0-9<span style=\"color: #000099; font-weight: bold;\">\\-<\/span>]\/i'<\/span>, <span style=\"color: #ff0000;\">'-'<\/span>, $slug<span style=\"color: #66cc66;\">)<\/span>;\r\n    $slug = preg_replace<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'\/-+\/'<\/span>, <span style=\"color: #ff0000;\">'-'<\/span>, $slug<span style=\"color: #66cc66;\">)<\/span>;\r\n    $slug = trim<span style=\"color: #66cc66;\">(<\/span>$slug, <span style=\"color: #ff0000;\">'-'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$slug === <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        $slug = <span style=\"color: #ff0000;\">'page-'<\/span> . <span style=\"color: #0066cc;\">time<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    <span style=\"color: #66cc66;\">}<\/span>\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$mode === <span style=\"color: #ff0000;\">'insert'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ INSERT<\/span>\r\n    $sql = <span style=\"color: #ff0000;\">'INSERT INTO posts (slug, title, content, meta_description, meta_keywords, is_published, sort_order)\r\n            VALUES (?, ?, ?, ?, ?, ?, ?)'<\/span>;\r\n    $stmt = mysqli_prepare<span style=\"color: #66cc66;\">(<\/span>$connection, $sql<span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_bind_param<span style=\"color: #66cc66;\">(<\/span>$stmt, <span style=\"color: #ff0000;\">'ssssssi'<\/span>, $slug, $title, $content, $meta_desc, $meta_keys, $is_published, $sort_order<span style=\"color: #66cc66;\">)<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span> <span style=\"color: #b1b100;\">else<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ UPDATE: \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u043f\u0435\u0440\u0435\u0434\u0430\u0451\u043c id \u0432 \u043a\u043e\u043d\u0446\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432<\/span>\r\n    $sql = <span style=\"color: #ff0000;\">'UPDATE posts\r\n            SET slug = ?, title = ?, content = ?, meta_description = ?, meta_keywords = ?, is_published = ?, sort_order = ?\r\n            WHERE id = ?'<\/span>;\r\n    $stmt = mysqli_prepare<span style=\"color: #66cc66;\">(<\/span>$connection, $sql<span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_bind_param<span style=\"color: #66cc66;\">(<\/span>$stmt, <span style=\"color: #ff0000;\">'ssssssii'<\/span>, $slug, $title, $content, $meta_desc, $meta_keys, $is_published, $sort_order, $id<span style=\"color: #66cc66;\">)<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">500<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430: '<\/span> . <span style=\"color: #006600;\">htmlspecialchars<\/span><span style=\"color: #66cc66;\">(<\/span>mysqli_error<span style=\"color: #66cc66;\">(<\/span>$connection<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    exit;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>mysqli_stmt_execute<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">500<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430 \u0411\u0414: '<\/span> . <span style=\"color: #006600;\">htmlspecialchars<\/span><span style=\"color: #66cc66;\">(<\/span>mysqli_stmt_error<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    mysqli_stmt_close<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n    exit;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\n\u00a0\r\nmysqli_stmt_close<span style=\"color: #66cc66;\">(<\/span>$stmt<span style=\"color: #66cc66;\">)<\/span>;\r\n\u00a0\r\n<span style=\"color: #808080; font-style: italic;\">\/\/ \u0424\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u0438 \u0442\u0438\u043f \u0434\u043b\u044f \u0440\u0435\u0434\u0438\u0440\u0435\u043a\u0442\u0430<\/span>\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$mode === <span style=\"color: #ff0000;\">'insert'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $new_id = mysqli_insert_id<span style=\"color: #66cc66;\">(<\/span>$connection<span style=\"color: #66cc66;\">)<\/span>;\r\n    header<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'Location: add_form.php?id='<\/span> . $new_id . <span style=\"color: #ff0000;\">'&amp;msg=new'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span> <span style=\"color: #b1b100;\">else<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    header<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'Location: add_form.php?id='<\/span> . $id . <span style=\"color: #ff0000;\">'&amp;msg=updated'<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span>\r\nexit;\r\n?<span style=\"color: #66cc66;\">&gt;<\/span><\/pre>\n<p>\u0414\u0432\u0430 \u0444\u0430\u0439\u043b\u0430:<\/p>\n<ol>\n<li data-value=\"1.\" data-shift=\"1\"><code class=\"CodeInlined\">add_form.php<\/code> \u2014 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u0435\u0442 \u0444\u043e\u0440\u043c\u0443, \u043f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0441\u0442\u0430\u0442\u044c\u0438 (\u0435\u0441\u043b\u0438 \u044d\u0442\u043e \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435) \u0438 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u044f \u043e\u0431 \u0443\u0441\u043f\u0435\u0445\u0435.<\/li>\n<li data-value=\"2.\" data-shift=\"1\"><code class=\"CodeInlined\">add_post.php<\/code> \u2014 \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0443 \u0444\u043e\u0440\u043c\u044b: \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435, \u0434\u0435\u043b\u0430\u0435\u0442 INSERT \u0438\u043b\u0438 UPDATE \u0432 \u0411\u0414, \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435.<\/li>\n<\/ol>\n<p>\u042d\u0442\u043e \u043a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0441\u0445\u0435\u043c\u0430 \u00abview + controller\u00bb \u0431\u0435\u0437 \u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u043e\u0432: \u043b\u043e\u0433\u0438\u043a\u0430 \u043f\u0440\u043e\u0441\u0442\u0430\u044f, \u043d\u043e \u043f\u043e\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u0432\u0441\u0435 \u0431\u0430\u0437\u043e\u0432\u044b\u0435 \u0441\u0446\u0435\u043d\u0430\u0440\u0438\u0438.<\/p>\n<hr \/>\n<h2>\u041a\u0430\u043a \u0444\u043e\u0440\u043c\u0430 \u043f\u043e\u043d\u0438\u043c\u0430\u0435\u0442, \u044d\u0442\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0438\u043b\u0438 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435<\/h2>\n<p>\u041a\u043b\u044e\u0447 \u2014 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <code class=\"CodeInlined\">?id=<\/code> \u0432 URL.<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">php<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $id = <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #0066cc;\">int<\/span><span style=\"color: #66cc66;\">)<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span>;\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ ... \u0437\u0430\u043f\u0440\u043e\u0441 \u043a \u0411\u0414 ...<\/span>\r\n    $article = mysqli_fetch_assoc<span style=\"color: #66cc66;\">(<\/span>$result<span style=\"color: #66cc66;\">)<\/span>;\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">!<\/span>$article<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n        http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">404<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n        echo <span style=\"color: #ff0000;\">'\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n        exit;\r\n    <span style=\"color: #66cc66;\">}<\/span>\r\n    $isEdit = <span style=\"color: #000000; font-weight: bold;\">true<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0415\u0441\u043b\u0438 <code class=\"CodeInlined\">id<\/code> \u0435\u0441\u0442\u044c \u2014 \u0437\u0430\u0433\u0440\u0443\u0436\u0430\u0435\u043c \u0441\u0442\u0430\u0442\u044c\u044e \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b <code class=\"CodeInlined\">posts<\/code> \u0438 \u0441\u0442\u0430\u0432\u0438\u043c \u0444\u043b\u0430\u0433 <code class=\"CodeInlined\">$isEdit = true<\/code>. \u0414\u0430\u043b\u044c\u0448\u0435 \u0444\u043e\u0440\u043c\u0430 \u0432\u0435\u0434\u0451\u0442 \u0441\u0435\u0431\u044f \u043f\u043e\u2011\u0440\u0430\u0437\u043d\u043e\u043c\u0443:<\/p>\n<ul>\n<li data-value=\"\" data-shift=\"0\">\u0412 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0435 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b \u0438 \u043a\u043d\u043e\u043f\u043a\u0435 \u043f\u0438\u0448\u0435\u043c \u00ab\u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e\u00bb \u0432\u043c\u0435\u0441\u0442\u043e \u00ab\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e\u00bb.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0441\u043a\u0440\u044b\u0442\u043e\u0435 \u043f\u043e\u043b\u0435 <code class=\"CodeInlined\">&lt;input type=\"hidden\" name=\"id\" ...&gt;<\/code>, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u0437\u043d\u0430\u043b, \u043a\u0430\u043a\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u041f\u043e\u043b\u044f \u0444\u043e\u0440\u043c\u044b \u0437\u0430\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0442\u0435\u043a\u0443\u0449\u0438\u043c\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u043c\u0438 \u0438\u0437 \u0431\u0430\u0437\u044b.<\/li>\n<\/ul>\n<p>\u0414\u043b\u044f \u0432\u044b\u0432\u043e\u0434\u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0432\u0441\u0435\u0433\u0434\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 <code class=\"CodeInlined\">htmlspecialchars()<\/code> \u2014 \u044d\u0442\u043e \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 XSS: \u0435\u0441\u043b\u0438 \u0432 \u0442\u0435\u043a\u0441\u0442\u0435 \u0435\u0441\u0442\u044c <code class=\"CodeInlined\">&lt;script&gt;<\/code>, \u043e\u043d \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0441\u044f, \u0430 \u043e\u0442\u043e\u0431\u0440\u0430\u0437\u0438\u0442\u0441\u044f \u043a\u0430\u043a \u0442\u0435\u043a\u0441\u0442.<\/p>\n<hr \/>\n<h2>\u0417\u0430\u0447\u0435\u043c \u043d\u0443\u0436\u0435\u043d \u0441\u043a\u0440\u044b\u0442\u044b\u0439 <code class=\"CodeInlined\">id<\/code> \u043f\u0440\u0438 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438<\/h2>\n<p>\u0411\u0435\u0437 \u043d\u0435\u0433\u043e \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a \u043d\u0435 \u043f\u043e\u0439\u043c\u0451\u0442, \u043a\u0430\u043a\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c. \u0412 SQL \u0434\u043b\u044f <code class=\"CodeInlined\">UPDATE<\/code> \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u0435 <code class=\"CodeInlined\">WHERE id = ?<\/code>. \u0415\u0441\u043b\u0438 <code class=\"CodeInlined\">id<\/code> \u043d\u0435 \u043f\u0435\u0440\u0435\u0434\u0430\u0442\u044c, \u043b\u0438\u0431\u043e \u043d\u0438\u0447\u0435\u0433\u043e \u043d\u0435 \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u0441\u044f, \u043b\u0438\u0431\u043e (\u0432 \u0445\u0443\u0434\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435) \u043e\u0431\u043d\u043e\u0432\u044f\u0442\u0441\u044f \u0432\u0441\u0435 \u0441\u0442\u0440\u043e\u043a\u0438.<\/p>\n<hr \/>\n<h2>\u0410\u0432\u0442\u043e\u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u044f slug: \u0437\u0430\u0447\u0435\u043c \u0438 \u043a\u0430\u043a<\/h2>\n<p>Slug \u2014 \u044d\u0442\u043e \u0447\u0430\u0441\u0442\u044c URL, \u043f\u043e\u043d\u044f\u0442\u043d\u0430\u044f \u0447\u0435\u043b\u043e\u0432\u0435\u043a\u0443 \u0438 \u043f\u043e\u0438\u0441\u043a\u043e\u0432\u0438\u043a\u0443: \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <code class=\"CodeInlined\">tablitsy-v-html<\/code>. \u0412 \u043a\u043e\u0434\u0435 \u043e\u043d \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0438\u0437 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0430 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0430\u0446\u0438\u0438 \u0438 \u0437\u0430\u043c\u0435\u043d\u044b \u043f\u0440\u043e\u0431\u0435\u043b\u043e\u0432\/\u0441\u043f\u0435\u0446\u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 \u043d\u0430 \u0434\u0435\u0444\u0438\u0441\u044b.<\/p>\n<p>\u041b\u043e\u0433\u0438\u043a\u0430 \u0432 JS:<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">js<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\">titleInput.<span style=\"color: #006600;\">addEventListener<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #ff0000;\">'input'<\/span>, <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span> =<span style=\"color: #66cc66;\">&gt;<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isManualEdit<span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #b1b100;\">return<\/span>; <span style=\"color: #808080; font-style: italic;\">\/\/ \u0435\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0441\u0430\u043c \u043f\u043e\u043f\u0440\u0430\u0432\u0438\u043b slug \u2014 \u043d\u0435 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c<\/span>\r\n    const value = titleInput.<span style=\"color: #006600;\">value<\/span>.<span style=\"color: #006600;\">trim<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0442\u0435\u0440\u0430\u0446\u0438\u044f + \u043e\u0447\u0438\u0441\u0442\u043a\u0430<\/span>\r\n    slugInput.<span style=\"color: #006600;\">value<\/span> = slug;\r\n<span style=\"color: #66cc66;\">}<\/span><span style=\"color: #66cc66;\">)<\/span>;<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u041f\u043e\u0447\u0435\u043c\u0443 \u044d\u0442\u043e \u0443\u0434\u043e\u0431\u043d\u043e:<\/p>\n<ul>\n<li data-value=\"\" data-shift=\"0\">\u041d\u0435 \u043d\u0443\u0436\u043d\u043e \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u043f\u0440\u0438\u0434\u0443\u043c\u044b\u0432\u0430\u0442\u044c URL \u0432\u0440\u0443\u0447\u043d\u0443\u044e.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u0421\u043d\u0438\u0436\u0430\u0435\u0442\u0441\u044f \u0440\u0438\u0441\u043a \u043e\u043f\u0435\u0447\u0430\u0442\u043e\u043a \u0438 \u043d\u0435\u0447\u0438\u0442\u0430\u0435\u043c\u044b\u0445 \u0441\u0442\u0440\u043e\u043a.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u041f\u0440\u0438 \u044d\u0442\u043e\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u043f\u043e\u043f\u0440\u0430\u0432\u0438\u0442\u044c slug \u0432\u0440\u0443\u0447\u043d\u0443\u044e \u2014 \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u044e\u0442 \u0444\u0430\u043a\u0442 \u0440\u0443\u0447\u043d\u043e\u0433\u043e \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f (<code class=\"CodeInlined\">isManualEdit<\/code>).<\/li>\n<\/ul>\n<p>\u041d\u0430 \u0441\u0442\u043e\u0440\u043e\u043d\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 slug \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0443\u044e\u0442: \u0443\u0431\u0438\u0440\u0430\u044e\u0442 \u043b\u0438\u0448\u043d\u0438\u0435 \u0434\u0435\u0444\u0438\u0441\u044b, \u043f\u0440\u0438\u0432\u043e\u0434\u044f\u0442 \u043a \u043d\u0438\u0436\u043d\u0435\u043c\u0443 \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0443. \u041f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435 (<code class=\"CodeInlined\">INSERT<\/code>) \u0435\u0449\u0451 \u0438 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u044e\u0442 \u0437\u0430\u043f\u0430\u0441\u043d\u043e\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442, \u0435\u0441\u043b\u0438 slug \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u0441\u044f \u043f\u0443\u0441\u0442\u044b\u043c.<\/p>\n<hr \/>\n<h2>\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0430\u0442\u044c\u0438: \u043a\u0430\u043a \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043e<\/h2>\n<p>\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0432\u044b\u043d\u0435\u0441\u0435\u043d\u043e \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0432 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0435:<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">php<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'action'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">&amp;&amp;<\/span> $_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'action'<\/span><span style=\"color: #66cc66;\">]<\/span> === <span style=\"color: #ff0000;\">'delete'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 id<\/span>\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ DELETE FROM posts WHERE id = ?<\/span>\r\n    <span style=\"color: #808080; font-style: italic;\">\/\/ \u0440\u0435\u0434\u0438\u0440\u0435\u043a\u0442 \u043d\u0430 \u0441\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0430\u0442\u0435\u0439<\/span>\r\n<span style=\"color: #66cc66;\">}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u041a\u043d\u043e\u043f\u043a\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0432 \u0444\u043e\u0440\u043c\u0435 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 <code class=\"CodeInlined\">name=\"action\" value=\"delete\"<\/code>. \u041f\u0435\u0440\u0435\u0434 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435\u043c \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0441\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u044e\u0442 \u043f\u043e\u0434\u0442\u0432\u0435\u0440\u0436\u0434\u0435\u043d\u0438\u0435 \u0447\u0435\u0440\u0435\u0437 <code class=\"CodeInlined\">confirm()<\/code> \u2014 \u044d\u0442\u043e \u0431\u0430\u0437\u043e\u0432\u0430\u044f \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 \u0441\u043b\u0443\u0447\u0430\u0439\u043d\u044b\u0445 \u043a\u043b\u0438\u043a\u043e\u0432.<\/p>\n<p>\u0412\u0430\u0436\u043d\u043e: \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0435\u043b\u0430\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u043e <code class=\"CodeInlined\">id<\/code>. \u0411\u0435\u0437 <code class=\"CodeInlined\">id<\/code> \u0441\u0435\u0440\u0432\u0435\u0440 \u0441\u0440\u0430\u0437\u0443 \u043e\u0442\u0434\u0430\u0451\u0442 \u043e\u0448\u0438\u0431\u043a\u0443 400.<\/p>\n<hr \/>\n<h2>\u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0444\u043e\u0440\u043c\u044b: INSERT vs UPDATE<\/h2>\n<p>\u0412 <code class=\"CodeInlined\">add_post.php<\/code> \u0440\u0435\u0436\u0438\u043c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u044e\u0442 \u043f\u043e \u043d\u0430\u043b\u0438\u0447\u0438\u044e <code class=\"CodeInlined\">id<\/code>:<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">php<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\">$mode = <span style=\"color: #ff0000;\">'insert'<\/span>;\r\n$id = isset<span style=\"color: #66cc66;\">(<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span> ? <span style=\"color: #66cc66;\">(<\/span><span style=\"color: #0066cc;\">int<\/span><span style=\"color: #66cc66;\">)<\/span>$_POST<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'id'<\/span><span style=\"color: #66cc66;\">]<\/span> : <span style=\"color: #cc66cc;\">0<\/span>;\r\n<span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$id <span style=\"color: #66cc66;\">&gt;<\/span> <span style=\"color: #cc66cc;\">0<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    $mode = <span style=\"color: #ff0000;\">'update'<\/span>;\r\n<span style=\"color: #66cc66;\">}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0414\u0430\u043b\u044c\u0448\u0435 \u2014 \u0434\u0432\u0430 \u0440\u0430\u0437\u043d\u044b\u0445 SQL\u2011\u0437\u0430\u043f\u0440\u043e\u0441\u0430:<\/p>\n<ul>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">INSERT<\/code> \u2014 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u043e\u0432\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443.<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">UPDATE<\/code> \u2014 \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u0442 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0443\u044e \u043f\u043e <code class=\"CodeInlined\">WHERE id = ?<\/code>.<\/li>\n<\/ul>\n<p>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u043f\u0440\u0438\u0432\u044f\u0437\u044b\u0432\u0430\u044e\u0442 \u0447\u0435\u0440\u0435\u0437 <code class=\"CodeInlined\">mysqli_prepare()<\/code> \u0438 <code class=\"CodeInlined\">mysqli_stmt_bind_param()<\/code>. \u042d\u0442\u043e \u0437\u0430\u0449\u0438\u0449\u0430\u0435\u0442 \u043e\u0442 SQL\u2011\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439: \u0434\u0430\u043d\u043d\u044b\u0435 \u043d\u0435 \u043f\u043e\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0432 \u0441\u0442\u0440\u043e\u043a\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u0430, \u0430 \u043f\u0435\u0440\u0435\u0434\u0430\u044e\u0442\u0441\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e.<\/p>\n<p>\u041f\u043e\u0441\u043b\u0435 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u0433\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0434\u0435\u043b\u0430\u044e\u0442 \u0440\u0435\u0434\u0438\u0440\u0435\u043a\u0442 (<code class=\"CodeInlined\">header('Location: ...')<\/code>) \u0438 \u043f\u0435\u0440\u0435\u0434\u0430\u044e\u0442 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u0447\u0435\u0440\u0435\u0437 GET\u2011\u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 (<code class=\"CodeInlined\">?msg=new<\/code> \u0438\u043b\u0438 <code class=\"CodeInlined\">?msg=updated<\/code>). \u042d\u0442\u043e \u043d\u0443\u0436\u043d\u043e, \u0447\u0442\u043e\u0431\u044b:<\/p>\n<ul>\n<li data-value=\"\" data-shift=\"0\">\u0418\u0437\u0431\u0435\u0436\u0430\u0442\u044c \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0444\u043e\u0440\u043c\u044b \u043f\u0440\u0438 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0438 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b (\u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 double submit).<\/li>\n<li data-value=\"\" data-shift=\"0\">\u041f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u0435 \u043e\u0431 \u0443\u0441\u043f\u0435\u0445\u0435 \u043d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0435 \u0444\u043e\u0440\u043c\u044b.<\/li>\n<\/ul>\n<hr \/>\n<h2>\u0412\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u044f \u0438 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u043f\u043e\u043b\u044f<\/h2>\n<p>\u041f\u0435\u0440\u0435\u0434 \u0437\u0430\u043f\u0438\u0441\u044c\u044e \u0432 \u0411\u0414 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u044e\u0442, \u0447\u0442\u043e \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u044b \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u043f\u043e\u043b\u044f:<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">php<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$title === <span style=\"color: #ff0000;\">''<\/span> <span style=\"color: #66cc66;\">||<\/span> $slug === <span style=\"color: #ff0000;\">''<\/span> <span style=\"color: #66cc66;\">||<\/span> $content === <span style=\"color: #ff0000;\">''<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n    http_response_code<span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">400<\/span><span style=\"color: #66cc66;\">)<\/span>;\r\n    echo <span style=\"color: #ff0000;\">'\u041e\u0448\u0438\u0431\u043a\u0430: \u043f\u043e\u043b\u044f title, slug \u0438 content \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b.'<\/span>;\r\n    exit;\r\n<span style=\"color: #66cc66;\">}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u042d\u0442\u043e \u0431\u0430\u0437\u043e\u0432\u0430\u044f \u0432\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u044f \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435. \u0414\u0430\u0436\u0435 \u0435\u0441\u043b\u0438 \u043d\u0430 \u0444\u043e\u0440\u043c\u0435 \u0435\u0441\u0442\u044c <code class=\"CodeInlined\">required<\/code>, \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u0443\u044e \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u0443\u0431\u0438\u0440\u0430\u0442\u044c \u043d\u0435\u043b\u044c\u0437\u044f: \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043c\u043e\u0436\u043d\u043e \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043d\u0430\u043f\u0440\u044f\u043c\u0443\u044e, \u043c\u0438\u043d\u0443\u044f \u0431\u0440\u0430\u0443\u0437\u0435\u0440.<\/p>\n<hr \/>\n<h2>\u0423\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u044f \u043e\u0431 \u0443\u0441\u043f\u0435\u0445\u0435<\/h2>\n<p>\u041d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0435 \u0444\u043e\u0440\u043c\u044b \u0432\u044b\u0432\u043e\u0434\u044f\u0442 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435, \u0435\u0441\u043b\u0438 \u0432 URL \u0435\u0441\u0442\u044c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <code class=\"CodeInlined\">msg<\/code>:<\/p>\n<div class=\"CodeBlock CodeBlock_overflow_visible CodeBlock_highlight\">\n<div class=\"CodeBlock-StickyWrapper\">\n<div class=\"CodeBlock-Header\">\n<div class=\"CodeBlock-HeaderTitle\">php<\/div>\n<pre class=\"actionscript\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>isset<span style=\"color: #66cc66;\">(<\/span>$_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'msg'<\/span><span style=\"color: #66cc66;\">]<\/span><span style=\"color: #66cc66;\">)<\/span><span style=\"color: #66cc66;\">)<\/span>: ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;<\/span>div <span style=\"color: #000000; font-weight: bold;\">class<\/span>=<span style=\"color: #ff0000;\">\"notification\"<\/span><span style=\"color: #66cc66;\">&gt;<\/span>\r\n        <span style=\"color: #66cc66;\">&lt;<\/span>?php\r\n        $msg = $_GET<span style=\"color: #66cc66;\">[<\/span><span style=\"color: #ff0000;\">'msg'<\/span><span style=\"color: #66cc66;\">]<\/span>;\r\n        <span style=\"color: #b1b100;\">if<\/span> <span style=\"color: #66cc66;\">(<\/span>$msg === <span style=\"color: #ff0000;\">'new'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n            echo <span style=\"color: #ff0000;\">'&lt;strong&gt;\u041d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0442\u044c\u044f \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430!&lt;\/strong&gt;'<\/span>;\r\n        <span style=\"color: #66cc66;\">}<\/span> <span style=\"color: #b1b100;\">elseif<\/span> <span style=\"color: #66cc66;\">(<\/span>$msg === <span style=\"color: #ff0000;\">'updated'<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #66cc66;\">{<\/span>\r\n            echo <span style=\"color: #ff0000;\">'&lt;strong&gt;\u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u0430\u0442\u044c\u0438 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u0435\u043d\u043e!&lt;\/strong&gt;'<\/span>;\r\n        <span style=\"color: #66cc66;\">}<\/span>\r\n        ?<span style=\"color: #66cc66;\">&gt;<\/span>\r\n    <span style=\"color: #66cc66;\">&lt;\/<\/span>div<span style=\"color: #66cc66;\">&gt;<\/span>\r\n<span style=\"color: #66cc66;\">&lt;<\/span>?php <span style=\"color: #b1b100;\">endif<\/span>; ?<span style=\"color: #66cc66;\">&gt;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0422\u0430\u043a\u043e\u0439 \u043f\u043e\u0434\u0445\u043e\u0434 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0438 \u043f\u043e\u043d\u044f\u0442\u043d\u044b\u0439: \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0441\u0440\u0430\u0437\u0443 \u0432\u0438\u0434\u0438\u0442 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f.<\/p>\n<hr \/>\n<h2>\u0412\u0430\u0436\u043d\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438 \u0438 \u043d\u0430\u0434\u0451\u0436\u043d\u043e\u0441\u0442\u0438<\/h2>\n<ul>\n<li data-value=\"\" data-shift=\"0\"><strong>\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f<\/strong> (<code class=\"CodeInlined\">prepare + bind_param<\/code>) \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL\u2011\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439.<\/li>\n<li data-value=\"\" data-shift=\"0\"><strong><code class=\"CodeInlined\">htmlspecialchars()<\/code><\/strong> \u043f\u0440\u0438 \u0432\u044b\u0432\u043e\u0434\u0435 \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 XSS.<\/li>\n<li data-value=\"\" data-shift=\"0\"><strong>\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043f\u043e\u043b\u0435\u0439<\/strong> \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 \u043d\u0435\u043f\u043e\u043b\u043d\u044b\u0445 \u0437\u0430\u043f\u0438\u0441\u0435\u0439.<\/li>\n<li data-value=\"\" data-shift=\"0\"><strong>\u041f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u0438\u0435 \u0442\u0438\u043f\u043e\u0432<\/strong> (<code class=\"CodeInlined\">(int)$_GET['id']<\/code>) \u2014 \u0441\u043d\u0438\u0436\u0430\u0435\u0442 \u0440\u0438\u0441\u043a \u043e\u0448\u0438\u0431\u043e\u043a \u0438 \u043d\u0435\u043e\u0436\u0438\u0434\u0430\u043d\u043d\u044b\u0445 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439.<\/li>\n<li data-value=\"\" data-shift=\"0\"><strong>\u0420\u0435\u0434\u0438\u0440\u0435\u043a\u0442 \u043f\u043e\u0441\u043b\u0435 POST<\/strong> \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0438 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0439 \u043f\u0430\u0442\u0442\u0435\u0440\u043d \u00abPost\/Redirect\/Get\u00bb.<\/li>\n<\/ul>\n<hr \/>\n<h2>\u0427\u0435\u0433\u043e \u0432 \u044d\u0442\u043e\u0439 \u0441\u0445\u0435\u043c\u0435 \u043f\u043e\u043a\u0430 \u043d\u0435\u0442 (\u0438 \u0447\u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u043e\u0437\u0436\u0435)<\/h2>\n<ul>\n<li data-value=\"\" data-shift=\"0\">\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438 <code class=\"CodeInlined\">slug<\/code>: \u0441\u0435\u0439\u0447\u0430\u0441 \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435 \u043c\u043e\u0436\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0434\u0432\u0435 \u0441\u0442\u0430\u0442\u044c\u0438 \u0441 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u044b\u043c slug, \u0447\u0442\u043e \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u0442 \u043a \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430\u043c \u0432 \u0440\u043e\u0443\u0442\u0438\u043d\u0433\u0435.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u0411\u043e\u043b\u0435\u0435 \u0441\u043b\u043e\u0436\u043d\u0430\u044f \u0432\u0430\u043b\u0438\u0434\u0430\u0446\u0438\u044f: \u0434\u043b\u0438\u043d\u0430 \u043f\u043e\u043b\u0435\u0439, \u0444\u043e\u0440\u043c\u0430\u0442 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u044b.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u041f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430: \u0441\u0435\u0439\u0447\u0430\u0441 \u043b\u044e\u0431\u043e\u0439, \u043a\u0442\u043e \u0438\u043c\u0435\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u044d\u0442\u0438\u043c \u0444\u0430\u0439\u043b\u0430\u043c, \u043c\u043e\u0436\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c\/\u0443\u0434\u0430\u043b\u044f\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u0438. \u0412 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u0435 \u043d\u0443\u0436\u043d\u0430 \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u044f \u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432.<\/li>\n<li data-value=\"\" data-shift=\"0\">\u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u043e\u0448\u0438\u0431\u043e\u043a \u0411\u0414 \u0431\u043e\u043b\u0435\u0435 \u0434\u0440\u0443\u0436\u0435\u043b\u044e\u0431\u043d\u043e: \u0432\u043c\u0435\u0441\u0442\u043e \u0432\u044b\u0432\u043e\u0434\u0430 \u0441\u044b\u0440\u044b\u0445 \u043e\u0448\u0438\u0431\u043e\u043a \u043b\u0443\u0447\u0448\u0435 \u043b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0438\u0445 \u0438 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u043d\u0435\u0439\u0442\u0440\u0430\u043b\u044c\u043d\u043e\u0435 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435.<\/li>\n<\/ul>\n<h2>\u041a\u0430\u043a \u044d\u0442\u043e \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442:<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-135580 aligncenter\" src=\"https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-15.png\" alt=\"\" width=\"616\" height=\"618\" srcset=\"https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-15.png 616w, https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-15-498x500.png 498w, https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-15-200x201.png 200w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-135581 aligncenter\" src=\"https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-07.png\" alt=\"\" width=\"616\" height=\"618\" srcset=\"https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-07.png 616w, https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-07-498x500.png 498w, https:\/\/rcl-radio.ru\/wp-content\/uploads\/2026\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-\u043e\u0442-2026-08-11-21-47-07-200x201.png 200w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0420\u0430\u043d\u0435\u0435 \u0432 \u041f\u0435\u0440\u0432\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445: \u0444\u043e\u0440\u043c\u0430 \u043d\u0430 HTML + \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u043d\u0430 PHP \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u043f\u0440\u0438\u043c\u0435\u0440 \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e, \u043d\u0438\u0436\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043d \u043a\u043e\u0434 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0439 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c, \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u044f\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u0438. \u0424\u0430\u0439\u043b add_form.php &lt;?php require &#8216;db_connect.php&#8217;; \u00a0 $article = null; $isEdit = false; \u00a0 \/\/ \u0415\u0441\u043b\u0438 \u0432 URL \u0435\u0441\u0442\u044c ?id=\u2026, \u0437\u0430\u0433\u0440\u0443\u0436\u0430\u0435\u043c \u0441\u0442\u0430\u0442\u044c\u044e \u0434\u043b\u044f \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f if (isset($_GET[&#8216;id&#8217;])) { [&hellip;]<\/p>\n","protected":false},"author":9194254,"featured_media":135473,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[557],"tags":[],"class_list":["post-135579","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-557"],"views":24,"_links":{"self":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/users\/9194254"}],"replies":[{"embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=135579"}],"version-history":[{"count":1,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135579\/revisions"}],"predecessor-version":[{"id":135582,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135579\/revisions\/135582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/media\/135473"}],"wp:attachment":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=135579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=135579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=135579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}