php - CodeIgniter Date or DateTime -


i have 1 problem, can not resolve , have no idea mistake 1 create tabel called posts , in codeigniter create form posts, after createing post want display posts in index.php , have table called date of departure, , date of return. 1 create post date looking when display in index.php it's 0000-00-00 00:00:00 in begginig data type date, change datetime nothing happend, same problem maybe make mistake in js script comment ?

my script

<script>   $( function() {     $( "#datepicker" ).datepicker();     $( "#datepicker1" ).datepicker();   } );   </script> 

when field in mysql date-time aspects proper format before saving in database.

so convert string date time format in php using.

date("y-m-d h:i:s", strtotime($string));  

or can same in datepicker

$(function() {     $('#datepicker').datepicker({         dateformat: 'yy-dd-mm',         onselect: function(datetext){             var d = new date(); //             var h = d.gethours();                 h = (h < 10) ? ("0" + h) : h ;                  var m = d.getminutes();             m = (m < 10) ? ("0" + m) : m ;              var s = d.getseconds();             s = (s < 10) ? ("0" + s) : s ;                  datetext = datetext + " " + h + ":" + m + ":" + s;             $('#datepicker').val(datetext);         },     }); }); 

fiddle datepicker

note if want date in mysql field omit hour min sec part of conversion


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -