PHP Show the time you clicked the button and by whom it was clicked

Question

Next, I’m creating a page of employees that will work in the "punch card" scheme. That is, whenever the employee arrives, he will click the button inside the system and the intention was to show the time that was clicked and stay there. Then, when he left, he would "hit card" again and show the time. At the end of the day, this would be "zeroed" (i.e., the button appeared again) and the time, date and these things would go into the employee’s history. However, I don’t have much idea how to do this, since my knowledge of programming is not so advanced.

I do not know how to make appear the cute date in the table next. I tried to make an if, includes an isset. Anyway, I tried several methods but I have no idea how to do it. I’m open to suggestions, opinions. I really need to do this!

Thank you!

<?php

include './abreConexao.php';

$sqlFunc = "Select * from FUNCIONARIOS";
$rsFunc = mysql_query($sqlFunc) or die (mysql_error());

?>

<table border="1">
    <?php
while($tblFunc = mysql_fetch_array($rsFunc)){

?>

    <tr>

        <td>

            <?=$tblFunc['nome_FUNCIONARIO']?> 

        </td>



        <td align="center">


            <form action="Funcionarios.php" method="POST">
            <input type="submit" value="" name="horaEntrada">
            </form>

        </td>

        <td align="center">

            <input type="submit" value="" name="horaSaida">

        </td>

    </tr>

<?php 


    } ?>


    </table>

WHAT I TRIED TO DO WAS:

    <?php 

    $horaEntrada = $_POST['horaEntrada'];


if(isset($_POST['horaEntrada'])){

    $horaEntrada = 1;

}else{

    $horaEntrada = 0;

}

if($horaEntrada == 1){

    date_default_timezone_set('America/Sao_Paulo');
$date = date('Y-m-d H:i');
echo $date;

}

Answer 1

Pretty quiet, assuming you know the code, which is simple, I’ll just give you the logic.

1- Make a small form, where the employee enters with the registration ($license plate) and gives Submit through the button. 2- On another page you receive $registration by POST and keep it in the bank as well as the exact moment the bank updated.

Small example of processing:

<?php
include("db.php");
$matricula    = $_POST['matricula'];
$fuso         = mktime(date("H")-3, date("i"), 0);
$hora_ponto   = gmdate("Y-m-d H:i", $fuso);

$ponto = $conexao->exec("INSERT INTO `funcionarios` ( `matricula` , `hora_ponto`) VALUES ('$matricula', '$hora_ponto')");
$ultimaid = $conexao->lastInsertId();
echo '<center>Registro: '.$hora_ponto;}
header("location: suapagina.php");
?>

At the end of the month you can easily print out a report of all records entered by license x.

I believe that with this you can make any Tweak necessary to adapt to your need.