prepare( 'INSERT INTO allergies ("label", "from", "to") VALUES (:label, :from, :to)'); $query->execute([ 'label' => 'Peanuts', 'from' => strtotime('2025-01-01'), 'to' => strtotime('2025-12-31'), ]); // last inserted id $lastId = $pdo->lastInsertId(); echo 'Last inserted id: ' . $lastId; // R = READ // select data from table $query = $pdo->prepare('SELECT * FROM allergies'); $query->execute(); $allergies = $query->fetchAll(PDO::FETCH_ASSOC); echo ""; foreach ($allergies as $allergy) { // echo '

';
    // print_r($allergy);
    // echo '

'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

" . $allergy['id'] . "

" . $allergy['label'] . "

" . date('d.m. Y', $allergy['from']) . "

" . date('d.m. Y', $allergy['to']) . "

"; // U = UPDATE // update data in table $query = $pdo->prepare('UPDATE allergies SET "label" = :label WHERE "id" = :id'); $query->execute([ 'label' => 'Peanuts (updated)', 'id' => $lastId, ]); // D = DELETE // delete data from table $query = $pdo->prepare('DELETE FROM allergies WHERE "id" = :id'); $query->execute([ 'id' => $lastId, ]);