1#@!#!123s

��JFIF�� 1#@!#!123s

: / var / www / hrm.addobyte.com /

Filename : timesheet_cron.php

back

<?php

$server = 'localhost';
$username = 'root';
$password = '';
$database = 'addobyte_timesheet';

$conn = new mysqli($server,$username,$password,$database);

$date = date("Y-m-d");

$sql = "select * from users where status = 0 and user_group = 0 and uid not in(SELECT uid FROM timesheets where date = '$date' and status = 0)";

$result = $conn->query($sql);

if($result->num_rows()){
	
	$message = "Hi,<br><br>";
	$message .= "You didn't update your Timesheet for the date ".date('d-m-Y')."<br><br>";;
	$message .= "Please update it ASAP<br><br>";
	$message .= "Thanks";
	
	while($row = $result->fetch_assoc()){		
		
		$email = $row['email'];
		
	}
	
}