query('SELECT * FROM points');
if ($q === false) {
$db->queryExec('CREATE TABLE points (id INTEGER PRIMARY KEY, name VARCHAR(255), x INT, y INT);');
$centrex = round(-0.1279688 * 10000000);
$centrey = round(51.5077286 * 10000000);
$xrange = 500000;
$yrange = 350000;
$xincrement = 15000;
$yincrement = 10000;
$count = 0;
for ($x = $centrex-$xrange; $x<$centrex+$xrange; $x+=$xincrement) {
for ($y = $centrey-$yrange; $y<$centrey+$yrange; $y+=$yincrement) {
$count ++;
$db->queryExec("INSERT INTO points (name,x,y) VALUES (\"point number $count\", $x , $y )");
}
print "added " .$count."
";
flush();
}
print "DB initialised";
} else {
print "DB (file) already exists
";
print "This script need only be run once to create the database.";
print "Delete the db file to run it again.";
}
} else {
die($err);
}
?>