{"id":135560,"date":"2026-08-10T12:22:53","date_gmt":"2026-08-10T06:22:53","guid":{"rendered":"https:\/\/rcl-radio.ru\/?p=135560"},"modified":"2026-08-10T12:22:53","modified_gmt":"2026-08-10T06:22:53","slug":"%d1%80%d0%b0%d0%b1%d0%be%d1%82%d0%b0-%d1%81-%d0%b4%d0%b0%d1%82%d0%b0%d0%bc%d0%b8-%d0%b2-mysql-%d0%b8-php","status":"publish","type":"post","link":"https:\/\/rcl-radio.ru\/?p=135560","title":{"rendered":"\u0420\u0430\u0431\u043e\u0442\u0430 \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0432 MySQL \u0438 PHP"},"content":{"rendered":"<p>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u043e\u0431\u044b\u0447\u043d\u043e \u043d\u0435 \u0432 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0435, \u0430 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0432 \u0442\u0440\u0451\u0445 \u043c\u0435\u0441\u0442\u0430\u0445 \u0436\u0438\u0432\u0451\u0442 \u0440\u0430\u0437\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f: \u0432 \u041e\u0421 \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u0445 PHP \u0438 \u0432 MySQL. \u0418\u0437\u2011\u0437\u0430 \u044d\u0442\u043e\u0433\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u0437\u0430\u043f\u0438\u0441\u044c \u043c\u043e\u0436\u0435\u0442 \u00ab\u0435\u0445\u0430\u0442\u044c\u00bb \u043d\u0430 \u0447\u0430\u0441\u044b \u0432\u043f\u0435\u0440\u0451\u0434 \u0438\u043b\u0438 \u043d\u0430\u0437\u0430\u0434 \u2014 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u043a\u043e\u0433\u0434\u0430 \u043f\u0440\u043e\u0435\u043a\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442 \u0437\u0430 \u043f\u0440\u0435\u0434\u0435\u043b\u044b \u043e\u0434\u043d\u043e\u0433\u043e \u0447\u0430\u0441\u043e\u0432\u043e\u0433\u043e \u043f\u043e\u044f\u0441\u0430.<\/p>\n<hr \/>\n<h2>\u041a\u0430\u043a\u043e\u0439 \u0442\u0438\u043f \u043a\u043e\u043b\u043e\u043d\u043a\u0438 \u0432\u044b\u0431\u0440\u0430\u0442\u044c: DATETIME \u0438\u043b\u0438 TIMESTAMP<\/h2>\n<p>\u041a\u043e\u0440\u043e\u0442\u043a\u043e:<\/p>\n<ul>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">DATETIME<\/code> \u2014 \u0445\u0440\u0430\u043d\u0438\u0442 \u0434\u0430\u0442\u0443 \u0438 \u0432\u0440\u0435\u043c\u044f \u0440\u043e\u0432\u043d\u043e \u0442\u0430\u043a, \u043a\u0430\u043a \u0442\u044b \u0435\u0451 \u0437\u0430\u043f\u0438\u0441\u0430\u043b. \u041d\u0438\u043a\u0430\u043a\u0438\u0445 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0430\u0446\u0438\u0439. \u042d\u0442\u043e \u0443\u0434\u043e\u0431\u043d\u043e, \u043a\u043e\u0433\u0434\u0430 \u0432\u0430\u0436\u043d\u043e \u0437\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u00ab\u043c\u043e\u043c\u0435\u043d\u0442 \u043f\u043e \u0447\u0430\u0441\u0430\u043c\u00bb (\u0434\u0430\u0442\u0430 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0441\u0442\u0430\u0442\u044c\u0438, \u0432\u0440\u0435\u043c\u044f \u0437\u0430\u043a\u0430\u0437\u0430, \u0434\u0430\u0442\u0430 \u043f\u043e\u0434\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430).<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">TIMESTAMP<\/code> \u2014 \u0432\u043d\u0443\u0442\u0440\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 UTC, \u0430 \u043f\u0440\u0438 \u0447\u0442\u0435\u043d\u0438\u0438\/\u0437\u0430\u043f\u0438\u0441\u0438 \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u0437\u043e\u043d\u0443 \u0441\u0435\u0441\u0441\u0438\u0438. \u0423\u0434\u043e\u0431\u043d\u043e \u0434\u043b\u044f \u043b\u043e\u0433\u043e\u0432 \u0438 \u0441\u043e\u0431\u044b\u0442\u0438\u0439, \u0433\u0434\u0435 \u0432\u0430\u0436\u043d\u0430 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0430 \u043a \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c\u0443 \u043c\u043e\u043c\u0435\u043d\u0442\u0443, \u043d\u043e \u0437\u043e\u043d\u0430 \u043c\u043e\u0436\u0435\u0442 \u043c\u0435\u043d\u044f\u0442\u044c\u0441\u044f.<\/li>\n<\/ul>\n<p>\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u043e: \u0434\u043b\u044f \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0439, \u0437\u0430\u043a\u0430\u0437\u043e\u0432, \u043b\u044e\u0431\u044b\u0445 \u00ab\u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445\u00bb \u0434\u0430\u0442 \u0431\u0435\u0440\u0438 <code class=\"CodeInlined\">DATETIME<\/code>. \u0414\u043b\u044f \u043b\u043e\u0433\u043e\u0432 \u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0445 \u043c\u0435\u0442\u043e\u043a \u043c\u043e\u0436\u043d\u043e <code class=\"CodeInlined\">TIMESTAMP<\/code>, \u043d\u043e \u0442\u043e\u043b\u044c\u043a\u043e \u0435\u0441\u043b\u0438 \u0437\u043e\u043d\u044b \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043d\u044b \u044f\u0432\u043d\u043e.<\/p>\n<p>\u041f\u0440\u0438\u043c\u0435\u0440 \u0442\u0430\u0431\u043b\u0438\u0446\u044b:<\/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\">sql<\/div>\n<pre class=\"sql\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #993333; font-weight: bold;\">CREATE<\/span> <span style=\"color: #993333; font-weight: bold;\">TABLE<\/span> articles <span style=\"color: #66cc66;\">(<\/span>\r\n    id <span style=\"color: #993333; font-weight: bold;\">INT<\/span> <span style=\"color: #993333; font-weight: bold;\">UNSIGNED<\/span> <span style=\"color: #993333; font-weight: bold;\">AUTO_INCREMENT<\/span> <span style=\"color: #993333; font-weight: bold;\">PRIMARY<\/span> <span style=\"color: #993333; font-weight: bold;\">KEY<\/span><span style=\"color: #66cc66;\">,<\/span>\r\n    title <span style=\"color: #993333; font-weight: bold;\">VARCHAR<\/span><span style=\"color: #66cc66;\">(<\/span><span style=\"color: #cc66cc;\">255<\/span><span style=\"color: #66cc66;\">)<\/span> <span style=\"color: #993333; font-weight: bold;\">NOT<\/span> <span style=\"color: #993333; font-weight: bold;\">NULL<\/span><span style=\"color: #66cc66;\">,<\/span>\r\n    published_at DATETIME <span style=\"color: #993333; font-weight: bold;\">NOT<\/span> <span style=\"color: #993333; font-weight: bold;\">NULL<\/span><span style=\"color: #66cc66;\">,<\/span>          <span style=\"color: #808080; font-style: italic;\">-- \u0444\u0438\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0434\u0430\u0442\u0430 \u043f\u0443\u0431\u043b\u0438\u043a\u0430\u0446\u0438\u0438<\/span>\r\n    created_at <span style=\"color: #993333; font-weight: bold;\">TIMESTAMP<\/span> <span style=\"color: #993333; font-weight: bold;\">NOT<\/span> <span style=\"color: #993333; font-weight: bold;\">NULL<\/span> <span style=\"color: #993333; font-weight: bold;\">DEFAULT<\/span> <span style=\"color: #993333; font-weight: bold;\">CURRENT_TIMESTAMP<\/span><span style=\"color: #66cc66;\">,<\/span> <span style=\"color: #808080; font-style: italic;\">-- \u0430\u0432\u0442\u043e-\u0432\u0440\u0435\u043c\u044f \u0411\u0414<\/span>\r\n    updated_at <span style=\"color: #993333; font-weight: bold;\">TIMESTAMP<\/span> <span style=\"color: #993333; font-weight: bold;\">NULL<\/span> <span style=\"color: #993333; font-weight: bold;\">ON<\/span> <span style=\"color: #993333; font-weight: bold;\">UPDATE<\/span> <span style=\"color: #993333; font-weight: bold;\">CURRENT_TIMESTAMP<\/span>\r\n<span style=\"color: #66cc66;\">)<\/span>;<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<hr \/>\n<h2>\u0413\u0434\u0435 \u0438 \u043a\u0430\u043a \u0437\u0430\u0434\u0430\u0432\u0430\u0442\u044c \u0447\u0430\u0441\u043e\u0432\u043e\u0439 \u043f\u043e\u044f\u0441<\/h2>\n<h3>PHP<\/h3>\n<p>\u041b\u0443\u0447\u0448\u0435 \u0432\u0441\u0435\u0433\u043e \u0437\u0430\u0434\u0430\u0442\u044c \u0437\u043e\u043d\u0443 \u0432 \u043e\u0434\u043d\u043e\u043c \u043c\u0435\u0441\u0442\u0435 \u043f\u0440\u0438 \u0441\u0442\u0430\u0440\u0442\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\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=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #990000;\">date_default_timezone_set<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'UTC'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0414\u0430\u043b\u044c\u0448\u0435 \u0432\u0441\u0435 \u043e\u0431\u044a\u0435\u043a\u0442\u044b <code class=\"CodeInlined\">DateTime<\/code> \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0439 \u0441 \u044f\u0432\u043d\u043e\u0439 \u0437\u043e\u043d\u043e\u0439. \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u0437 \u041c\u043e\u0441\u043a\u0432\u044b \u2014 \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0438\u0440\u0443\u0439 \u0432 <code class=\"CodeInlined\">Europe\/Moscow<\/code> \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u044f.<\/p>\n<p>\u041f\u0440\u0438\u043c\u0435\u0440:<\/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=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #000088;\">$dt<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTime<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'2025-12-10 14:30:00'<\/span><span style=\"color: #339933;\">,<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'Europe\/Moscow'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #000088;\">$utc<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #009900;\">(<\/span>clone <span style=\"color: #000088;\">$dt<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">setTimezone<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'UTC'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #b1b100;\">echo<\/span> <span style=\"color: #000088;\">$utc<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">format<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'Y-m-d H:i:s'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span> <span style=\"color: #666666; font-style: italic;\">\/\/ \u0441\u0442\u0440\u043e\u043a\u0430 \u0434\u043b\u044f \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 DATETIME<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u041d\u0438\u043a\u043e\u0433\u0434\u0430 \u043d\u0435 \u043f\u0435\u0440\u0435\u0434\u0430\u0432\u0430\u0439 \u0432 SQL \u0441\u0442\u0440\u043e\u043a\u0438 \u0432\u0438\u0434\u0430 <code class=\"CodeInlined\">10.12.2025 14:30<\/code> \u2014 \u0444\u043e\u0440\u043c\u0430\u0442 <code class=\"CodeInlined\">d.m.Y<\/code> \u043b\u043e\u043c\u0430\u0435\u0442\u0441\u044f \u043d\u0430 \u0440\u0430\u0437\u043d\u044b\u0445 \u043b\u043e\u043a\u0430\u043b\u044f\u0445. \u0414\u043b\u044f \u0431\u0430\u0437\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439 ISO\u20118601: <code class=\"CodeInlined\">Y-m-d H:i:s<\/code>.<\/p>\n<h3>MySQL<\/h3>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u044c \u0442\u0435\u043a\u0443\u0449\u0438\u0435 \u0437\u043e\u043d\u044b:<\/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\">sql<\/div>\n<pre class=\"php\" style=\"font-family: monospace; font-size: 14px;\">SELECT <span style=\"color: #339933;\">@@<\/span><span style=\"color: #000000; font-weight: bold;\">global<\/span><span style=\"color: #339933;\">.<\/span>time_zone<span style=\"color: #339933;\">,<\/span> <span style=\"color: #339933;\">@@<\/span>session<span style=\"color: #339933;\">.<\/span>time_zone<span style=\"color: #339933;\">;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0415\u0441\u043b\u0438 \u0432\u0438\u0434\u0438\u0448\u044c <code class=\"CodeInlined\">SYSTEM<\/code> \u2014 MySQL \u0431\u0435\u0440\u0451\u0442 \u0437\u043e\u043d\u0443 \u041e\u0421. \u042d\u0442\u043e \u043d\u0435\u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e. \u041b\u0443\u0447\u0448\u0435 \u0437\u0430\u0434\u0430\u0442\u044c UTC \u0432 \u043a\u043e\u043d\u0444\u0438\u0433\u0435 <code class=\"CodeInlined\">my.cnf<\/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\">ini<\/div>\n<pre class=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #009900;\">[<\/span>mysqld<span style=\"color: #009900;\">]<\/span>\r\ndefault_time_zone <span style=\"color: #339933;\">=<\/span> <span style=\"color: #0000ff;\">'+00:00'<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u0442\u0438 MySQL.<\/p>\n<p>\u0414\u043b\u044f \u0441\u0435\u0441\u0441\u0438\u0438 \u043c\u043e\u0436\u043d\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0437\u043e\u043d\u0443 \u043f\u0440\u044f\u043c\u043e \u0438\u0437 PHP:<\/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=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #000088;\">$pdo<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #990000;\">exec<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">\"SET time_zone = '+00:00';\"<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0422\u043e\u0433\u0434\u0430 <code class=\"CodeInlined\">NOW()<\/code> \u0438 <code class=\"CodeInlined\">DEFAULT CURRENT_TIMESTAMP<\/code> \u0431\u0443\u0434\u0443\u0442 \u0432 UTC \u2014 \u043f\u0440\u0435\u0434\u0441\u043a\u0430\u0437\u0443\u0435\u043c\u043e \u0438 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e \u043d\u0430 \u0432\u0441\u0435\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445.<\/p>\n<hr \/>\n<h2>\u041a\u0430\u043a \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0442\u044c \u0434\u0430\u0442\u0443 \u0438\u0437 PHP<\/h2>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0438 ISO\u2011\u0444\u043e\u0440\u043c\u0430\u0442.<\/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=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #000088;\">$pdo<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> PDO<span style=\"color: #009900;\">(<\/span>\r\n    <span style=\"color: #0000ff;\">'mysql:host=localhost;dbname=blog;charset=utf8mb4'<\/span><span style=\"color: #339933;\">,<\/span>\r\n    <span style=\"color: #0000ff;\">'user'<\/span><span style=\"color: #339933;\">,<\/span>\r\n    <span style=\"color: #0000ff;\">'pass'<\/span><span style=\"color: #339933;\">,<\/span>\r\n    <span style=\"color: #009900;\">[<\/span>PDO<span style=\"color: #339933;\">::<\/span><span style=\"color: #004000;\">ATTR_ERRMODE<\/span> <span style=\"color: #339933;\">=&gt;<\/span> PDO<span style=\"color: #339933;\">::<\/span><span style=\"color: #004000;\">ERRMODE_EXCEPTION<\/span><span style=\"color: #009900;\">]<\/span>\r\n<span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #000088;\">$pdo<\/span><span style=\"color: #339933;\">-&gt;<\/span><a href=\"http:\/\/www.php.net\/exec\"><span style=\"color: #990000;\">exec<\/span><\/a><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">\"SET time_zone = '+00:00';\"<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span> <span style=\"color: #666666; font-style: italic;\">\/\/ \u0441\u0435\u0441\u0441\u0438\u044f \u0432 UTC<\/span>\r\n\u00a0\r\n<span style=\"color: #000088;\">$published<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTime<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'2025-11-20 10:00:00'<\/span><span style=\"color: #339933;\">,<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'Europe\/Moscow'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #000088;\">$publishedUtc<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #009900;\">(<\/span>clone <span style=\"color: #000088;\">$published<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">setTimezone<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'UTC'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n\u00a0\r\n<span style=\"color: #000088;\">$sql<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #0000ff;\">'INSERT INTO articles (title, published_at) VALUES (?, ?)'<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #000088;\">$stmt<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000088;\">$pdo<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">prepare<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #000088;\">$sql<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #000088;\">$stmt<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">execute<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #009900;\">[<\/span>\r\n    <span style=\"color: #0000ff;\">'\u041c\u043e\u044f \u0441\u0442\u0430\u0442\u044c\u044f'<\/span><span style=\"color: #339933;\">,<\/span>\r\n    <span style=\"color: #000088;\">$publishedUtc<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">format<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'Y-m-d H:i:s'<\/span><span style=\"color: #009900;\">)<\/span>\r\n<span style=\"color: #009900;\">]<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0415\u0441\u043b\u0438 \u0445\u043e\u0447\u0435\u0448\u044c, \u0447\u0442\u043e\u0431\u044b \u0432\u0440\u0435\u043c\u044f \u0441\u0442\u0430\u0432\u0438\u043b\u0430 \u0441\u0430\u043c\u0430 \u0411\u0414, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439 <code class=\"CodeInlined\">UTC_TIMESTAMP()<\/code> \u2014 \u044d\u0442\u043e \u043d\u0430\u0434\u0451\u0436\u043d\u0435\u0435, \u0447\u0435\u043c <code class=\"CodeInlined\">NOW()<\/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\">sql<\/div>\n<pre class=\"php\" style=\"font-family: monospace; font-size: 14px;\">INSERT INTO articles <span style=\"color: #009900;\">(<\/span>title<span style=\"color: #339933;\">,<\/span> created_at<span style=\"color: #009900;\">)<\/span> VALUES <span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'\u0421\u0442\u0430\u0442\u044c\u044f \u0431\u0435\u0437 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 PHP'<\/span><span style=\"color: #339933;\">,<\/span> UTC_TIMESTAMP<span style=\"color: #009900;\">(<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<hr \/>\n<h2>\u041a\u0430\u043a \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u0447\u0438\u0442\u0430\u0442\u044c \u0438 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0442\u044c \u0434\u0430\u0442\u0443<\/h2>\n<p>\u0425\u0440\u0430\u043d\u0438 \u0432 UTC (\u0438\u043b\u0438 \u043a\u0430\u043a \u0435\u0441\u0442\u044c \u0432 <code class=\"CodeInlined\">DATETIME<\/code>), \u0430 \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0438\u0440\u0443\u0439 \u0432 \u043d\u0443\u0436\u043d\u0443\u044e \u0437\u043e\u043d\u0443 \u0442\u043e\u043b\u044c\u043a\u043e \u043d\u0430 \u0432\u044b\u0432\u043e\u0434\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=\"php\" style=\"font-family: monospace; font-size: 14px;\"><span style=\"color: #000088;\">$stmt<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000088;\">$pdo<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">query<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'SELECT id, title, published_at FROM articles ORDER BY published_at DESC'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #b1b100;\">foreach<\/span> <span style=\"color: #009900;\">(<\/span><span style=\"color: #000088;\">$stmt<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">fetchAll<\/span><span style=\"color: #009900;\">(<\/span>PDO<span style=\"color: #339933;\">::<\/span><span style=\"color: #004000;\">FETCH_ASSOC<\/span><span style=\"color: #009900;\">)<\/span> <span style=\"color: #b1b100;\">as<\/span> <span style=\"color: #000088;\">$row<\/span><span style=\"color: #009900;\">)<\/span> <span style=\"color: #009900;\">{<\/span>\r\n    <span style=\"color: #000088;\">$dt<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTime<span style=\"color: #009900;\">(<\/span><span style=\"color: #000088;\">$row<\/span><span style=\"color: #009900;\">[<\/span><span style=\"color: #0000ff;\">'published_at'<\/span><span style=\"color: #009900;\">]<\/span><span style=\"color: #339933;\">,<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'UTC'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n    <span style=\"color: #000088;\">$userZone<\/span> <span style=\"color: #339933;\">=<\/span> <span style=\"color: #000000; font-weight: bold;\">new<\/span> DateTimeZone<span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'Europe\/Moscow'<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">;<\/span>\r\n    <span style=\"color: #b1b100;\">echo<\/span> <span style=\"color: #000088;\">$dt<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">setTimezone<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #000088;\">$userZone<\/span><span style=\"color: #009900;\">)<\/span><span style=\"color: #339933;\">-&gt;<\/span><span style=\"color: #004000;\">format<\/span><span style=\"color: #009900;\">(<\/span><span style=\"color: #0000ff;\">'d.m.Y H:i'<\/span><span style=\"color: #009900;\">)<\/span> <span style=\"color: #339933;\">.<\/span> <span style=\"color: #0000ff;\">' \u2014 '<\/span> <span style=\"color: #339933;\">.<\/span> <span style=\"color: #000088;\">$row<\/span><span style=\"color: #009900;\">[<\/span><span style=\"color: #0000ff;\">'title'<\/span><span style=\"color: #009900;\">]<\/span> <span style=\"color: #339933;\">.<\/span> PHP_EOL<span style=\"color: #339933;\">;<\/span>\r\n<span style=\"color: #009900;\">}<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0422\u0430\u043a \u0442\u044b \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0448\u044c \u00ab\u0430\u0431\u0441\u043e\u043b\u044e\u0442\u043d\u044b\u0439 \u043c\u043e\u043c\u0435\u043d\u0442\u00bb \u0432 \u0431\u0430\u0437\u0435 \u0438 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0448\u044c \u0435\u0433\u043e \u0432 \u043d\u0443\u0436\u043d\u043e\u0439 \u0437\u043e\u043d\u0435. \u0420\u0430\u0441\u0441\u0438\u043d\u0445\u0440\u043e\u043d \u0438\u0441\u0447\u0435\u0437\u0430\u0435\u0442.<\/p>\n<hr \/>\n<h2>\u041f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 MySQL \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438<\/h2>\n<ul>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">NOW()<\/code> \u2014 \u0442\u0435\u043a\u0443\u0449\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u0441\u0435\u0441\u0441\u0438\u0438 (\u0437\u0430\u0432\u0438\u0441\u0438\u0442 \u043e\u0442 \u0437\u043e\u043d\u044b).<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">UTC_TIMESTAMP()<\/code> \u2014 \u0432\u0441\u0435\u0433\u0434\u0430 UTC.<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">DATE_ADD(date, INTERVAL 1 DAY)<\/code> \u2014 \u043f\u0440\u0438\u0431\u0430\u0432\u0438\u0442\u044c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b.<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">DATEDIFF(date1, date2)<\/code> \u2014 \u0440\u0430\u0437\u043d\u0438\u0446\u0430 \u0432 \u0434\u043d\u044f\u0445.<\/li>\n<li data-value=\"\" data-shift=\"0\"><code class=\"CodeInlined\">CONVERT_TZ(dt, from_tz, to_tz)<\/code> \u2014 \u044f\u0432\u043d\u0430\u044f \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0430\u0446\u0438\u044f \u0437\u043e\u043d.<\/li>\n<\/ul>\n<p>\u041f\u0440\u0438\u043c\u0435\u0440 \u0441 \u044f\u0432\u043d\u043e\u0439 \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0430\u0446\u0438\u0435\u0439:<\/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\">sql<\/div>\n<pre class=\"php\" style=\"font-family: monospace; font-size: 14px;\">SELECT CONVERT_TZ<span style=\"color: #009900;\">(<\/span>published_at<span style=\"color: #339933;\">,<\/span> <span style=\"color: #0000ff;\">'+00:00'<\/span><span style=\"color: #339933;\">,<\/span> <span style=\"color: #0000ff;\">'Europe\/Moscow'<\/span><span style=\"color: #009900;\">)<\/span> <span style=\"color: #b1b100;\">AS<\/span> local_time FROM articles<span style=\"color: #339933;\">;<\/span><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>\u041d\u043e \u043b\u0443\u0447\u0448\u0435 \u0434\u0435\u043b\u0430\u0442\u044c \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0430\u0446\u0438\u044e \u0432 PHP: \u0442\u0430\u043c \u043f\u0440\u043e\u0449\u0435 \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0437\u043e\u043d\u0430\u043c\u0438 \u0438 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u043e\u0431\u044b\u0447\u043d\u043e \u043d\u0435 \u0432 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0435, \u0430 \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0432 \u0442\u0440\u0451\u0445 \u043c\u0435\u0441\u0442\u0430\u0445 \u0436\u0438\u0432\u0451\u0442 \u0440\u0430\u0437\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f: \u0432 \u041e\u0421 \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u0445 PHP \u0438 \u0432 MySQL. \u0418\u0437\u2011\u0437\u0430 \u044d\u0442\u043e\u0433\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u0437\u0430\u043f\u0438\u0441\u044c \u043c\u043e\u0436\u0435\u0442 \u00ab\u0435\u0445\u0430\u0442\u044c\u00bb \u043d\u0430 \u0447\u0430\u0441\u044b \u0432\u043f\u0435\u0440\u0451\u0434 \u0438\u043b\u0438 \u043d\u0430\u0437\u0430\u0434 \u2014 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u043a\u043e\u0433\u0434\u0430 \u043f\u0440\u043e\u0435\u043a\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442 \u0437\u0430 \u043f\u0440\u0435\u0434\u0435\u043b\u044b \u043e\u0434\u043d\u043e\u0433\u043e \u0447\u0430\u0441\u043e\u0432\u043e\u0433\u043e \u043f\u043e\u044f\u0441\u0430. \u041a\u0430\u043a\u043e\u0439 \u0442\u0438\u043f \u043a\u043e\u043b\u043e\u043d\u043a\u0438 \u0432\u044b\u0431\u0440\u0430\u0442\u044c: DATETIME [&hellip;]<\/p>\n","protected":false},"author":9194254,"featured_media":135473,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[183],"tags":[],"class_list":["post-135560","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php"],"views":6,"_links":{"self":[{"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135560","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=135560"}],"version-history":[{"count":1,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135560\/revisions"}],"predecessor-version":[{"id":135561,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=\/wp\/v2\/posts\/135560\/revisions\/135561"}],"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=135560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=135560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rcl-radio.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=135560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}