<?php
require('inc/config.php');
require('inc/DB.php');
    $options =[
        'php miegas',
        'php atsikelimas',
        'php forma',
        'php data',
        'php',
    ];
    $darbopav = $_POST['darbopav'];
    $darboapr = $_POST['darboapr'];
    $svarbumas = $_POST['svarbumas'];
    $time = $_POST['time'];
    $id = $_GET['delete'];
    $laikas2;
if(isset($_POST['submit'])) {
    try{
        $stmt="INSERT INTO darbas2 (darbopav, darboapr, svarbumas, time) VALUES(:darbopav, :darboapr, :svarbumas, :time)";
        $querie = $pdo->prepare($stmt);
        $querie->execute(array($darbopav, $darboapr, $svarbumas, $time));
    } catch (Exception $e){
        echo "Negaliu pridett";
        echo $e->getMessage();
        exit;
    }
}
if(isset($_GET['delete'])) {
    try {
        $stmt = "DELETE FROM darbas2 where id = ?";
        $querie = $pdo->prepare($stmt);
        $querie->execute(array($id));
        $messages['ok']= "Įrašas sėkmingai pašalintas";

    } catch (Exception $e) {
        echo "Negaliu pašalinti įrašo";
        $messages['error'] = $e->getMessage();
        exit;
    }
}
?>

<form method="post">
    <select name="darbopav">
    <option>pasirinkite</option>
    <?php foreach($options as $raktas): ?>
    <option value="<?php echo $raktas ?> "><?php echo $raktas ?> </option>
    <?php endforeach; ?>
    </select>
    <input type="field" name="darboapr">
    <select name="svarbumas">
        <option value="Svarbus">Svarbus</option>
        <option value="Nesvarbus">Nesvarbus</option>
    </select>
    <input type="time" name="time">
    <button name="submit">submit</button>
</form>
<?php
try {
    $stmt = $pdo->query('SELECT * FROM darbas2');
} catch (Exception $e) {
    echo "Klaida: Negaliu gauti duomenų iš DB";
    exit;
}
$data = $stmt->fetchAll();
$laikas1 = '8:00';
$laikas2 = '1:00'
?>
<table>
    <thead>
    <tr>
        <th>Pavadinimas</th>
        <th>Aprašymas</th>
        <th>Data</th>
        <th>laikas atlikt</th>
        <th>dabartinis laikas</th>
        <th>likes h</th>
        <th>DELETE</th>
    </tr>
    </thead>
    <tbody>
    <?php foreach($data as $item):?>
        <tr>
            <td><?php echo $item['darbopav']; ?></td>
            <td><?php echo $item['svarbumas']; ?></td>
            <td><?php echo $item['darboapr']; ?></td>
            <td><?php echo $item['time']; ?></td>
            <td><?php echo date("  h:i:s ")  ?></td>
            <td><?php
                $now = date("h:i");
                $your_date = $item['time'];
                $datediff = $your_date - $now  ;
                echo $datediff;
                ?></td>





            <td><a href="?<?php echo $_SERVER['QUERY_STRING']?>&delete=<?php echo $item['id'];?>" onclick="return confirm('Ar tikrai norite pašalinti?')">Šalinti</a></td>
        </tr>
    <?php endforeach; ?>
    </tbody>
</table>



<?php
$settings = [

//Main settings

'main' => [
'site-name' => 'klases darbas'
],

//DB settings

'DB' => [
'host' => 'localhost',
'database' => 'klasesdb',
'user' => 'root',
'pass' => '',
'charset' => 'utf8mb4',
]
];
<?php

$host = $settings['DB']['host'];
$db = $settings['DB']['database'];
$charset= $settings['DB']['charset'];
$user = $settings['DB']['user'];
$pass = $settings['DB']['pass'];

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
    $pdo = new PDO($dsn, $user, $pass, $opt);
} catch (Exception $e) {
    echo "Negaliu prisijungti prie DB<br>";
    echo $e->getMessage();
    exit;
}