dpik71879 2016-01-09 12:43
浏览 68
已采纳

我如何将datetime转换为unix时间戳并将其与php中的其他时间戳进行比较?

I have one page in that I have two textboxes where user will enter unix timestamp and datetime, I have to compare that both timestamp and datetime but in php the timezone giving different timestamp as per time zone so the code doesn't working in all places where time zones are different.

Please help on this I had used..

strtotime(),mktime(),getTimestamp() 
in php,

also used my sql for this..

SELECT UNIX_TIMESTAMP()
but all are giving different time stamps.
$sql = "SELECT UNIX_TIMESTAMP('date time from text box') as timeStampfromdb";
            $result = mysql_query($sql);
            while($row = mysql_fetch_array($result))
            {
                $timeStampFromDateTime = $row["timeStampfromdb"];
            }           
            if($timeStampFromDateTime == timestamp textbox value)
            {
                matched
            }
            else
            {
                not matched
            }
  • 写回答

2条回答 默认 最新

  • doupuzhimuhan9216 2016-01-09 12:52
    关注

    You can set php timezone in php.ini file, for GMT you need "GMT".

    You can also try in your code:

    echo date('Y-m-d H:i:s T', time()) . "<br>
    ";
    date_default_timezone_set('GMT');
    echo date('Y-m-d H:i:s T', time()) . "<br>
    ";
    

    time() should return the current unix timestamp.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 VB.NET2022如何生成发布成exe文件
  • ¥30 matlab appdesigner私有函数嵌套整合
  • ¥15 给我一个openharmony跑通webrtc实现视频会议的简单demo项目,sdk为12
  • ¥15 vb6.0使用jmail接收smtp邮件并另存附件到D盘
  • ¥30 vb net 使用 sendMessage 如何输入鼠标坐标
  • ¥15 关于freesurfer使用freeview可视化的问题
  • ¥100 谁能在荣耀自带系统MagicOS版本下,隐藏手机桌面图标?
  • ¥15 求SC-LIWC词典!
  • ¥20 有关esp8266连接阿里云
  • ¥15 C# 调用Bartender打印机打印