title: How to capture time for several times with one QR code (PHP)
body: <p>Currently I'm having a problem with capturing time using QR code.
  The QR stores the information of booking number and its ID.
  There are T1, T2, and T3 which denote as T1 for the first time capture, T2 for the second while T3 for the third time to capture the time.
  So basically, the user would scan three times with the same qr code.
  For now, I only able to capture the T1 but not for the other two.
  So the columns in database should be "id, bookingNumber, T1, T2, T3".
  Is there any way to solve this problem?</p>
  
  <pre><code>&lt;?php
  include 'db.php';
  $db = new Db(); 
  $action = $_REQUEST["action"];
  
      switch($action){
      case "insert_info":
          $id = $_REQUEST["id"];
          $bookingNumber = $_REQUEST["bookingNumber"];
          $query = "INSERT INTO record (id, bookingNumber, T1) VALUES ('$id', '$bookingNumber', NOW())";
          $result = $db-&gt;query($query);
  
      echo json_encode(array(
          "message" =&gt; "Successfully scanned.",
          "result" =&gt; $result
         ));
      break;
      }
  ?&gt;
  </code></pre>