从html表单中提取日期和时间以在mysql查询中使用它们

Question

User must chose between two dates and a query will return the number of answers that are given by employees

<form action="mojaTvrtka.php" method="POST">

    <input datetime="<?php echo date('Y-m-d H:i:s'); ?>"   name="vrijeme" value="<?php echo date('Y-m-d H:i:s'); ?>">
    <input datetime="<?php echo date('Y-m-d H:i:s'); ?>"    name="vrijeme1" value="<?php echo date('Y-m-d H:i:s'); ?>">
    <input type='submit' name='postavi' value="Zatraži rz!">
</form>
<?php
if(isset($_POST['vrijeme']))
{
    $postavljeno = $_POST['vrijeme'];
}
if(isset($_POST['vrijeme1']))
{
    $postavljeno1 = $_POST['vrijeme1'];
    var_dump($postavljeno1);    
}

if(isset($_POST['postavi']))
    {
        $connect=connectDB();
        $statsQuery ="
SELECT ime
     , prezime
     , COUNT(*) AS broj_odgovora 
  FROM korisnik k
     , zaposlenik z
     , odgovor o
 WHERE k.korisnik_id = z.korisnik_id 
   AND z.zaposlenik_id = o.zaposlenik_id
   AND z.tvrtka_id = '{$_SESSION['tvrtkaId']}' 
   AND o.datum_vrijeme_odgovora BETWEEN '{$postavljeno}' AND '{$postavljeno1}' 
 GROUP 
    BY korisnicko_ime
";

            $statsResult = queryDB($connect,$statsQuery);

            if(mysqli_num_rows($statsResult) > 0)
            {

        echo "<h2> Popis odgovora </h2>";
        echo "<table border ='1'>";
        echo "<thead>";
        echo "<tr>";
        echo "<th>Ime i prezime </th>";
        echo "<th>Odgovori </th>";
        echo "</tr>";
        echo "</thead>";
        echo "<tbody>";

                   while(list($ime,$prezime,$broj_odgovora)=mysqli_fetch_row($statsResult))
                {
                    echo "<tr>";
                    echo "<td>".$ime." ".$prezime."</a></td>";
                    echo "<td>".$broj_odgovora."</td>";
                    echo "</tr>";
                }
                echo "</tbody>";
                echo "</table>";


                }
                else 
                {
                    echo"Nema rezultata za traženo razdoblje!";
                }
        }
    disconnectDB($connect);
?>

Date and time input must be "2019-11-01 00:00:00" and thats mysql datetime value. Above code works without any errors and when I var_dump($postavljeno1) the correct format is applaied but nothing happens.

Answer 1

You can use something like this:

$date = date('Y-m-d',strtotime($inputdate))." 00:00:00";