<meta charset="utf-8">
<?php

$dbname = 'introdb';
$host = 'localhost';
$user = 'introdb';
$password = 'introdb';

// connect to db (DBH = Database Handle)
$DBH = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $password);

// READ
// query db (STH Statement handler)
$STH = $DBH->prepare("SELECT * FROM data");
$STH->setFetchMode(PDO::FETCH_OBJ);
$STH->execute();
var_dump($STH->fetchAll());

// CREATE
$str = "En liten text";
$STH = $DBH->prepare("INSERT INTO data (text) VALUES (:text)");
$STH->bindParam(':text', $str, PDO::PARAM_STR);
// $STH->execute();

// UPDATE
$str ="Leo was here";
$id = 1;
$STH = $DBH->prepare("UPDATE data SET text = :text WHERE id = :id");
$STH->bindParam(':text', $str, PDO::PARAM_STR);
$STH->bindParam(':id', $id, PDO::PARAM_INT);
$STH->execute();

// DELETE
$id = 3;
$STH = $DBH->prepare("DELETE FROM data WHERE id=:id");
$STH->bindParam(':id', $id, PDO::PARAM_INT);
$STH->execute();