PHP PDO help...

[klarth]

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. Selects work though, but deletes and inserts don't. What am I doing wrong?

 

[Kate]

Can you echo the statement and execute it on phpmyadmin for example ?
Also, 'name' may be a reserved keyword so you may want to rename that field or use backticks around it, like this:

insert into stuff (`name`) values ('asfasdf');

 

[sutuicom]

chmod +0777 main.db

 

[klarth]

Tried both, didn't work.