PDO su mysql

//Atvaizduoti
<?php
try {
    $db = new PDO("mysql:host=localhost;dbname=test1", "root", "pass");
}
catch(PDOException $e){
    echo $e->getMessage();
}
//su while atvaizduoja viska
/*$duom = $db->query("SELECT * FROM user");
while($data = $duom->fetch(PDO::FETCH_ASSOC)) {
    echo $data['vardas']." ".$data['email']."<br />"; //etc...
}*/

/*foreach($db->query('SELECT * FROM user') as $row) {
    echo $row['vardas'].' '.$row['email']; //etc...
}*/

//atvaizduoja viena
/*$duom = $db->query("SELECT * FROM user WHERE id = '1'");
$data = $duom->fetch(PDO::FETCH_ASSOC);

echo $data['vardas'];*/

$db = null;
?>
//

//Irasyti
<?php

$db = new PDO("mysql:host=localhost;dbname=test", "root", "pass");

if(isset($_POST['irasyti'])){

    $message = $_POST['message'];

    $duom = $db->prepare("INSERT INTO shoutbox (message) VALUES (:message)");
    $duom->execute(array(":message" => $message));
    echo"Irasyta!";

} else {

    echo"<form method='post' action='insert.php'>

        <input type='text' name='message' />
        <input type='submit' value='Irasyti' name='irasyti' />

    </form>";

}

//$db = null;

?>
//
//Viena atvaozduoja pagal get
<?php

$db = new PDO("mysql:host=localhost;dbname=test", "root", "pass");


$id = $_GET['id'];
$duom = $db->prepare("SELECT * FROM user WHERE id = :id");
$duom->execute(array(":id" => $id));
$data = $duom->fetch(PDO::FETCH_ASSOC);

echo $data['vardas'];

$db = null;

?>
//