php - Date column doesn't show right datestamp upon form submit to DB -

for reason or date , time in date column shows 0000-00-00 00:00:00 when submit form db. way can date right updating manually. started doing , i'm not sure changed. i'm having real hard time troubleshooting this.

edit form:

<?php if(!defined('in_admin')) exit; ?>  <div class="page">     <h1 class="edit"><?=ucfirst($mode)?> post</h1>     <span class="error-text"><?=$response_text?></span>     <form action="admin.php?mode=<?=$mode?>&id=<?=$post['post_id']?>" method="post">     <p>         <label for="title">post title:</label><br />         <input type="text" size="80" id="title" name="data[post_title]" value="<?=htmlspecialchars(stripslashes($post['post_title']))?>" />     </p>     <p>         <label for="title">upload image:</label><br />         <input type="text" size="80" id="title" name="data[image]" value="<?=htmlspecialchars(stripslashes($post['image']))?>" />     </p>         <p>         <label for="title">image alt:</label><br />         <input type="text" size="80" id="title" name="data[image_alt]" value="<?=htmlspecialchars(stripslashes($post['image_alt']))?>" />     </p>         <p>         <label for="title">post category:</label><br />         <input type="text" size="80" id="title" name="data[post_category]" value="<?=htmlspecialchars(stripslashes($post['post_category']))?>" />     </p>     <p>         <label for="content">post insert:</label><br />         <textarea cols="77" rows="10" id="insert" name="data[post_insert]"><?=htmlspecialchars(stripslashes($post['post_insert']))?></textarea><br />         <span class="form-text">brief little tid-bit article home page</span>     </p>      <p>         <label for="content">post content:</label><br />         <script>edtoolbar('mytxtarea'); </script>         <textarea cols="77" rows="10" id="mytxtarea" class="ed" name="data[post_content]"><?=htmlspecialchars(stripslashes($post['post_content']))?></textarea><br />         <span class="form-text">to format use raw html.. &lt;strong&gt;, &lt;span&gt;, etc</span>     </p>       <p>         <label for="status">post status:</label><br />         <select id="status" name="data[published]">             <?=generate_option_list(array('0' => 'unpublished', '1' => 'published'), $post['published'])?>         </select>     </p>      <p>         <input class="button" type="submit" name="miniblog_postback" value="<?=ucfirst($mode)?>" />     </p>    </div> 

that's form use, , here index.php form in:

case 'add':  if(isset($_post['miniblog_postback'])) {         $data = $_post['data'];          $data['post_slug'] = mb_slug($_post['data']['post_title']);         $data['date']      = time();          $sql ='';         $i = 1;         foreach($data $field => $value)         {             if($value == '')             {                 $failed = true;                 break;             }             $fields .= "`" . mysql_real_escape_string($field) . "`";             $values .= "'" . mysql_real_escape_string($value) . "'";              $values .= ($i == sizeof($data)) ? '' : ', ';             $fields .= ($i == sizeof($data)) ? '' : ', ';              $i++;         }          $post = $_post['data'];          if($failed)         {             $response_text = 'error: must fill out fields';         }         else         {             $result = mysql_query("insert `db` ({$fields}) values({$values})");             $response_text = ($result) ? 'post added' : 'post not added';         }  }  include('edit.php');  break; 

$data['date'] = time(); 

should be:

$data['date'] = date("y-m-d h:i:s"); 

the time() function returns current time in number of seconds since unix epoch (january 1 1970 00:00:00 gmt).

the date() function formats local date , time (by default current one), , returns formatted date string, in case, in format mysql needs it.