CodeIgniter日期或DateTime [英] CodeIgniter Date or DateTime
问题描述
我有一个问题,我无法解决,也不知道哪里出错
一个我创建了一个称为posts的表格,并在codeigniter中创建了一个Forms Posts,在创建了所有我想在索引中显示帖子的帖子之后.php和我有一个名为
的表格出发日期和返回日期。我创建一个看起来不错的发布日期,但是当我在index.php中显示它时,看起来就像0000-00-00 00:00:00
在begginig数据类型中,日期是Date,现在我更改为DateTime,但是什么也没发生,相同的问题
也许我在JS脚本中犯了错误
任何评论吗?
我的脚本
<脚本>
$(function(){
$( #datepicker).datepicker();
$(#datepicker1).datepicker();
});
< / script>
当您在MySQL中的字段为Date-time时保存在数据库中之前的正确格式。
因此使用php将字符串转换为日期时间格式。
date( Ymd H:i:s,strtotime($ string));
或者您也可以在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);
},
});
} );
请注意,如果您只希望在MySQL字段中输入日期,则可以忽略转换的时间(分钟) p>
I have one problem, which I can not resolve and have no idea where is mistake One I create a tabel called posts and in codeigniter create a form Posts, after createing all post I want to display posts in index.php and I have table called Date of departure, and date of return. One i create post date looking good but when I display in my index.php it's look like 0000-00-00 00:00:00 In begginig data type was Date, now i change to be DateTime but nothing happend, same problem Maybe I make mistake in my JS script Any comment ?
My script
<script>
$( function() {
$( "#datepicker" ).datepicker();
$( "#datepicker1" ).datepicker();
} );
</script>
When your field in MySQL is Date-time it aspects proper format before saving in database.
So convert string to date time format in php using.
date("Y-m-d H:i:s", strtotime($string));
Or you can do the same in Datepicker
$(function() {
$('#datepicker').datepicker({
dateFormat: 'yy-dd-mm',
onSelect: function(datetext){
var d = new Date(); // for now
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 for datepicker
Note if you want date only in MySQL field the omit hour min sec part of conversion
这篇关于CodeIgniter日期或DateTime的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!