{"id":135567,"date":"2026-08-10T21:33:35","date_gmt":"2026-08-10T15:33:35","guid":{"rendered":"https:\/\/rcl-radio.ru\/?p=135567"},"modified":"2026-08-10T22:39:25","modified_gmt":"2026-08-10T16:39:25","slug":"%d0%b4%d0%b5%d0%bb%d0%b0%d0%b5%d0%bc-%d0%b2%d1%8b%d0%b2%d0%be%d0%b4-%d1%81%d1%82%d0%b0%d1%82%d0%b5%d0%b9-%d0%b8-%d1%81%d1%82%d1%80%d0%b0%d0%bd%d0%b8%d1%83-%d0%be%d1%82%d0%b4%d0%b5%d0%bb%d1%8c%d0%bd","status":"publish","type":"post","link":"https:\/\/rcl-radio.ru\/?p=135567","title":{"rendered":"\u0414\u0435\u043b\u0430\u0435\u043c \u0432\u044b\u0432\u043e\u0434 \u0441\u0442\u0430\u0442\u0435\u0439 \u0438 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438"},"content":{"rendered":"

\u0424\u0430\u0439\u043b read_post.php<\/p>\n

<<\/span>?php\r\nrequire 'db_connect.php'<\/span>;\r\n\u00a0\r\n$slug = trim(<\/span>$_GET[<\/span>'slug'<\/span>]<\/span> ?? ''<\/span>)<\/span>;\r\nif<\/span> (<\/span>$slug === ''<\/span>)<\/span> {<\/span>\r\n    http_response_code(<\/span>404<\/span>)<\/span>;\r\n    echo '\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span>\r\n\u00a0\r\n\/\/ \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL\u2011\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439<\/span>\r\n$sql = 'SELECT id, title, slug, content, meta_description, is_published, created_at\r\n        FROM posts\r\n        WHERE slug = ? AND is_published = 1'<\/span>;\r\n$stmt = mysqli_prepare(<\/span>$connection, $sql)<\/span>;\r\nif<\/span> (<\/span>!<\/span>$stmt)<\/span> {<\/span>\r\n    http_response_code(<\/span>500<\/span>)<\/span>;\r\n    echo '\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span>\r\nmysqli_stmt_bind_param(<\/span>$stmt, 's'<\/span>, $slug)<\/span>;\r\nmysqli_stmt_execute(<\/span>$stmt)<\/span>;\r\n$result = mysqli_stmt_get_result(<\/span>$stmt)<\/span>;\r\n$article = mysqli_fetch_assoc(<\/span>$result)<\/span>;\r\nmysqli_stmt_close(<\/span>$stmt)<\/span>;\r\n\u00a0\r\nif<\/span> (<\/span>!<\/span>$article)<\/span> {<\/span>\r\n    http_response_code(<\/span>404<\/span>)<\/span>;\r\n    echo '\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span>\r\n?><\/span>\r\n\u00a0\r\n    <<\/span>title><<\/span>?php echo htmlspecialchars(<\/span>$article[<\/span>'title'<\/span>]<\/span>)<\/span>; ?><\/<\/span>title><\/span> \r\n                <<\/span>h1><<\/span>?php echo htmlspecialchars(<\/span>$article[<\/span>'title'<\/span>]<\/span>)<\/span>; ?><\/<\/span>h1><\/span>\r\n                <<\/span>small><\/span>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043e: <<\/span>?php echo date<\/span>(<\/span>'d.m.Y H:i'<\/span>, strtotime(<\/span>$article[<\/span>'created_at'<\/span>]<\/span>)<\/span>)<\/span>; ?><\/<\/span>small><\/span>\r\n            <<\/span>div class<\/span>=\"article-content\"<\/span>><\/span>\r\n                <<\/span>?php echo $article[<\/span>'content'<\/span>]<\/span>; ?><\/span>\r\n            <\/<\/span>div><\/span><\/pre>\n
\u0424\u0430\u0439\u043b read_post_loop.php<\/p>\n
<<\/span>?php\r\nrequire_once 'db_connect.php'<\/span>;\r\n\u00a0\r\n$sql = 'SELECT id, title, slug, meta_description, content, created_at\r\n        FROM posts\r\n        WHERE is_published = 1\r\n        ORDER BY created_at DESC'<\/span>;\r\n\u00a0\r\n$result = mysqli_query(<\/span>$connection, $sql)<\/span>;\r\n\u00a0\r\n\/\/ \u0412\u043c\u0435\u0441\u0442\u043e die() \u0434\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u044b\u0439 \u0432\u044b\u0432\u043e\u0434 \u043e\u0448\u0438\u0431\u043a\u0438, \u0447\u0442\u043e\u0431\u044b \u0444\u0443\u0442\u0435\u0440 \u043d\u0435 \u043f\u0440\u043e\u043f\u0430\u043b<\/span>\r\nif<\/span> (<\/span>!<\/span>$result)<\/span> {<\/span>\r\n    error_log(<\/span>'\u041e\u0448\u0438\u0431\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430: '<\/span> . mysqli_error<\/span>(<\/span>$connection)<\/span>)<\/span>;\r\n    echo '<p style=\"color: red;\">\u041e\u0448\u0438\u0431\u043a\u0430 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0441\u043f\u0438\u0441\u043a\u0430 \u0441\u0442\u0430\u0442\u0435\u0439.<\/p>'<\/span>;\r\n    return<\/span>; \/\/ \u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u043c\u0441\u044f \u0432 \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u0444\u0430\u0439\u043b, \u0447\u0442\u043e\u0431\u044b \u043e\u043d \u0434\u043e\u0440\u0438\u0441\u043e\u0432\u0430\u043b \u0444\u0443\u0442\u0435\u0440<\/span>\r\n}<\/span>\r\n?><\/span>\r\n\u00a0\r\n<<\/span>h2><\/span>\u0421\u0442\u0430\u0442\u044c\u0438<\/<\/span>h2><\/span>\r\n\u00a0\r\n<<\/span>?php if<\/span> (<\/span>mysqli_num_rows(<\/span>$result)<\/span> === 0<\/span>)<\/span>: ?><\/span>\r\n    <<\/span>p><\/span>\u0421\u0442\u0430\u0442\u0435\u0439 \u043f\u043e\u043a\u0430 \u043d\u0435\u0442.<\/<\/span>p><\/span>\r\n<<\/span>?php else<\/span>: ?><\/span>\r\n    <<\/span>ul class<\/span>=\"articles-list\"<\/span>><\/span>\r\n        <<\/span>?php while<\/span> (<\/span>$row = mysqli_fetch_assoc(<\/span>$result)<\/span>)<\/span>: ?><\/span>\r\n            <<\/span>li class<\/span>=\"article-item\"<\/span>><\/span>\r\n                <<\/span>h3><\/span>\r\n                    <!<\/span>-- \u041e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u0430\u044f \u0441\u0441\u044b\u043b\u043a\u0430: \u0431\u0435\u0437 index<\/span>.php<\/span>, \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u043b\u043e\u043c\u0430\u043b\u043e\u0441\u044c \u043f\u0440\u0438 \u043f\u0435\u0440\u0435\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0438 \u0444\u0430\u0439\u043b\u0430 --><\/span>\r\n                    <<\/span>a href=\"?slug=<?php echo htmlspecialchars(urlencode($row['slug'] ?? '')); ?>\"<\/span>><\/span>\r\n\u00a0\r\n                        <<\/span>?php echo htmlspecialchars(<\/span>$row[<\/span>'title'<\/span>]<\/span> ?? ''<\/span>)<\/span>; ?><\/span>\r\n                    <\/<\/span>a><\/span>\r\n                <\/<\/span>h3><\/span>\r\n\u00a0\r\n                <<\/span>?php\r\n                \/\/ \u041b\u043e\u0433\u0438\u043a\u0430 \u0432\u044b\u0431\u043e\u0440\u0430 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f<\/span>\r\n                $preview = ''<\/span>;\r\n\u00a0\r\n                \/\/ 1. \u0415\u0441\u043b\u0438 \u0435\u0441\u0442\u044c meta_description \u2014 \u0431\u0435\u0440\u0451\u043c \u0435\u0433\u043e<\/span>\r\n                if<\/span> (<\/span>!<\/span>empty(<\/span>$row[<\/span>'meta_description'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>\r\n                    $preview = htmlspecialchars(<\/span>$row[<\/span>'meta_description'<\/span>]<\/span>)<\/span>;\r\n                }<\/span> \r\n                \/\/ 2. \u0415\u0441\u043b\u0438 \u043d\u0435\u0442 \u2014 \u0434\u0435\u043b\u0430\u0435\u043c \u0430\u043d\u043e\u043d\u0441 \u0438\u0437 content<\/span>\r\n                else<\/span> {<\/span>\r\n                    $content = $row[<\/span>'content'<\/span>]<\/span> ?? ''<\/span>;\r\n\u00a0\r\n                    \/\/ \u0423\u0434\u0430\u043b\u044f\u0435\u043c HTML-\u0442\u0435\u0433\u0438, \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u0441\u043b\u043e\u043c\u0430\u0442\u044c \u0432\u0435\u0440\u0441\u0442\u043a\u0443 \u0441\u043f\u0438\u0441\u043a\u0430<\/span>\r\n                    $plainText = strip_tags(<\/span>$content)<\/span>;\r\n\u00a0\r\n                    \/\/ \u041e\u0431\u0440\u0435\u0437\u0430\u0435\u043c \u0434\u043e 200 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 (UTF-8 \u0434\u043b\u044f \u043a\u0438\u0440\u0438\u043b\u043b\u0438\u0446\u044b)<\/span>\r\n                    $preview = mb_substr(<\/span>$plainText, 0<\/span>, 200<\/span>, 'UTF-8'<\/span>)<\/span>;\r\n\u00a0\r\n                    \/\/ \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u043c\u043d\u043e\u0433\u043e\u0442\u043e\u0447\u0438\u0435, \u0435\u0441\u043b\u0438 \u0442\u0435\u043a\u0441\u0442 \u0431\u044b\u043b \u043e\u0431\u0440\u0435\u0437\u0430\u043d<\/span>\r\n                    if<\/span> (<\/span>mb_strlen(<\/span>$plainText, 'UTF-8'<\/span>)<\/span> ><\/span> 200<\/span>)<\/span> {<\/span>\r\n                        $preview .= '\u2026'<\/span>;\r\n                    }<\/span>\r\n\u00a0\r\n                    $preview = htmlspecialchars(<\/span>$preview)<\/span>;\r\n                }<\/span>\r\n                ?><\/span>\r\n\u00a0\r\n                <!<\/span>-- \u0412\u044b\u0432\u043e\u0434\u0438\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d \u0440\u0430\u0437 --><\/span>\r\n                <<\/span>?php if<\/span> (<\/span>$preview !<\/span>== ''<\/span>)<\/span>: ?><\/span>\r\n                    <<\/span>p class<\/span>=\"excerpt\"<\/span>><<\/span>?php echo $preview; ?><\/<\/span>p><\/span>\r\n                <<\/span>?php endif<\/span>; ?><\/span>\r\n\u00a0\r\n                <<\/span>small class<\/span>=\"date\"<\/span>><<\/span>?php echo date<\/span>(<\/span>'d.m.Y'<\/span>, strtotime(<\/span>$row[<\/span>'created_at'<\/span>]<\/span> ?? 'now'<\/span>)<\/span>)<\/span>; ?><\/<\/span>small><\/span>\r\n            <\/<\/span>li><\/span>\r\n        <<\/span>?php endwhile<\/span>; ?><\/span>\r\n    <\/<\/span>ul><\/span>\r\n<<\/span>?php endif<\/span>; ?><\/span><\/pre>\n
\u042d\u0442\u043e\u0442 \u043a\u043e\u0434 \u0440\u0435\u0448\u0430\u0435\u0442 \u0434\u0432\u0435 \u0437\u0430\u0434\u0430\u0447\u0438:<\/p>\n
    \n
  • \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0441\u0442\u0430\u0442\u0435\u0439;<\/li>\n
  • \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u043e\u0434\u043d\u0443 \u0441\u0442\u0430\u0442\u044c\u044e \u043f\u043e \u0435\u0451 slug (\u043a\u043e\u0440\u043e\u0442\u043a\u043e\u043c\u0443 \u0430\u0434\u0440\u0435\u0441\u0443).<\/li>\n<\/ul>\n
    \u0420\u0430\u0437\u0431\u0435\u0440\u0451\u043c \u043e\u0431\u0430 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442\u0430 \u043f\u043e \u0441\u0443\u0442\u0438 \u2014 \u0433\u0434\u0435 \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u0442 \u0438 \u0437\u0430\u0447\u0435\u043c.<\/p>\n
    \n
    \u0424\u0440\u0430\u0433\u043c\u0435\u043d\u0442 1: \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438<\/h2>\n
    \n
    \n
    \n
    php<\/div>\n
    require 'db_connect.php'<\/span>;\r\n\u00a0\r\n$slug = trim(<\/span>$_GET[<\/span>'slug'<\/span>]<\/span> ?? ''<\/span>)<\/span>;\r\nif<\/span> (<\/span>$slug === ''<\/span>)<\/span> {<\/span>\r\n    http_response_code(<\/span>404<\/span>)<\/span>;\r\n    echo '\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u0431\u0435\u0440\u0451\u043c slug \u0438\u0437 URL (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, ?slug=my-first-post<\/code>). \u0415\u0441\u043b\u0438 \u0435\u0433\u043e \u043d\u0435\u0442 \u2014 \u0441\u0440\u0430\u0437\u0443 \u043e\u0442\u0434\u0430\u0451\u043c 404. \u042d\u0442\u043e \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 \u0431\u0435\u0441\u0441\u043c\u044b\u0441\u043b\u0435\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0438 \u043b\u0438\u0448\u043d\u0438\u0445 \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u0439 \u043a \u0431\u0430\u0437\u0435.<\/p>\n
    \n
    \n
    \n
    php<\/div>\n
    $sql = 'SELECT id, title, slug, content, meta_description, is_published, created_at\r\n        FROM posts\r\n        WHERE slug = ? AND is_published = 1'<\/span>;\r\n$stmt = mysqli_prepare(<\/span>$connection, $sql)<\/span>;\r\nif<\/span> (<\/span>!<\/span>$stmt)<\/span> {<\/span>\r\n    http_response_code(<\/span>500<\/span>)<\/span>;\r\n    echo '\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span>\r\nmysqli_stmt_bind_param(<\/span>$stmt, 's'<\/span>, $slug)<\/span>;\r\nmysqli_stmt_execute(<\/span>$stmt)<\/span>;\r\n$result = mysqli_stmt_get_result(<\/span>$stmt)<\/span>;\r\n$article = mysqli_fetch_assoc(<\/span>$result)<\/span>;\r\nmysqli_stmt_close(<\/span>$stmt)<\/span>;<\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u0434\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u0447\u0435\u0440\u0435\u0437 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 (mysqli_prepare<\/code>). \u0417\u043d\u0430\u043a ?<\/code> \u2014 \u043c\u0435\u0441\u0442\u043e \u043f\u043e\u0434 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u043c\u044b \u043f\u0435\u0440\u0435\u0434\u0430\u0451\u043c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e (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\u0436\u0435 \u0435\u0441\u043b\u0438 \u043a\u0442\u043e-\u0442\u043e \u043f\u0440\u0438\u0448\u043b\u0451\u0442 \u0437\u043b\u043e\u043d\u0430\u043c\u0435\u0440\u0435\u043d\u043d\u044b\u0439 slug, \u043e\u043d \u043d\u0435 \u0441\u0442\u0430\u043d\u0435\u0442 \u0447\u0430\u0441\u0442\u044c\u044e SQL\u2011\u043a\u043e\u043c\u0430\u043d\u0434\u044b.<\/p>\n
    \u0423\u0441\u043b\u043e\u0432\u0438\u0435 AND is_published = 1<\/code> \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442, \u0447\u0442\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0432\u0438\u0434\u0438\u0442 \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u0441\u0442\u0430\u0442\u044c\u0438.<\/p>\n
    \n
    \n
    \n
    php<\/div>\n
    if<\/span> (<\/span>!<\/span>$article)<\/span> {<\/span>\r\n    http_response_code(<\/span>404<\/span>)<\/span>;\r\n    echo '\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430'<\/span>;\r\n    return<\/span>;\r\n}<\/span>\r\n?><\/span>\r\n\u00a0\r\n<<\/span>title><<\/span>?php echo htmlspecialchars(<\/span>$article[<\/span>'title'<\/span>]<\/span>)<\/span>; ?><\/<\/span>title><\/span> \r\n<<\/span>h1><<\/span>?php echo htmlspecialchars(<\/span>$article[<\/span>'title'<\/span>]<\/span>)<\/span>; ?><\/<\/span>h1><\/span>\r\n<<\/span>small><\/span>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043e: <<\/span>?php echo date<\/span>(<\/span>'d.m.Y H:i'<\/span>, strtotime(<\/span>$article[<\/span>'created_at'<\/span>]<\/span>)<\/span>)<\/span>; ?><\/<\/span>small><\/span>\r\n<<\/span>div class<\/span>=\"article-content\"<\/span>><\/span>\r\n    <<\/span>?php echo $article[<\/span>'content'<\/span>]<\/span>; ?><\/span>\r\n<\/<\/span>div><\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u0435\u0441\u043b\u0438 \u0441\u0442\u0430\u0442\u044c\u0438 \u043d\u0435\u0442 \u2014 \u0441\u043d\u043e\u0432\u0430 404. \u0415\u0441\u043b\u0438 \u0435\u0441\u0442\u044c \u2014 \u0432\u044b\u0432\u043e\u0434\u0438\u043c \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u0438 \u0434\u0430\u0442\u0443. htmlspecialchars<\/code> \u044d\u043a\u0440\u0430\u043d\u0438\u0440\u0443\u0435\u0442 \u0441\u043f\u0435\u0446\u0441\u0438\u043c\u0432\u043e\u043b\u044b: \u044d\u0442\u043e \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 XSS. \u0422\u043e \u0435\u0441\u0442\u044c \u0435\u0441\u043b\u0438 \u0432 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0435 \u043e\u043a\u0430\u0436\u0435\u0442\u0441\u044f <script><\/code>, \u0431\u0440\u0430\u0443\u0437\u0435\u0440 \u043f\u043e\u043a\u0430\u0436\u0435\u0442 \u0435\u0433\u043e \u043a\u0430\u043a \u0442\u0435\u043a\u0441\u0442, \u0430 \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442.<\/p>\n
    \u041a\u043e\u043d\u0442\u0435\u043d\u0442 \u0441\u0442\u0430\u0442\u044c\u0438 \u0432\u044b\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u00ab\u043a\u0430\u043a \u0435\u0441\u0442\u044c\u00bb \u2014 \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u0430\u0433\u0430\u0435\u0442\u0441\u044f, \u0447\u0442\u043e \u043e\u043d \u0443\u0436\u0435 \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, HTML \u0431\u0435\u0437 \u0432\u0440\u0435\u0434\u043e\u043d\u043e\u0441\u043d\u044b\u0445 \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432).<\/p>\n
    \n
    \u0424\u0440\u0430\u0433\u043c\u0435\u043d\u0442 2: \u0441\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0430\u0442\u0435\u0439<\/h2>\n
    \n
    \n
    \n
    php<\/div>\n
    require_once 'db_connect.php'<\/span>;\r\n\u00a0\r\n$sql = 'SELECT id, title, slug, meta_description, content, created_at\r\n        FROM posts\r\n        WHERE is_published = 1\r\n        ORDER BY created_at DESC'<\/span>;\r\n\u00a0\r\n$result = mysqli_query(<\/span>$connection, $sql)<\/span>;\r\n\u00a0\r\nif<\/span> (<\/span>!<\/span>$result)<\/span> {<\/span>\r\n    error_log(<\/span>'\u041e\u0448\u0438\u0431\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430: '<\/span> . mysqli_error<\/span>(<\/span>$connection)<\/span>)<\/span>;\r\n    echo '<p style=\"color: red;\">\u041e\u0448\u0438\u0431\u043a\u0430 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0441\u043f\u0438\u0441\u043a\u0430 \u0441\u0442\u0430\u0442\u0435\u0439.<\/p>'<\/span>;\r\n    return<\/span>;\r\n}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u0432\u0441\u0435 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u0441\u0442\u0430\u0442\u044c\u0438 \u0438 \u0441\u043e\u0440\u0442\u0438\u0440\u0443\u0435\u043c \u043f\u043e \u0434\u0430\u0442\u0435 \u2014 \u043d\u043e\u0432\u044b\u0435 \u0441\u0432\u0435\u0440\u0445\u0443. \u0415\u0441\u043b\u0438 \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0435 \u043f\u0440\u043e\u0448\u0451\u043b, \u043e\u0448\u0438\u0431\u043a\u0443 \u043f\u0438\u0448\u0435\u043c \u0432 \u043b\u043e\u0433 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 (error_log<\/code>), \u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u043d\u0435\u0439\u0442\u0440\u0430\u043b\u044c\u043d\u043e\u0435 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435. \u0422\u0430\u043a \u043d\u0435 \u0440\u0430\u0441\u043a\u0440\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u044f\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0411\u0414.<\/p>\n
    \n
    \n
    \n
    php<\/div>\n
    <<\/span>h2><\/span>\u0421\u0442\u0430\u0442\u044c\u0438<\/<\/span>h2><\/span>\r\n\u00a0\r\n<<\/span>?php if<\/span> (<\/span>mysqli_num_rows(<\/span>$result)<\/span> === 0<\/span>)<\/span>: ?><\/span>\r\n    <<\/span>p><\/span>\u0421\u0442\u0430\u0442\u0435\u0439 \u043f\u043e\u043a\u0430 \u043d\u0435\u0442.<\/<\/span>p><\/span>\r\n<<\/span>?php else<\/span>: ?><\/span>\r\n    <<\/span>ul class<\/span>=\"articles-list\"<\/span>><\/span>\r\n        <<\/span>?php while<\/span> (<\/span>$row = mysqli_fetch_assoc(<\/span>$result)<\/span>)<\/span>: ?><\/span>\r\n            <<\/span>li class<\/span>=\"article-item\"<\/span>><\/span>\r\n                <<\/span>h3><\/span>\r\n                    <<\/span>a href=\"?slug=<?php echo htmlspecialchars(urlencode($row['slug'] ?? '')); ?>\"<\/span>><\/span>\r\n                        <<\/span>?php echo htmlspecialchars(<\/span>$row[<\/span>'title'<\/span>]<\/span> ?? ''<\/span>)<\/span>; ?><\/span>\r\n                    <\/<\/span>a><\/span>\r\n                <\/<\/span>h3><\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u043c \u0441\u043f\u0438\u0441\u043e\u043a. \u0421\u0441\u044b\u043b\u043a\u0430 \u0432\u0435\u0434\u0451\u0442 \u043d\u0430 \u0442\u0443 \u0436\u0435 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443, \u043d\u043e \u0441 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u043c ?slug=\u2026<\/code>. urlencode<\/code> \u0434\u0435\u043b\u0430\u0435\u0442 slug \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u044b\u043c \u0434\u043b\u044f URL (\u043f\u0440\u043e\u0431\u0435\u043b\u044b, \u043a\u0438\u0440\u0438\u043b\u043b\u0438\u0446\u0430 \u0438 \u0442. \u043f. \u043f\u0440\u0435\u0432\u0440\u0430\u0449\u0430\u044e\u0442\u0441\u044f \u0432 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u044b\u0439 \u0444\u043e\u0440\u043c\u0430\u0442). htmlspecialchars<\/code> \u0437\u0430\u0449\u0438\u0449\u0430\u0435\u0442 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u0432 HTML.<\/p>\n
    \n
    \n
    \n
    php<\/div>\n
                    <<\/span>?php\r\n                $preview = ''<\/span>;\r\n\u00a0\r\n                if<\/span> (<\/span>!<\/span>empty(<\/span>$row[<\/span>'meta_description'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>\r\n                    $preview = htmlspecialchars(<\/span>$row[<\/span>'meta_description'<\/span>]<\/span>)<\/span>;\r\n                }<\/span> \r\n                else<\/span> {<\/span>\r\n                    $content = $row[<\/span>'content'<\/span>]<\/span> ?? ''<\/span>;\r\n                    $plainText = strip_tags(<\/span>$content)<\/span>;\r\n                    $preview = mb_substr(<\/span>$plainText, 0<\/span>, 200<\/span>, 'UTF-8'<\/span>)<\/span>;\r\n\u00a0\r\n                    if<\/span> (<\/span>mb_strlen(<\/span>$plainText, 'UTF-8'<\/span>)<\/span> ><\/span> 200<\/span>)<\/span> {<\/span>\r\n                        $preview .= '\u2026'<\/span>;\r\n                    }<\/span>\r\n\u00a0\r\n                    $preview = htmlspecialchars(<\/span>$preview)<\/span>;\r\n                }<\/span>\r\n                ?><\/span>\r\n\u00a0\r\n                <<\/span>?php if<\/span> (<\/span>$preview !<\/span>== ''<\/span>)<\/span>: ?><\/span>\r\n                    <<\/span>p class<\/span>=\"excerpt\"<\/span>><<\/span>?php echo $preview; ?><\/<\/span>p><\/span>\r\n                <<\/span>?php endif<\/span>; ?><\/span>\r\n\u00a0\r\n                <<\/span>small class<\/span>=\"date\"<\/span>><<\/span>?php echo date<\/span>(<\/span>'d.m.Y'<\/span>, strtotime(<\/span>$row[<\/span>'created_at'<\/span>]<\/span> ?? 'now'<\/span>)<\/span>)<\/span>; ?><\/<\/span>small><\/span>\r\n            <\/<\/span>li><\/span>\r\n        <<\/span>?php endwhile<\/span>; ?><\/span>\r\n    <\/<\/span>ul><\/span>\r\n<<\/span>?php endif<\/span>; ?><\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
    \u0421\u0443\u0442\u044c:<\/strong> \u043b\u043e\u0433\u0438\u043a\u0430 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0430\u043d\u043e\u043d\u0441\u0430:<\/p>\n
      \n
    1. \u0415\u0441\u043b\u0438 \u0443 \u0441\u0442\u0430\u0442\u044c\u0438 \u0435\u0441\u0442\u044c meta_description<\/code> \u2014 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u0435\u0433\u043e.<\/li>\n
    2. \u0415\u0441\u043b\u0438 \u043d\u0435\u0442 \u2014 \u0431\u0435\u0440\u0451\u043c content<\/code>, \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0438\u0437 \u043d\u0435\u0433\u043e HTML\u2011\u0442\u0435\u0433\u0438 (strip_tags<\/code>), \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u0441\u043b\u043e\u043c\u0430\u0442\u044c \u0432\u0435\u0440\u0441\u0442\u043a\u0443 \u0441\u043f\u0438\u0441\u043a\u0430.<\/li>\n
    3. \u041e\u0431\u0440\u0435\u0437\u0430\u0435\u043c \u0434\u043e 200 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 \u0441 \u0443\u0447\u0451\u0442\u043e\u043c UTF\u20118 (mb_substr<\/code>, mb_strlen<\/code>). \u0414\u043b\u044f \u043a\u0438\u0440\u0438\u043b\u043b\u0438\u0446\u044b \u044d\u0442\u043e \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e: \u043e\u0431\u044b\u0447\u043d\u044b\u0439 substr<\/code> \u043c\u043e\u0436\u0435\u0442 \u0440\u0430\u0437\u0440\u0435\u0437\u0430\u0442\u044c \u0441\u0438\u043c\u0432\u043e\u043b \u043f\u043e\u043f\u043e\u043b\u0430\u043c.<\/li>\n
    4. \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u2026<\/code>, \u0435\u0441\u043b\u0438 \u0442\u0435\u043a\u0441\u0442 \u0431\u044b\u043b \u043e\u0431\u0440\u0435\u0437\u0430\u043d.<\/li>\n
    5. \u042d\u043a\u0440\u0430\u043d\u0438\u0440\u0443\u0435\u043c \u0441\u043f\u0435\u0446\u0441\u0438\u043c\u0432\u043e\u043b\u044b \u0447\u0435\u0440\u0435\u0437 htmlspecialchars<\/code>.<\/li>\n<\/ol>\n
      \n
      \u041a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b, \u0433\u0434\u0435 \u044d\u0442\u043e \u0443\u043c\u0435\u0441\u0442\u043d\u043e<\/h2>\n
        \n
      • \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b<\/strong> \u2014 \u0432\u0441\u0435\u0433\u0434\u0430 \u0434\u043b\u044f \u0432\u044b\u0431\u043e\u0440\u043a\u0438 \u043f\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u043c (slug, ID, \u0444\u0438\u043b\u044c\u0442\u0440\u044b). \u042d\u0442\u043e \u0431\u0430\u0437\u043e\u0432\u0430\u044f \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL\u2011\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439.<\/li>\n
      • \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 is_published<\/code><\/strong> \u2014 \u0432\u0435\u0437\u0434\u0435, \u0433\u0434\u0435 \u043a\u043e\u043d\u0442\u0435\u043d\u0442 \u0432\u0438\u0434\u044f\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438. \u0427\u0435\u0440\u043d\u043e\u0432\u0438\u043a\u0438 \u043d\u0435 \u0434\u043e\u043b\u0436\u043d\u044b \u0431\u044b\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b \u043f\u043e \u043f\u0440\u044f\u043c\u044b\u043c \u0441\u0441\u044b\u043b\u043a\u0430\u043c.<\/li>\n
      • htmlspecialchars<\/code><\/strong> \u2014 \u043f\u0440\u0438 \u0432\u044b\u0432\u043e\u0434\u0435 \u043b\u044e\u0431\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043c\u043e\u0433\u0443\u0442 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u044c \u0441\u043f\u0435\u0446\u0441\u0438\u043c\u0432\u043e\u043b\u044b \u0438\u043b\u0438 \u0431\u044b\u0442\u044c \u043f\u043e\u0434 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0435\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f (\u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0438, \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f).<\/li>\n
      • urlencode<\/code><\/strong> \u2014 \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0432 URL.<\/li>\n
      • strip_tags<\/code> + mb_*<\/code> \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/strong> \u2014 \u043a\u043e\u0433\u0434\u0430 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0430\u043d\u043e\u043d\u0441 \u0438\u0437 HTML\u2011\u043a\u043e\u043d\u0442\u0435\u043d\u0442\u0430 \u0438 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e \u043e\u0431\u0440\u0435\u0437\u0430\u0442\u044c \u0435\u0433\u043e \u0434\u043b\u044f \u043a\u0438\u0440\u0438\u043b\u043b\u0438\u0446\u044b.<\/li>\n
      • \u041b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043e\u0448\u0438\u0431\u043e\u043a \u0432\u043c\u0435\u0441\u0442\u043e \u0432\u044b\u0432\u043e\u0434\u0430 \u0434\u0435\u0442\u0430\u043b\u0435\u0439<\/strong> \u2014 \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u044e\u044e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0411\u0414 \u0438 \u043d\u0435 \u043f\u043e\u043c\u043e\u0433\u0430\u0442\u044c \u0437\u043b\u043e\u0443\u043c\u044b\u0448\u043b\u0435\u043d\u043d\u0438\u043a\u0430\u043c.<\/li>\n<\/ul>\n
        \n
        \u041a\u0430\u043a \u0432\u044b\u0432\u043e\u0434\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e \u0438\u043b\u0438 \u0441\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0430\u0442\u0435\u0439<\/h2>\n
        \u0424\u0430\u0439\u043b index.php<\/p>\n
        <!<\/span>DOCTYPE html><\/span>\r\n<<\/span>html<\/span> lang=\"ru\"<\/span>><\/span>\r\n  <<\/span>head><\/span>\r\n    <<\/span>meta charset=\"utf-8\"<\/span>><\/span>\r\n    <<\/span>meta name<\/span>=\"viewport\"<\/span> content=\"width=device-width, initial-scale=1\"<\/span>><\/span>\r\n    <<\/span>title><\/span>\u0411\u043b\u043e\u0433: \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u0442\u0430\u0442\u044c\u0438<\/<\/span>title><\/span>\r\n    <<\/span>link rel=\"stylesheet\"<\/span> href=\"site.css\"<\/span>><\/span>\r\n  <\/<\/span>head><\/span>\r\n  <<\/span>body><\/span>\r\n    <<\/span>div class<\/span>=\"site-wrapper\"<\/span>><\/span> <!<\/span>-- \u041d\u043e\u0432\u0430\u044f \u043e\u0431\u0451\u0440\u0442\u043a\u0430 --><\/span>\r\n      <<\/span>header><\/span>\r\n        <<\/span>div class<\/span>=\"container header-content\"<\/span>><\/span>\r\n          <<\/span>a href=\".\/\"<\/span> class<\/span>=\"logo\"<\/span>><\/span>Website<\/<\/span>a><\/span>\r\n          <<\/span>nav><\/span>\r\n            <<\/span>ul><\/span>\r\n              <<\/span>li><<\/span>a href=\".\/\"<\/span>><\/span>\u0413\u043b\u0430\u0432\u043d\u0430\u044f<\/<\/span>a><\/<\/span>li><\/span>\r\n              <<\/span>li><<\/span>a href=\"\/articles\"<\/span>><\/span>\u0421\u0442\u0430\u0442\u044c\u0438<\/<\/span>a><\/<\/span>li><\/span>\r\n              <<\/span>li><<\/span>a href=\"\/about\"<\/span>><\/span>\u041e \u043f\u0440\u043e\u0435\u043a\u0442\u0435<\/<\/span>a><\/<\/span>li><\/span>\r\n            <\/<\/span>ul><\/span>\r\n          <\/<\/span>nav><\/span>\r\n        <\/<\/span>div><\/span>\r\n      <\/<\/span>header><\/span>\r\n\u00a0\r\n      <<\/span>div class<\/span>=\"main-wrapper\"<\/span>><\/span>\r\n        <<\/span>aside class<\/span>=\"sidebar-left\"<\/span>><\/span>\r\n          <!<\/span>-- \u041b\u0435\u0432\u0430\u044f \u043f\u0430\u043d\u0435\u043b\u044c --><\/span>\r\n          \u041b\u0435\u0432\u0430\u044f \u043f\u0430\u043d\u0435\u043b\u044c\r\n        <\/<\/span>aside><\/span>\r\n\u00a0\r\n        <<\/span>main class<\/span>=\"container\"<\/span>><\/span>\r\n          <<\/span>nav><<\/span>a href=\"add_form.php\"<\/span>><\/span>\u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0430\u0442\u044c\u044e<\/<\/span>a><\/<\/span>nav><\/span>\r\n          <<\/span>hr><\/span>\r\n          <<\/span>?php if<\/span> (<\/span>empty(<\/span>$_GET)<\/span>)<\/span> {<\/span>require 'read_post_loop.php'<\/span>;}<\/span>?><\/span>\r\n          <<\/span>?php if<\/span> (<\/span>isset(<\/span>$_GET[<\/span>'slug'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>require 'read_post.php'<\/span>;}<\/span>?><\/span>\r\n        <\/<\/span>main><\/span>\r\n\u00a0\r\n        <<\/span>aside class<\/span>=\"sidebar-right\"<\/span>><\/span>\r\n        \u041f\u0440\u0430\u0432\u0430\u044f \u043f\u0430\u043d\u0435\u043b\u044c\r\n          <!<\/span>-- \u041f\u0440\u0430\u0432\u0430\u044f \u043f\u0430\u043d\u0435\u043b\u044c --><\/span>\r\n        <\/<\/span>aside><\/span>\r\n      <\/<\/span>div><\/span>\r\n\u00a0\r\n      <<\/span>footer><\/span>\r\n        <<\/span>p>&<\/span>copy<\/span>; 2026<\/span> Website. \u0412\u0441\u0435 \u043f\u0440\u0430\u0432\u0430 \u0437\u0430\u0449\u0438\u0449\u0435\u043d\u044b.<\/<\/span>p><\/span>\r\n      <\/<\/span>footer><\/span>\r\n    <\/<\/span>div><\/span>\r\n  <\/<\/span>body><\/span>\r\n<\/<\/span>html><\/span><\/pre>\n
        \u0412\u044b\u0432\u043e\u0434 \u0441\u0442\u0430\u0442\u044c\u0438 \u0438\u043b\u0438 \u0441\u043f\u0438\u0441\u043a\u0430 \u0441\u0442\u0430\u0442\u0435\u0439 \u0437\u0434\u0435\u0441\u044c \u0446\u0435\u043b\u0438\u043a\u043e\u043c \u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 GET\u2011\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u00a0\u2014\u00a0\u0442\u043e \u0435\u0441\u0442\u044c \u043e\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u0432 URL.<\/p>\n
        \u041a\u0430\u043a \u044d\u0442\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/h2>\n
          \n
        • \u0415\u0441\u043b\u0438 URL \u0442\u0430\u043a\u043e\u0439: site.com\/<\/code> \u0438\u043b\u0438 site.com\/articles<\/code> (\u0431\u0435\u0437 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432) \u2192 $_GET<\/code> \u043f\u0443\u0441\u0442\u043e\u0439 \u2192 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u0441\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0430\u0442\u0435\u0439<\/strong>.<\/li>\n
        • \u0415\u0441\u043b\u0438 URL \u0442\u0430\u043a\u043e\u0439: site.com\/?slug=my-post<\/code> \u2192 \u0432 $_GET['slug']<\/code> \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u2192 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u043e\u0434\u043d\u0443 \u0441\u0442\u0430\u0442\u044c\u044e<\/strong> \u0441 \u044d\u0442\u0438\u043c slug.<\/li>\n<\/ul>\n
          \u0418\u043c\u0435\u043d\u043d\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 slug<\/code> \u0432 GET\u2011\u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0433\u043e\u0432\u043e\u0440\u0438\u0442 \u0441\u043a\u0440\u0438\u043f\u0442\u0443: \u00ab\u043f\u043e\u043a\u0430\u0436\u0438 \u043d\u0435 \u0441\u043f\u0438\u0441\u043e\u043a, \u0430 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c\u00bb.<\/p>\n
          \u0413\u0434\u0435 \u0432 \u043a\u043e\u0434\u0435 \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043e<\/h2>\n
          \u0412 HTML\u2011\u0444\u0430\u0439\u043b\u0435 \u0441\u0442\u043e\u0438\u0442 \u0442\u0430\u043a\u0430\u044f \u043b\u043e\u0433\u0438\u043a\u0430 (\u0442\u043e\u043b\u044c\u043a\u043e \u043e\u043d\u0430 \u043e\u0442\u0432\u0435\u0447\u0430\u0435\u0442 \u0437\u0430 \u0432\u044b\u0431\u043e\u0440, \u0447\u0442\u043e \u0432\u044b\u0432\u043e\u0434\u0438\u0442\u044c):<\/p>\n
          \n
          \n
          \n
          php<\/div>\n
          \n
          <<\/span>?php if<\/span> (<\/span>empty(<\/span>$_GET)<\/span>)<\/span> {<\/span>require ‘read_post_loop.php’<\/span>;}<\/span>?><\/span><\/div>\n
          <<\/span>?php if<\/span> (<\/span>isset(<\/span>$_GET[<\/span>‘slug’<\/span>]<\/span>)<\/span>)<\/span> {<\/span>require ‘read_post.php’<\/span>;}<\/span>?><\/span><\/div>\n<\/blockquote>\n<\/div>\n<\/div>\n<\/div>\n
          \u0427\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442:<\/p>\n
            \n
          1. empty($_GET)<\/code> \u2014 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442, \u043d\u0435\u0442 \u043b\u0438 \u0432\u043e\u043e\u0431\u0449\u0435 GET\u2011\u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432. \u0415\u0441\u043b\u0438 \u043d\u0435\u0442 \u2014 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u0442 read_post_loop.php<\/code> (\u0441\u043f\u0438\u0441\u043e\u043a).<\/li>\n
          2. isset($_GET['slug'])<\/code> \u2014 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442, \u0435\u0441\u0442\u044c \u043b\u0438 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 slug<\/code>. \u0415\u0441\u043b\u0438 \u0435\u0441\u0442\u044c \u2014 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u0442 read_post.php<\/code> (\u043e\u0434\u043d\u0430 \u0441\u0442\u0430\u0442\u044c\u044f).<\/li>\n<\/ol>\n
            \n
            \u041f\u0440\u0438\u043c\u0435\u0440 URL:<\/h2>\n
            https:\/\/rcl-radio.ru\/test\/?slug=tablitsy-v-html-risuem-prostuyu-tablitsu<\/code><\/p>\n
            \u0427\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u043f\u0440\u0438 \u0442\u0430\u043a\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435<\/h2>\n
              \n
            1. \u0411\u0440\u0430\u0443\u0437\u0435\u0440 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 GET\u2011\u0437\u0430\u043f\u0440\u043e\u0441<\/strong> \u043d\u0430 \u0430\u0434\u0440\u0435\u0441 https:\/\/rcl-radio.ru\/test\/<\/code> \u0438 \u043f\u0435\u0440\u0435\u0434\u0430\u0451\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 slug<\/code> \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c tablitsy-v-html-risuem-prostuyu-tablitsu<\/code>.<\/li>\n
            2. PHP \u0432\u0438\u0434\u0438\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440:<\/strong> \u0432 \u0441\u0443\u043f\u0435\u0440\u0433\u043b\u043e\u0431\u0430\u043b\u044c\u043d\u043e\u043c \u043c\u0430\u0441\u0441\u0438\u0432\u0435 $_GET<\/code> \u043f\u043e\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0437\u0430\u043f\u0438\u0441\u044c:\n
              \n
              \n
              \n
              php<\/div>\n
              $_GET[<\/span>'slug'<\/span>]<\/span> === 'tablitsy-v-html-risuem-prostuyu-tablitsu'<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n
            3. \u0421\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0432 \u0442\u0432\u043e\u0451\u043c HTML\u2011\u0444\u0430\u0439\u043b\u0435:<\/strong>\n
              \n
              \n
              \n
              php<\/div>\n
              if<\/span> (<\/span>isset(<\/span>$_GET[<\/span>'slug'<\/span>]<\/span>)<\/span>)<\/span> {<\/span>\r\n    require 'read_post.php'<\/span>;\r\n}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
              \u2192 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0444\u0430\u0439\u043b, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u044b\u0432\u043e\u0434\u0438\u0442 \u043e\u0434\u043d\u0443 \u0441\u0442\u0430\u0442\u044c\u044e<\/strong>.<\/li>\n
            4. \u0412\u043d\u0443\u0442\u0440\u0438 read_post.php<\/code> \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0431\u0435\u0440\u0443\u0442 \u0438\u0437 GET \u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u043a \u0411\u0414:<\/strong>\n
              \n
              \n
              \n
              php<\/div>\n
              $slug = trim(<\/span>$_GET[<\/span>'slug'<\/span>]<\/span> ?? ''<\/span>)<\/span>;\r\n\/\/ \u0434\u0430\u043b\u0435\u0435: WHERE slug = ? AND is_published = 1<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n
              \u0421\u0438\u0441\u0442\u0435\u043c\u0430 \u0438\u0449\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 posts<\/code> \u0441\u0442\u0440\u043e\u043a\u0443, \u0433\u0434\u0435 slug<\/code> \u0442\u043e\u0447\u043d\u043e \u0441\u043e\u0432\u043f\u0430\u0434\u0430\u0435\u0442 \u0441 \u0442\u0435\u043c, \u0447\u0442\u043e \u043f\u0440\u0438\u0448\u0451\u043b \u0432 URL. \u0415\u0441\u043b\u0438 \u043d\u0430\u0445\u043e\u0434\u0438\u0442 \u0438 \u0441\u0442\u0430\u0442\u044c\u044f \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 (is_published = 1<\/code>)\u00a0\u2014\u00a0\u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u0435\u0451. \u0415\u0441\u043b\u0438 \u043d\u0435\u0442\u00a0\u2014\u00a0\u043e\u0442\u0434\u0430\u0451\u0442 404.<\/li>\n<\/ol>\n
              \n
              \u0410 \u0435\u0441\u043b\u0438 URL \u0431\u0435\u0437 slug<\/code> (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, https:\/\/rcl-radio.ru\/test\/<\/code>)<\/h2>\n
              \u0422\u043e\u0433\u0434\u0430:<\/p>\n
                \n
              • $_GET<\/code> \u043f\u0443\u0441\u0442\u043e\u0439 \u2192 \u0441\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442:\n
                \n
                \n
                \n
                php<\/div>\n
                if<\/span> (<\/span>empty(<\/span>$_GET)<\/span>)<\/span> {<\/span>\r\n    require 'read_post_loop.php'<\/span>;\r\n}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n
              • \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0444\u0430\u0439\u043b, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0434\u0435\u043b\u0430\u0435\u0442 SELECT<\/code> \u0432\u0441\u0435\u0445 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0441\u0442\u0430\u0442\u0435\u0439 \u0438 \u0432\u044b\u0432\u043e\u0434\u0438\u0442 \u0441\u043f\u0438\u0441\u043e\u043a<\/strong>.<\/li>\n<\/ul>\n
                \n
                \u041e\u0442\u043a\u0443\u0434\u0430 \u0432 \u0441\u043f\u0438\u0441\u043a\u0435 \u0431\u0435\u0440\u0443\u0442\u0441\u044f \u0442\u0430\u043a\u0438\u0435 \u0441\u0441\u044b\u043b\u043a\u0438<\/h2>\n
                \u0412 read_post_loop.php<\/code> \u0441\u0441\u044b\u043b\u043a\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u044e\u0442 \u0442\u0430\u043a:<\/p>\n
                \n
                \n
                \n
                php<\/div>\n
                <<\/span>a href=\"?slug=<?php echo htmlspecialchars(urlencode($row['slug'] ?? '')); ?>\"<\/span>><\/span>\r\n    <<\/span>?php echo htmlspecialchars(<\/span>$row[<\/span>'title'<\/span>]<\/span> ?? ''<\/span>)<\/span>; ?><\/span>\r\n<\/<\/span>a><\/span>\r\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n
                \u041a\u043e\u0433\u0434\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043a\u043b\u0438\u043a\u0430\u0435\u0442, \u0431\u0440\u0430\u0443\u0437\u0435\u0440 \u0431\u0435\u0440\u0451\u0442 \u0442\u0435\u043a\u0443\u0449\u0438\u0439 \u0430\u0434\u0440\u0435\u0441 \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043a \u043d\u0435\u043c\u0443 ?slug=\u2026<\/code>\u00a0\u2014\u00a0\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f \u0440\u043e\u0432\u043d\u043e \u0442\u0430\u043a\u043e\u0439 GET\u2011\u0437\u0430\u043f\u0440\u043e\u0441, \u043a\u0430\u043a \u0432 \u0442\u0432\u043e\u0451\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435.<\/p>\n
                \u0421\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0430\u0442\u0435\u0439:<\/p>\n
                \"\"<\/p>\n
                \u0421\u0442\u0430\u0442\u044c\u044f:<\/p>\n
                \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
                \u0424\u0430\u0439\u043b read_post.php <?php require ‘db_connect.php’; \u00a0 $slug = trim($_GET[‘slug’] ?? »); if ($slug === ») { http_response_code(404); echo ‘\u0421\u0442\u0430\u0442\u044c\u044f \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430’; return; } \u00a0 \/\/ \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u2014 \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 SQL\u2011\u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439 $sql = ‘SELECT id, title, slug, content, meta_description, is_published, created_at FROM posts WHERE slug = ? AND is_published = 1’; $stmt = mysqli_prepare($connection, $sql); […]<\/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-135567","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-557"],"views":13,"_links":{"self":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135567","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=135567"}],"version-history":[{"count":2,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135567\/revisions"}],"predecessor-version":[{"id":135571,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135567\/revisions\/135571"}],"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=135567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=135567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=135567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}