I'm trying to learn PHP and sqlite from a tutorial which has the following code:
<?php
$sqlite = new SQLiteDatabase('music.db') or die ("Could not open database");
$sql = "SELECT artist_id, artist_name FROM artists";
if ($result = $sqlite->query($sql)) {
if ($result->numRows() > 0) {
while($row = $result->fetch()) {
echo $row[0] . ":" . $row[1] . "\n";
}
} else {
echo "No records matching your query were found.";
}
} else {
echo "ERROR: Could not execute $sql. " . sqlite_error_string($sqlite->lastError());
}
unset($sqlite);
?>
But I get this error:
I'm not able to figure out where the error is. The database exists, but the contents can't be interpreted for some reason. When I query the DB from sqlite itself, I don't have any problem though. Could it be there's a version conflict? I'm using sqlite3, while the tutor is meant to be for sqlite2x.
I hope someone can hep me with this.
Thanks,
Bart