{"id":298084,"date":"2020-02-02T15:00:22","date_gmt":"2020-02-02T15:00:22","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=298084"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=298084","title":{"rendered":"To-do list \u0437\u0430 5 \u043c\u0438\u043d\u0443\u0442 \u043d\u0430 PHP"},"content":{"rendered":"\n
\u041f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e \u0432\u0441\u0435\u0445. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0445\u043e\u0442\u0435\u043b \u0431\u044b \u0432\u0430\u043c \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c, \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0437\u0430\u0434\u0430\u0447 (To-do list) \u0432\u0441\u0435\u0433\u043e \u0437\u0430 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0438\u043d\u0443\u0442 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 PHP, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL. <\/p>\n

\u0414\u043b\u044f \u043d\u0430\u0447\u0430\u043b\u043e, \u0445\u043e\u0442\u0435\u043b\u043e\u0441\u044c \u0431\u044b \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u0430\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0441\u0435\u0433\u043e\u0434\u043d\u044f\u0448\u043d\u0435\u0433\u043e \u043f\u0440\u0438\u043c\u0435\u0440\u0430:<\/p>\n

\"image\"\/
<\/a>
\u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u0447\u043d\u0435\u043c \u0441 HTML \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0441 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c .php<\/p>\n

index.php<\/b><\/i><\/p>\n

<!DOCTYPE html> <html> <head> \t<meta charset="UTF-8"> \t<link rel="stylesheet" href="style.css"> \t<title>TO-DO List<\/title> <\/head> <body> \t<form action="add.php" method="POST"> \t\t<input type="text" name="title" required> \t\t<input type="submit" value="Add"> \t<\/form> \t \t<ul> \t\t \t<\/ul> <\/body> <\/html> <\/code><\/pre>\n
  \u0412 \u0434\u0430\u043d\u043d\u043e\u043c \u043a\u043e\u0434\u0435, \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u043e\u0440\u043c\u0443 \u0434\u043b\u044f \u0432\u0432\u043e\u0434\u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u2014 input type=\u00abtext\u00bb<\/i>, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043a\u043d\u043e\u043f\u043a\u0443 \u2014 input type=\u00absubmit\u00bb<\/i> \u0434\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n
  \u0422\u0430\u043a\u0436\u0435 \u043f\u0440\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c \u0430\u0442\u0440\u0438\u0431\u0443\u0442 name=\u00abtitle\u00bb<\/b><\/i> \u0434\u043b\u044f \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441\u043e \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u043c.<\/p>\n
  \u0414\u0430\u043b\u044c\u0448\u0435 \u0438\u0434\u0435\u043c \u0432 phpmyadmin<\/i> \u0438 \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n
  1. \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445<\/b><\/p>\n
  \"image\"\/<\/p>\n
  2. \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/b><\/p>\n
  \"image\"\/<\/p>\n
  3. \u0417\u0430\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0438 \u043d\u0430\u0436\u0438\u043c\u0430\u0435\u043c \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c<\/b><\/p>\n
  \"image\"\/<\/p>\n
  \u041f\u043e\u0441\u043b\u0435 \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b db.php<\/p>\n
  db.php<\/b><\/p>\n
<?php  $dsn = 'mysql:host=localhost;dbname=to-do-list'; $pdo = new PDO($dsn, 'root', '');  ?> <\/code><\/pre>\n
  \u0421\u0442\u0440\u043e\u043a\u0430: $dsn = 'mysql:host=localhost;dbname=to-do-list';<\/b> <\/i><\/code>
  \u0433\u0434\u0435 dbname=to-do-list; <\/i><\/b><\/code>\u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n
  \u0422\u0435\u043f\u0435\u0440\u044c add.php<\/p>\n
  add.php<\/p>\n
<?php   \t\/\/\u041f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \t$title = $_POST['title'];  \t\/\/\u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \trequire 'db.php';          \/\/\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u043a \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0435 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445         $sql = 'INSERT INTO list(title) VALUES(:title)';  \t$query = $pdo->prepare($sql);    \t$query->execute(['title' => $title]);          \/\/\u041f\u0435\u0440\u0435\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0432 index.php \u043f\u043e\u0441\u043b\u0435 \u0437\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u0438\u0435 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \theader('Location: index.php');  ?> <\/code><\/pre>\n
  \u0422\u0435\u043f\u0435\u0440\u044c \u043e\u0431\u0440\u0430\u0442\u043d\u043e \u0438\u0434\u0435\u043c \u0432 index.php<\/p>\n
  index.php<\/p>\n
 <!DOCTYPE html> <html> <head> \t<meta charset="UTF-8"> \t<link rel="stylesheet" href="style.css"> \t<title>TO-DO List<\/title> <\/head> <body> \t<form action="add.php" method="POST"> \t\t<input type="text" name="title" required> \t\t<input type="submit" value="Add"> \t<\/form> \t \t<ul> \t\t<?php                  \/\/\u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0444\u0430\u0439\u043b\u0430 db.php \t\trequire 'db.php'; \t\t                 \/\/\u0411\u0435\u0440\u0435\u043c \u0432\u0441\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b list  \t\t$query = $pdo->query('SELECT * FROM `list` ORDER BY `id` DESC');                                  \/\/\u0426\u0438\u043a\u043b \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u044b\u0432\u043e\u0434\u0438\u0442 \u0432\u0441\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \t\twhile($row = $query->fetch(PDO::FETCH_OBJ)) { \t\t        echo '<div><li>'. $row->title .' <a href="delete.php?id='.$row->id.'" id="card-link-click">X<\/a><\/li>' . ' <\/div>';  \t\t\t} \t\t ?> \t<\/ul> <\/body> <\/html> <\/code><\/pre>\n
  \u041a\u0430\u043a \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0443\u0432\u0438\u0434\u0435\u0442\u044c, \u0432\u043d\u0443\u0442\u0440\u044c \u0442\u0435\u0433\u0430 ul<\/code> \u043c\u044b \u0432\u0441\u0442\u0430\u0432\u0438\u043b\u0438 php \u043a\u043e\u0434.<\/p>\n
  \u0418 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u044d\u0442\u043e delete.php<\/p>\n
  delete.php<\/p>\n
 <?php   \/\/\u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0444\u0430\u0439\u043b\u0430 db.php require 'db.php';  \/\/\u041f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f $id = $_GET['id'];  \/\/\u0423\u0434\u0430\u043b\u044f\u0435\u043c \u044d\u043b\u0435\u043c\u0435\u043d\u0442 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b list \u0441 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u043c id   $sql = 'DELETE FROM `list` WHERE `id` = ?';   $query = $pdo->prepare($sql);   $query->execute([$id]);  \/\/\u041f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u0435\u043c\u0441\u044f \u0432 index.php   header('Location: index.php');   ?>  <\/code><\/pre>\n
  \u0422\u0430\u043a\u0436\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u043c \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u0441\u0442\u0438\u043b\u044f.<\/p>\n
  style.css<\/p>\n
body { \tpadding: 40px; }  input[type="text"] { \twidth: 330px; \theight: 40px; \tborder: 1px solid #c4c4c4; \tborder-radius: 5px 0 0 5px; \tborder-right: none; \tpadding-left: 10px; \tpadding-right: 10px; }  input[type="submit"] { \twidth: 80px; \theight: 44px; \tbackground: #3F6BDE; \tborder: none;  \tposition: absolute; \tborder: 1px solid #c4c4c4; \tborder-radius: 0 5px 5px 0; }  ul { \tlist-style: none; \tpadding-left: 0; }  li { \twidth: 400px; \theight: auto; \tborder: 2px solid gray; \tpadding-top: 20px; \tlist-style: none;     padding: 15px;     margin-bottom: 10px;     background: #fcfcfc;     border: 1px solid silver;     border-radius: 5px;\t }  a {     float: right;     text-decoration: none;     color: red; }  <\/code><\/pre>\n
  \u0412\u0441\u0435 \u0433\u043e\u0442\u043e\u0432\u043e.<\/p>\n
  \u0418\u0442\u043e\u0433\u043e, \u043c\u044b \u0441\u0434\u0435\u043b\u0430\u043b\u0438 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0441\u043f\u0438\u0441\u043e\u043a \u0437\u0430\u0434\u0430\u0447 \u0438\u043b\u0438 To-do list \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 PHP.<\/p>\n
  \u0414\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e:<\/b><\/p>\n
  \u0421\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u0438\u0441\u0445\u043e\u0434\u043d\u0438\u043a \u043a \u0443\u0440\u043e\u043a\u0443<\/a>.<\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  https:\/\/habr.com\/ru\/post\/486624\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n
\u041f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e \u0432\u0441\u0435\u0445. \u0421\u0435\u0433\u043e\u0434\u043d\u044f \u044f \u0445\u043e\u0442\u0435\u043b \u0431\u044b \u0432\u0430\u043c \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c, \u043a\u0430\u043a \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0437\u0430\u0434\u0430\u0447 (To-do list) \u0432\u0441\u0435\u0433\u043e \u0437\u0430 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043c\u0438\u043d\u0443\u0442 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 PHP, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL. <\/p>\n
  \u0414\u043b\u044f \u043d\u0430\u0447\u0430\u043b\u043e, \u0445\u043e\u0442\u0435\u043b\u043e\u0441\u044c \u0431\u044b \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0432\u0430\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0441\u0435\u0433\u043e\u0434\u043d\u044f\u0448\u043d\u0435\u0433\u043e \u043f\u0440\u0438\u043c\u0435\u0440\u0430:<\/p>\n
  \"image\"\/  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-298084","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/298084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=298084"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/298084\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=298084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=298084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=298084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}