I'm having some problems with PDO. Here's my code:

$db = new PDO('sqlite:main.db');
$db->exec("insert into stuff (name) values ('asfasdf');");

I don't get any errors, but the value isn't being inserted into the database. What am I doing wrong?

Try:

$query = $db->exec("insert into stuff (name) values ('asfasdf');");

Then echo'ing $query should give you an error

Tried it, didn't work. :(

$db->exec("insert into stuff (name) values ('asfasdf')") or die($db->errorInfo());

When I run it, it says "Array"

To dump the contents of the array, try using this instead:


die(var_dump($db->errorInfo()));


Hope that helps,