<?php
$GLOBALS['pdo'] = new PDO("mysql:host=localhost;port=3306;dbname=exercise;charset=utf8", "root", "", array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
if(!$GLOBALS['pdo']) {
    return "Kunne ikke forbinde til sql serveren";
}

// Select
$stmt = $GLOBALS['pdo']->prepare("SELECT `id`, `name`, `user` FROM `user` WHERE `user` = :user");
$stmt->bindParam(":user", $_POST['user']);
$stmt->execute();
if($stmt->rowCount() > 0) {
    $user = $stmt->fetch(PDO::FETCH_ASSOC);
} else {
    $user = false;
}


// Insert
$name = "Patrick";
$user = "pkkann";
$pass = "mypassword";

$stmt = $GLOBALS['pdo']->prepare("INSERT INTO `user` (`name`, `user`, `pass`) VALUES (:name, :user, :pass)");
$stmt->bindParam(":name", $name);
$stmt->bindParam(":user", $user);
$stmt->bindParam(":pass", $pass);
$stmt->execute();
?>