title: PDO identify missing bound variables
body: <p>One of the more tedious to work with PDO is that it says that some variables are missing</p>
  
  <blockquote>
    <p>PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens</p>
  </blockquote>
  
  <p>... but does not tell which ones. Is there any solution to identify them? Eg</p>
  
  <pre><code>$sql = "SELECT id, name WHERE id = :id AND name like  :search_tem";
  
  $stmt = $pdo-&gt;prepare($sql);
  $stmt-&gt;bindValue(':id', '1');
  $stmt-&gt;execute(); // throws exception - "**search_term missing"
  </code></pre>
  
  <p>It's so obvious everyone needs something like this. But I can't a simple solution.</p>