Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- date_default_timezone_set('UTC');
- function isGet()
- {
- return $_SERVER['REQUEST_METHOD'] == 'GET';
- }
- $dsn = 'mysql:host=localhost;dbname=demin';
- $username = 'demin';
- $password = '****';
- $options = array(
- PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
- );
- $pdo = new PDO($dsn, $username, $password, $options);
- if(isGet()){
- if(!empty($_GET['description'])){
- $pdo->query('INSERT INTO tasks(description, date_added) VALUES ('. "'" . $_GET['description'] . "'" . ', ' . "'" . date('Y-m-d H:i:s',time()) . "'" . ');');
- }else{
- if(!empty($_GET['delete'])){
- $pdo->query('DELETE FROM tasks WHERE id=' . $_GET['delete'] . ';');
- }else{
- if(!empty($_GET['done'])){
- $pdo->query('UPDATE tasks SET is_done = 1 WHERE id=' . $_GET['done'] . ';');
- }
- }
- }
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>Дела</title>
- </head>
- <body>
- <form action="">
- <input type="text" name="description" placeholder="Описание задачи">
- <input type="submit" value="Добавить">
- </form>
- <table border="1">
- <tr>
- <td>
- Описание задачи
- </td>
- <td>
- Дата добавления
- </td>
- <td>
- Статус
- </td>
- <td>
- </td>
- </tr>
- <?php
- foreach($pdo->query('SELECT * FROM tasks;') as $row){
- ?> <tr>
- <td><?php
- echo $row['description'];?>
- </td>
- <td>
- <?php echo $row['date_added']; ?>
- </td>
- <td>
- <?php
- echo $row['is_done'] == 1 ? 'Выполнено' : 'Не выполнено';
- ?>
- </td>
- <td>
- <?php
- echo '<a href="?done=' . $row['id'] . '">Выполнить</a>';
- echo '<a href="?delete=' . $row['id'] . '">Удалить</a>';
- ?>
- </td>
- </tr>
- <?php
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement