title: inserting ampersand (&) in mysql with PDO php?
body: <p>I'm using PDO to insert values into mysql</p>
  
  <p>I'm doing something like this </p>
  
  <pre><code>$sql = $db-&gt;prepare("INSERT INTO table(value) VALUES(?)");
  $sql -&gt; execute(array($value));
  </code></pre>
  
  <p>I noticed that if I type in the text <code>&amp;</code> in my input field, it gets removed into inserting mysql. I guess this is good because it shows that mysql injection is protected? Well what if I would like to have just this value as a text such as : <code>beer &amp; wine</code></p>
  
  <p>Any suggestions on what to do?</p>