Query to get number of entries made on a particular date

Asked Jan 08 '20 at 10:02

Active Jan 08 '20 at 13:06

Viewed 41 times

I've been working on an RFID attendance system and at the end, I'm stuck with a small problem.

The problem is that I want to display the number of students that made an entry on a particular date. This would help in getting the students that attended the class and students that were absent.

My html code is:

                <form action="dateview.php" method="post">
           <table width="60%" border="2" bordercolor="green">
              <tr>
              <td>DATE</td>
            <td>
            <input type="date" name="date">
                    </td>
            <td colspan="2"><center><input type="submit" value="search"/></center></td>
            </table>    
            </form>

My dateview.php code is :

<?php 
  require_once 'connect.php';
$time = strtotime($_POST['date']);
if ($time) {
  $new_date = date('Y-m-d', $time);
  echo $new_date;
  $sql1 = "SELECT COUNT(*) AS date FROM time WHERE date = '".$new_date."'";
  $result = $conn->query($sql1);
  print_r($result);
} else {
  // fix it.
}

?>

And my sql table (time) is as displayed: SQL TABLE TIME

edited Jan 08 '20 at 13:06

Anas Mansuri

asked Jan 08 '20 at 10:02

Pikaaa Chuuu

1

Can you explaine which is you problem? Second please use stm for prepare query (SQL Inject vulnerability) – Simone Rossaini Jan 08 '20 at 10:31
You can't print `mysqli_result` object and expect meaningful results. – Dharman Jan 08 '20 at 11:04
Why is date and time separate in your database? This is a recipe for disaster. – Dharman Jan 08 '20 at 11:05
Why is your database not normalized? – Dharman Jan 08 '20 at 11:06
Im still in the learning phase. This is my second project actually. – Pikaaa Chuuu Jan 08 '20 at 11:12
1

If i cant print mysqli_result then what can i use to count the number of entries made on a perticular date? – Pikaaa Chuuu Jan 08 '20 at 11:12
@PikaaaChuuu you what to get no.of student present on particular date, this what your trying am i right? – sanoj lawrence Jan 08 '20 at 13:35
@PikaaaChuuu what is you `date` format in `DB` – sanoj lawrence Jan 08 '20 at 16:02

Query to get number of entries made on a particular date

0 Answers0