· 9 years ago · May 02, 2017, 08:50 PM
1<?php
2
3$dsn = 'mysql:host=localhost;dbname=demin';
4$username = 'demin';
5$password = 'neto0974';
6$options = array(
7 PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
8);
9
10$pdo = new PDO($dsn, $username, $password, $options);
11
12$sql = "
13SET time_zone = '+00:00';
14SET foreign_key_checks = 0;
15SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
16
17DROP TABLE IF EXISTS `tasks`;
18CREATE TABLE `tasks` (
19 `id` int(11) NOT NULL AUTO_INCREMENT,
20 `description` text NOT NULL,
21 `is_done` tinyint(4) NOT NULL DEFAULT '0',
22 `date_added` datetime NOT NULL,
23 PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
25
26$pdo->query($sql);
27
28?>
29
30<!DOCTYPE html>
31<html lang="en">
32<head>
33 <meta charset="UTF-8">
34 <title>Дела</title>
35</head>
36<body>
37 <form action="GET">
38 <input type="text" name="description" placeholder="ОпиÑание задачи">
39 <input type="submit" placeholder="Добавить">
40 </form>
41
42 <table border="1">
43 <tr>
44 <td>
45 ОпиÑание задачи
46 </td>
47 <td>
48 Дата добавлениÑ
49 </td>
50 <td>
51 СтатуÑ
52 </td>
53 <td>
54
55 </td>
56 </tr>
57 <?php
58 echo '<tr>';
59 foreach($pdo->query('SELECT * FROM tasks') as $row){
60 echo '<td>' . $row['description'] . '</td>' . '<td>' . $row['date_added'] . '</td>';
61 }
62 echo '</tr>';
63 ?>
64 </table>
65</body>
66</html>