<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
include '/disk2/arne/migr/relsub/order.php';

$con = new PDO('sqlite:/disk2/arne/migr/relsub/order.db');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$ostmt = $con->prepare('INSERT INTO myorder VALUES(:ID,:CUSTOMER)');
$olstmt = $con->prepare('INSERT INTO orderline VALUES(:ID,:ORDERID,:ITEM,:QTY)');
$o = new Order(11, 'K K', array(new OrderLine(1100, 11, 'A good PHP book', 1)));
foreach($o->lines as $ol) {
    $olstmt->execute(array(':ID' => $ol->id, ':ORDERID' => $ol->orderid, ':ITEM' => $ol->item, ':QTY' => $ol->qty));
}
$ostmt->execute(array(':ID' => $o->id, ':CUSTOMER' => $o->customer));
$o = new Order(12, 'L L', array(new OrderLine(1200, 12, 'Another good PHP book', 1)));
foreach($o->lines as $ol) {
    $olstmt->execute(array(':ID' => $ol->id, ':ORDERID' => $ol->orderid, ':ITEM' => $ol->item, ':QTY' => $ol->qty));
}
$ostmt->execute(array(':ID' => $o->id, ':CUSTOMER' => $o->customer));
?>