<html>
<head>
</head>
<body>
<h2>SQLite Create Table</h2>

<!--PHP code--------------------------------------->
<?php


$db    = new SQLite3('/home/sultans/data/sqlite/sqlite.db');
$table = 'cars';

$db->exec("DROP table if exists $table");

$db->exec("
    CREATE TABLE $table
    (
        id    INTEGER PRIMARY KEY, 
        name  TEXT, 
        price INT
    )
");

print "<h3>table '$table' created</h3>";
?>
<!------------------------------------------------>
</body>
</html>