<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php

// open database
$con = new PDO('sqlite:/disk2/arne/ipc/sqlite/msgs.db');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
// write message to database
$ins = $con->prepare('INSERT INTO msgs(msg) VALUES(:msg)');
$ins->execute(array(':msg' => 'Hi from PHP!'));
// dump all messages in database
$sel = $con->prepare('SELECT msg FROM msgs');
$sel->execute(array());
while($row = $sel->fetch()) {
    $msg = $row['msg'];
    echo "|$msg|\r\n";
}

?>