Stirring with date and time in PHP

Question

Stirring with date and time in PHP

Navigation

#1 by (0 votes)

0

I have a question. I would like to know how I can get the php code to store the time I recorded an activity, but it should be hidden in the form and only visible when this data is visible in a table.

?>
<?php require "templates/header.php"; ?>

  <?php if (isset($_POST['submit']) && $statement) : ?>
    <blockquote> Registrado com sucesso! </blockquote>
  <?php endif; ?>

  <h2>Registrar Atividade</h2>

  <form method="post">
    <input name="csrf" type="hidden" value="<?php echo escape($_SESSION['csrf']); ?>">
    <label for="nome_atividade">Nome da Atividade: </label>
    <input type="text" name="nome_atividade" id="nome_atividade">
    <label for="duracao">Duração: </label>
    <input type="text" name="duracao" id="duracao">
    <label for="descricao">Descrição: </label>
    <textarea rows="4" cols="50" name="descricao" id="descricao"></textarea> <br>
    <input type="submit" name="submit" class="btn" value="Registrar">
  </form>
  
  <a href="registro_de_atividades.php">Voltar</a> <br>
  <a href="index.php">Voltar para o meu perfil</a> <br>

<?php require "templates/footer.php"; ?>

php mysql html

asked by anonymous 09.11.2018 / 19:52

1 answer

Help with UPDATE in logic using queries SQL: Make comparison between 2 columns and return only 1

score 0 · Accepted Answer

Just in your activity_log.php file, to which you submit form data, you create a variable that receives a date function, picking up the current date and time. Here's an example:

// aqui crio a variável $data e atribuo a função do php date(), passando a formatação de data desejada (no caso, no padrão de data do banco de dados)
$data = date('Y-m-d H:i:s');
// ... no seu SQL de registro passe a variável como valor do campo de data de registro

Follow the documentation for the date function: link