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
Post a Comment