doqw89029 2015-05-27 22:20
浏览 68
已采纳

如何格式化PHP的Bootstrap DatePicker

I am using this Bootstrap DatePicker: code below

<input class="datepicker" name="date">

<script> //date picker js
  $(document).ready(function() {  
      $('.datepicker').datepicker({
         todayHighlight: true,
         "autoclose": true,
      });
  });   
</script>

and I capture that in my PHP here:

$date = $_POST['date'];

The problem is that the DatePicker gives me the format dd/mm/yyyy when I need it yyyy-mm-dd in my $date variable. How do I reformat this?

  • 写回答

4条回答 默认 最新

  • douzangdang2225 2015-05-28 14:51
    关注

    ****** SOLUTION ******

    To solve this issue I saw that the variable 'date' was formatted dd/mm/yyyy and was a string. I was able to parse it and rebuild as a date in the proper format.

    list($m,$d,$y) = explode("/",$_POST['date']);
    $timestamp = mktime(0,0,0,$m,$d,$y);
    $date = date("Y-m-d",$timestamp);
    

    *Note - I also had to surround the $date variable in single quotes in the query:

    $sql = "INSERT INTO tableName (..., date, ...)
            VALUES (..., '".$date."', ...)";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥33 集成BiLSTM模型和GCN模型时,前模型的输出不匹配后模型的输入
  • ¥15 关于液体厚度提取,和铺展轨迹数据化处理
  • ¥20 对方微信是wxid如何添加成好友?或者转换成微信号?
  • ¥15 yolov5实验数据好,但是自己拍摄的照片检测结果差
  • ¥15 做过dali2.0认证的技术,
  • ¥15 一道python难题
  • ¥15 matlab 免疫算法
  • ¥50 可视化界面构建,实现信息模块功能
  • ¥15 基于bert-base-chinese的中文文本处理
  • ¥15 高价求抖音抓包技术,抖音抓包无网络问题