<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
if($argc == 2) {
    $con = new PDO($argv[1]);
}
if($argc == 4) {
    $con = new PDO($argv[1], $argv[2], $argv[3]);
}
$stmt = $con->prepare('INSERT INTO customer VALUES(?,?,?)');
$cid = 6;
$name = 'F company';
$phone = '6666-6666';
$stmt->execute(array($cid, $name, $phone));
$stmt = $con->prepare('INSERT INTO customer_actual VALUES(?,?,?,?,?)');
$cid = 6;
$address1 = 'F road 6';
$address2 = 'F town';
$contact = 'Mr. F';
$discount = 10;
$stmt->execute(array($cid, $address1, $address2, $contact, $discount));
$stmt = $con->prepare('INSERT INTO order_main VALUES(?,?,?)');
$oid = 6;
$customer = 6;
$status = 'In progress';
$stmt->execute(array($oid, $customer, $status));
$stmt = $con->prepare('INSERT INTO order_line VALUES(?,?,?,?,?)');
$olid = 8;
$order = 6;
$item = 'X stuff';
$quantity = 1;
$price = '72.00';
$stmt->execute(array($olid, $order, $item, $quantity, $price));
?>