Insert date format in database using php

Question

I have a question for you I try but not received...I need to insert date into database: My script:

 <script>
 $(document).ready(function() {
     $("#datepicker").datepicker({
         format: 'yyyy-mm-dd'
     });
 })

My html:

<div class="form-group">
     <label>Date:</label>
     <input class="form-control marg-left-10" name="date" id="datepicker">
</div>

My php:

$date = date('Y-m-d H:i:s', strtotime($this->input->post['date']));

data is inserted into database : 1962-12-31. Please help me.

Rakesh Sharma · Accepted Answer · 2014-08-25 13:24:28Z

2

Try to replace

$this->input->post['date']

to

$this->input->post('date')

answered Aug 25, 2014 at 13:24

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pomaxa · Accepted Answer · 2014-08-25 13:26:44Z

1

$date = DateTime::createFromFormat("Y-m-d", $this->input->post('date'));
$stringDate = $date->format("Y-m-d H:i:s");

answered Aug 25, 2014 at 13:26

pomaxa

1,74616 silver badges26 bronze badges