ajax php jquery realtime saving of counter

Question

Currently the script.php works perfectly but what I want to happen, is instead of displaying the hours, minutes and seconds I want to have the 3 values combined and POSTED to log.php as $_POST['timeSpent'] as well as the value $id sent as $_POST['id'] every 1 second.

script.php

<p><span id="hours"></span>:<span id="minutes"></span>:<span id="seconds"></span></p>
<script>
  var sec = -1;
  function pad(val) { return val > 9 ? val : "0" + val; }
  setInterval(function () {
    $("#seconds").html(pad(++sec % 60));
    $("#minutes").html(pad(parseInt(sec / 60, 10) % 60));
    $("#hours").html(pad(parseInt(sec / 3600, 10)));
  }, 1000);
</script>

log.php

<?php
    include 'includes/config.php';

    $loggeduser = $_SESSION['username'];
    $stmt = "UPDATE rotator_tracking SET time_spent=:time_spent WHERE id=:id";
    $stmt = $db->prepare($stmt);
    $stmt ->execute(array(
        ":time_spent" => $_POST['timeSpent'],
        ":id" => $_POST['id']
    ));
?>

I know the variables need to be handed to ajax which hands them to the log.php but in this instance, I have no idea how to do that nor how to save it every 1 second.

Help? Perhaps example code.

Nicolas Racine · Accepted Answer · 2016-07-18 19:44:01Z

2

in your setInterval loop just add

$.post(
  'log.php',
  {
    timeSpent:theTimeCombinedVariable,
    id:IdVariable
  }
).done(function() {
  alert('done');
});

I did not test the code. but this is pretty much it.

edited Jul 18, 2016 at 19:44

answered Jul 15, 2016 at 19:11

Nicolas Racine

1,0613 gold badges14 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ajax php jquery realtime saving of counter

script.php

log.php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

script.php

log.php

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related