title: PHP mysqli ->bindValue SQL error
body: <p>I have a SQL query:</p>
  
  <pre><code>if($stmt = $connection-&gt;prepare("INSERT INTO users(login, passwd, logged, register, last_login) VALUES(:login, :passwd, FALSE, NOW(), NULL")) {
      $stmt-&gt;bindValue(':login', $login, PDO::PARAM_STR);
      $stmt-&gt;bindValue(':passwd', md5($passwd), PDO::PARAM_STR);
      $stmt-&gt;execute();
      $stmt-&gt;close();
  } else {
      echo "query error &lt;b&gt;".$connection-&gt;error."&lt;/b&gt;&lt;br&gt;";
  }
  </code></pre>
  
  <p>and it returns this error:</p>
  
  <blockquote>
    <p>Connection error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':login, :passwd, FALSE, NOW(), NULL' at line 1</p>
  </blockquote>
  
  <p>How can I fix it?</p>
  
  <p>I am using MariaDB on Linux Fedora.</p>