dongpei3245 2016-07-24 05:56
浏览 47
已采纳

javascript php将时间戳添加到多个单元格

I am new to php and javascript so please excuse my ignorance. I am trying to create a javascript to insert a timestamp to multiple cells. I did have a button to insert or update the mysql database to input the timestamp now(), but thats not the route I'm looking for. If someone has a better idea please let me know. Basically I would like to click on a button to insert time into the <td><center><input id="field" type="text" name="time[]" size="11"></center></td>. 

<?php
include 'config.php';
?>
<html>
<head>
<script>

function getTimeStamp(id) {
    var now = new Date();
       return (now.getHours() + ':' + ((now.getMinutes() < 10) ? ("0" + now.getMinutes()) : (now.getMinutes())));
}

function setTime() {
    document.getElementById('field').value = getTimeStamp();

</script>
</head>
<body >
<div>

<button type="button" onclick="setTime();">TimeStamp</button>
<table >

 <tr >
  <td >id</td>
  <td >First Name</td>
  <td >Last Name</td>
  <td >Location</td>
  <td >Remarks</td>
  <td >Timestamp</td>
  
 </tr>

<?php
while ($row = mysqli_fetch_array($sql)){
    print '<tr>
        <td><input type="hidden" name="id[]" value="'. $row[0] .'">' .$row[0]. '</td>
        <td><input type="hidden" name="first[]" value="'. $row[1] .'">' .$row[1]. '</td>
        <td><input type="hidden" name="last[]" value="'. $row[2] .'">' .$row[2]. '</td>
        <td><input  name="location[]" value="'. $row[3] .'">' .$row[3]. '</td>
        <td><center><input type="text" name="remarks[]" size="43"></center></td>
        <td><center><input id="field" type="text" name="time[]" size="11"></center></td>
    </tr>';
}
?>
</table>
</div>
</body>
</html>

</div>
  • 写回答

2条回答 默认 最新

  • dousao8152 2016-07-24 06:17
    关注

    If I understood correctly you want to set the timestamp in all of the input fields time[] by clicking a button?

    I couldn't fully test the function because your getTimestamp function calls other functions not defined here but it should work...

    function setTime() {
    var col=document.querySelectorAll('input[type="text"][name="time[]"]');
    if(col){
        for( var n in col ) if(col[n].nodeType==1) col[n].value=getTimeStamp();
    }
}

    Based upon your comment

    If you wish to set the timestamp uniquely to each text input based upon clicking into the field then the function and assignments needs to be a little different. As you would no longer need the button with attached setTime function you could instead use something like this and remove the button and delete the setTime function...

    function bindTimeEvents(){
    var col=document.querySelectorAll('input[type="text"][name="time[]"]');
    if( col ){
        for( var n in col )if( col[ n ].nodeType ==1 ){
            col[n].addEventListener('click',function(e){
                this.value=getTimeStamp();
            }.bind( col[n] ),false);
        }
    }
}
document.addEventListener('DOMContentLoaded',bindTimeEvents,false);
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 宇视监控服务器无法登录
  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
  • ¥50 STM32单片机传感器读取错误
  • ¥50 power BI 从Mysql服务器导入数据，但连接进去后显示表无数据
  • ¥15 (关键词-阻抗匹配，HFSS，RFID标签天线)