<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
$con = new SQLite3('/disk2/arne/art/dbx/test.db');
$stmt = $con->prepare('INSERT INTO customer VALUES(?,?,?)');
$cid = 6;
$name = 'F company';
$phone = '6666-6666';
$stmt->bindParam(1, $cid, SQLITE3_INTEGER);
$stmt->bindParam(2, $name, SQLITE3_TEXT);
$stmt->bindParam(3, $phone, SQLITE3_TEXT);
$stmt->execute();
$stmt = $con->prepare('INSERT INTO customer_actual VALUES(?,?,?,?,?)');
$cid = 6;
$address1 = 'F road 6';
$address2 = 'F town';
$contact = 'Mr. F';
$discount = 10;
$stmt->bindParam(1, $cid, SQLITE3_INTEGER);
$stmt->bindParam(2, $address1, SQLITE3_TEXT);
$stmt->bindParam(3, $address2, SQLITE3_TEXT);
$stmt->bindParam(4, $contact, SQLITE3_TEXT);
$stmt->bindParam(5, $discount, SQLITE3_INTEGER);
$stmt->execute();
$stmt = $con->prepare('INSERT INTO order_main VALUES(?,?,?)');
$oid = 6;
$customer = 6;
$status = 'In progress';
$stmt->bindParam(1, $oid, SQLITE3_INTEGER);
$stmt->bindParam(2, $customer, SQLITE3_INTEGER);
$stmt->bindParam(3, $status, SQLITE3_TEXT);
$stmt->execute();
$stmt = $con->prepare('INSERT INTO order_line VALUES(?,?,?,?,?)');
$olid = 8;
$order = 6;
$item = 'X stuff';
$quantity = 1;
$price = '72.00';
$stmt->bindParam(1, $olid, SQLITE3_INTEGER);
$stmt->bindParam(2, $customer, SQLITE3_INTEGER);
$stmt->bindParam(3, $item, SQLITE3_TEXT);
$stmt->bindParam(4, $quantity, SQLITE3_INTEGER);
$stmt->bindParam(5, $price, SQLITE3_TEXT);
$stmt->execute();
$con->close();
?>