\u0414\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0433\u043e\u0441\u0442\u0435\u0432\u043e\u0439 \u043a\u043d\u0438\u0433\u0438 \u043d\u0430 PHP \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0438 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434:<\/p>\n
1. \u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL:<\/p>\n
«`sql<\/p>\n
CREATE TABLE guestbook (<\/p>\n
\u00a0 <\/span>id INT(11) NOT NULL AUTO_INCREMENT,<\/p>\n \u00a0 <\/span>name VARCHAR(50) NOT NULL,<\/p>\n \u00a0 <\/span>email VARCHAR(50) NOT NULL,<\/p>\n \u00a0 <\/span>message TEXT NOT NULL,<\/p>\n \u00a0 <\/span>created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,<\/p>\n \u00a0 <\/span>PRIMARY KEY (id)<\/p>\n );<\/p>\n «`<\/p>\n 2. \u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0444\u0430\u0439\u043b\u044b index.php \u0438 process.php.<\/p>\n 3. \u0412 \u0444\u0430\u0439\u043b\u0435 index.php \u0441\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0444\u043e\u0440\u043c\u0443 \u0434\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f:<\/p>\n «`html<\/p>\n <form action=»process.php» method=»post»><\/p>\n \u00a0 <\/span><label for=»name»>Name:<\/label><\/p>\n \u00a0 <\/span><input type=»text» name=»name» id=»name» required><\/p>\n \u00a0 <\/span><label for=»email»>Email:<\/label><\/p>\n \u00a0 <\/span><input type=»email» name=»email» id=»email» required><\/p>\n \u00a0 <\/span><label for=»message»>Message:<\/label><\/p>\n \u00a0 <\/span><textarea name=»message» id=»message» required><\/textarea><\/p>\n \u00a0 <\/span><button type=»submit»>Submit<\/button><\/p>\n <\/form><\/p>\n «`<\/p>\n 4. \u0412 \u0444\u0430\u0439\u043b\u0435 process.php \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0430\u0439\u0442\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u0444\u043e\u0440\u043c\u044b \u0438 \u0434\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u0438\u0445 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n «`php<\/p>\n <?php<\/p>\n \/\/ \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n $host = ‘localhost’;<\/p>\n $user = ‘username’;<\/p>\n $password = ‘password’;<\/p>\n $dbname = ‘database_name’;<\/p>\n $dsn = «mysql:host=$host;dbname=$dbname;charset=utf8mb4»;<\/p>\n $options = [<\/p>\n \u00a0 <\/span>PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,<\/p>\n \u00a0 <\/span>PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,<\/p>\n \u00a0 <\/span>PDO::ATTR_EMULATE_PREPARES => false,<\/p>\n ];<\/p>\n try {<\/p>\n \u00a0 <\/span>$pdo = new PDO($dsn, $user, $password, $options);<\/p>\n } catch (\\PDOException $e) {<\/p>\n \u00a0 <\/span>throw new \\PDOException($e->getMessage(), (int)$e->getCode());<\/p>\n }<\/p>\n \/\/ \u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0444\u043e\u0440\u043c\u044b<\/p>\n $name = $_POST[‘name’];<\/p>\n $email = $_POST[’email’];<\/p>\n $message = $_POST[‘message’];<\/p>\n \/\/ \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n $stmt = $pdo->prepare(«INSERT INTO guestbook (name, email, message) VALUES (?, ?, ?)»);<\/p>\n $stmt->execute([$name, $email, $message]);<\/p>\n \/\/ \u041f\u0435\u0440\u0435\u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u0430 \u0433\u043b\u0430\u0432\u043d\u0443\u044e \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443<\/p>\n header(‘Location: index.php’);<\/p>\n exit;<\/p>\n «`<\/p>\n 5. \u0412 \u0444\u0430\u0439\u043b\u0435 index.php \u0432\u044b\u0432\u0435\u0434\u0438\u0442\u0435 \u0432\u0441\u0435 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f \u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n «`php<\/p>\n <?php<\/p>\n \/\/ \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n $host = ‘localhost’;<\/p>\n $user = ‘username’;<\/p>\n $password = ‘password’;<\/p>\n $dbname = ‘database_name’;<\/p>\n $dsn = «mysql:host=$host;dbname=$dbname;charset=utf8mb4»;<\/p>\n $options = [<\/p>\n \u00a0 <\/span>PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,<\/p>\n \u00a0 <\/span>PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,<\/p>\n \u00a0 <\/span>PDO::ATTR_EMULATE_PREPARES => false,<\/p>\n ];<\/p>\n try {<\/p>\n \u00a0 <\/span>$pdo = new PDO($dsn, $user, $password, $options);<\/p>\n } catch (\\PDOException $e) {<\/p>\n \u00a0 <\/span>throw new \\PDOException($e->getMessage(), (int)$e->getCode());<\/p>\n }<\/p>\n \/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0432\u0441\u0435\u0445 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n $stmt = $pdo->query(«SELECT * FROM guestbook ORDER BY created_at DESC»);<\/p>\n $messages = $stmt->fetchAll();<\/p>\n ?><\/p>\n <!— \u0412\u044b\u0432\u043e\u0434 \u0432\u0441\u0435\u0445 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 —><\/p>\n <?php foreach ($messages as $message): ?><\/p>\n \u00a0 <\/span><div><\/p>\n \u00a0 \u00a0 <\/span><h3><?= $message[‘name’] ?><\/h3><\/p>\n \u00a0 \u00a0 <\/span><p><?= $message[’email’] ?><\/p><\/p>\n \u00a0 \u00a0 <\/span><p><?= $message[‘message’] ?><\/p><\/p>\n \u00a0 \u00a0 <\/span><p><?= $message[‘created_at’] ?><\/p><\/p>\n \u00a0 <\/span><\/div><\/p>\n <?php endforeach; ?><\/p>\n «`<\/p>\n \u0413\u043e\u0441\u0442\u0435\u0432\u0430\u044f \u043a\u043d\u0438\u0433\u0430 \u043d\u0430 PHP \u0433\u043e\u0442\u043e\u0432\u0430!<\/p>\n","protected":false},"excerpt":{"rendered":" \u0414\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0433\u043e\u0441\u0442\u0435\u0432\u043e\u0439 \u043a\u043d\u0438\u0433\u0438 \u043d\u0430 PHP \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0438 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434:<\/p>\n","protected":false},"author":1,"featured_media":202,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[110,17],"tags":[111,4,112],"class_list":["post-201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-php","tag-mysql","tag-php","tag-112"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=201"}],"version-history":[{"count":1,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":203,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions\/203"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=\/wp\/v2\/media\/202"}],"wp:attachment":[{"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/newsitebuilder.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}