title: How to insert current date in database mysql
body: <p>hello i am using insert query with a different pattern so i just want to 
  insert the current date in database but i can't find a place to put $date in insert query</p>
  
  <pre><code>$date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $date)));    
  
  $sql="INSERT INTO `delivery`(product_id,pr_name,pr_price,pr_size,user_id)
           SELECT  `product_id`,`pr_name`,`pr_price`,`pr_size`, `userid`  
           FROM `shopping_cart` WHERE `userid` = $uid";
  </code></pre>