title: How do I insert into SQLite with PDO extension?
body: <p>I'm having a bit of trouble inserting into a sqlite3 database with pdo. You'll have to excuse my ignorance with PDO, it seems so foreign coming from Python's database interface.</p>
  
  <p>So here's my problem. I have a simple insert:</p>
  
  <pre><code>$dbh = new PDO('sqlite:vets.db');
      $count = $dbh-&gt;exec("INSERT INTO vets(name,email,clinic,streetname,citystatezip,link,phone,fax,animal,region,visible) VALUES ($name,$email,$clinic,$streetname,$citystatezip,$link,$phone,$fax,$animal,$region,$visible)");
      $dbh = null;
  </code></pre>
  
  <p>I simply want to execute that SQL command on my database and be done with it. Though executing this script causes no errors, it never updates the database. I've tried all sorts of permissions on the database itself, even made it 777 but it doesn't make a difference. </p>
  
  <p>Could someone help me? </p>