title: PHP PDO Insert query with prepared statements
body: <p>I am trying to run an sql query using PDO prepared statements</p>
  
  <pre><code>$sql = "INSERT INTO tickets (ticketnumber, status) VALUES (1234, Open) ";
  $stmt = $connection-&gt;prepare($sql);
  $stmt-&gt;execute();
  </code></pre>
  
  <p>But it is just not inserting. What have I done wrong?</p>
  
  <p>Here is my connection:</p>
  
  <pre><code>$host = "localhost";
  $db_name = "";
  $username = "";
  $password = "";
  $connection = new PDO("mysql:host={$host};dbname={$db_name}", $username, $password);
  </code></pre>