<?php
try
{
//open the database
$db = new PDO('sqlite:music.db');
$db->exec("DELETE from Music;");
$db->exec("INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Whatd I Say', 'Ray Charles', '1956');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Smells Like Teen Spirit.', 'Nirvana', '1991');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Hey Jude', 'The Beatles', '1968');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Johnny B. Goode', 'Chuck
Berry', '1958');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Good Vibrations', 'The Beach Boys', '1966');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Respect', 'Aretha Franklin', '1967');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Whats Going On', 'Marvin Gaye', '1971');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Imagine', 'John Lennon', '1971');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('(I Cant Get No) Satisfaction', 'Rolling Stones', '1965');" .
"INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Like A Rolling Stone', 'Bob Dylan', '1965');");
//now output the data to a simple html table...
//example of specifier --> WHERE First=\'Josh\'; <--
print "<table border=1>";
print "<tr><td>Title</td><td>Author</td><td>Y.O.P.</td></tr>";
$result = $db->query('SELECT * FROM Music ');
foreach($result as $row)
{
print "<td>".$row['Title']."</td>";
print "<td>".$row['Author']."</td>";
print "<td>".$row['ReleaseDate']."</td></tr>";
}
print "</table>";
$db = NULL;
}
catch(PDOException $e)
{
print 'Exception : '.$e->getMessage();
}
?>
I am not sure why nothing is being inserted into the table. The file 'music.db' exists in the right path.
For the record, I can only use SQlite3, no SQL allowed. PHP is allowed, so is SQLite3.
