phpwpg/sqlite.php at master · inec/phpwpg · GitHub

35 lines (31 loc) · 1.06 KB

<?php

try

{

//open the database

$db = new PDO('sqlite:dogsDb_PDO.sqlite');

//create the database

$db->exec("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY, Breed TEXT, Name TEXT, Age INTEGER)");

//insert some data...

$db->exec("INSERT INTO Dogs (Breed, Name, Age) VALUES ('Labrador', 'Tank', 2);".

"INSERT INTO Dogs (Breed, Name, Age) VALUES ('Husky', 'Glacier', 7); " .

"INSERT INTO Dogs (Breed, Name, Age) VALUES ('Golden-Doodle', 'Ellie', 4);");

//now output the data to a simple html table...

print "<table border=1>";

print "<tr><td>Id</td><td>Breed</td><td>Name</td><td>Age</td></tr>";

$result = $db->query('SELECT * FROM Dogs');

foreach($result as $row)

{

print "<tr><td>".$row['Id']."</td>";

print "<td>".$row['Breed']."</td>";

print "<td>".$row['Name']."</td>";

print "<td>".$row['Age']."</td></tr>";

}

print "</table>";

// close the database connection

$db = NULL;

}

catch(PDOException $e)

{

print 'Exception : '.$e->getMessage();

}

Expand file tree