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条)

报告相同问题？

悬赏问题

  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目，支持注册表等
  • ¥15 matlab 用yalmip搭建模型，cplex求解，线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题：大概就是类似后台自动检测某下架商品的库存，在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
  • ¥15 神经网络怎么把隐含层变量融合到损失函数中？
  • ¥15 lingo18勾选global solver求解使用的算法
  • ¥15 全部备份安卓app数据包括密码，可以复制到另一手机上运行
  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑，cmd输入cookies跑不出来