title: How to insert the record with MySQL NOW() function in MySQLi with bind_param?
body: <p>I need to execute this mysql query in MySQLi PDO with bind parametr in PHP:</p>
  
  <pre><code>mysql_query("INSERT INTO `posts` (post_name,publish_date) VALUES ($post_name,NOW()) ")
  </code></pre>
  
  <p>I use the script like this, but it doesn't insert publish_date correctly. </p>
  
  <pre><code>$publish_date = 'NOW()';
  $insert = $mysqli-&gt;prepare("INSERT INTO posts (post_name,publish_date) VALUES (?,?)");
  $insert-&gt;bind_param("ss", $post_name $publish_date);
  $insert-&gt;execute();
  </code></pre>
  
  <p>It inserts the record into the <code>publish_date</code> column like this: <code>0000-00-00 00:00:00</code><br/><br/>
  How can I do this ? Thanks in advance.</p>
  
  <p>P.S: The type of date column is <code>datatime</code>.</p>