how to compare the two fields in php with different table in mysql?

by

Assuming that you have a time_in column in the table time_in

if($stmt = $dbconnect->prepare("SELECT time_in from time_in")){
$stmt->bind_param("s", $time_in); 
$stmt->execute(); 
$cur_time = time();
if($time_in === $cur_time){
echo "Teacher is on time";
}
}

This is mainly an idea about how things should be going. There’s always room for improvement. To be precise, you should give a teacher_id in the time_in table so that the respective teacher’s time is selected only.

EDIT:

 if($stmt = $dbconnect->prepare("SELECT time_in from time_in")){
   $stmt->bind_param("s", $time_in); 
   $stmt->execute(); 
 if($stmtt = $dbconnect->prepare("SELECT time from profschedule")){
  $stmtt->bind_param("s", $time); 
  $stmt->execute(); 
 if($time_in === $time)
  echo "Teacher is on time";
}}}

Although, this is poorly written but the whole point of it is to give you the IDEA about how to approach after inspecting your perspective in the comments.

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. Php foreach give 2 users random value
  3. The requested URL was not found on this server.
  4. How to write a stored procedure using phpmyadmin and how to use it through php?
  5. phpmyadmin – count(): Parameter must be an array or an object that implements Countable
  6. Import file size limit in PHPMyAdmin
  7. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  8. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  9. Mysql event error using php
  10. Call to undefined function __() error – phpMyAdmin
  11. Auto increment in phpmyadmin
  12. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  13. Store procedures in phpMyAdmin
  14. How to connect sql server with php using xampp?
  15. How to solve time out in phpmyadmin?
  16. WAMP/MySQL errors not in correct language
  17. phpmyadmin automatic logout time
  18. WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
  19. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Extension mysqli is missing, phpmyadmin doesn’t work
  22. mysqli_real_connect(): (HY000/2002): No such file or directory
  23. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  24. How to SELECT DEFAULT value of a field
  25. How to log in to phpMyAdmin with WAMP, what is the username and password?
  26. Auto Increment skipping numbers?
  27. save html-formatted text to database
  28. How to write a stored procedure in phpMyAdmin?
  29. Installing PDO driver on MySQL Linux server
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment