<!-- 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/inher/asset.php';

$con = new PDO('sqlite:/disk2/arne/migr/inher/asset.db');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$stmt = $con->prepare('INSERT INTO asset VALUES(:ID,:DESCRIPTION,:ASSETTYPE)');
$toolstmt = $con->prepare('INSERT INTO toolasset VALUES(:ID,:TOOLTYPE,:NAME,:WEIGHT)');
$a = new ToolAsset(10, 'Normal wheelbarrow', 'Wheelbarrow', 'Noname', 25);
$stmt->execute(array(':ID' => $a->id, ':DESCRIPTION' => $a->description, ':ASSETTYPE' => $a->assetType));
$toolstmt->execute(array(':ID' => $a->id, ':TOOLTYPE' => $a->toolType, ':NAME' => $a->name, ':WEIGHT' => $a->weight));
?>