query('PRAGMA table_info(product)');
if ($q->numRows() == 0) {
$db->query('create table product(
id integer primary key,
title varchar(255),
subtitle varchar(255),
url varchar(255),
sku varchar(32))');
}
return $db;
}
$db = open_db();
$id = $_GET['id'];
if ($id == '') {
$id = -1;
// Lookup SKU
if ($_GET['sku'] != '') {
$q = $db->query("select id from product where sku='".$_GET['sku']."'");
if ($q->numRows() != 0) {
$id = $q->column('id');
}
}
}
if ($id != -1) {
$q = $db->query('select title,subtitle,url,sku from product where id='.$id);
if ($q->numRows() != 0) {
$title = $q->column('title');
$subtitle = $q->column('subtitle');
$url = $q->column('url');
$sku = $q->column('sku');
}
}
?>
LabelMaker
Name lookup
SKU lookup
Label contents