Divide 24 hours into 3 shifts schedule with MySQL date_format function

Submitted by ronard on Thursday, December 5, 2013 - 10:33.

Language

I'm currently developing an application for shifting schedule in our team and I would like to share with you guys on how to divide 24 hours into 3 shifts. The following schedules are: First shift: 7-15 (7am-3pm) Second shift: 15-23 (3pm-11pm) Third shift: 23-7 (11pm-7am) I used date_format function in MySQL and call the current system time, and I also declare variable for each shifts in and out shown below:


$first_shift_time_in = 7;
$first_shift_time_out = 14;
$second_shift_time_in = 15;
$second_shift_time_out = 22;
$third_shift_time_in_a = 23;
$third_shift_time_in_b = 0;
$third_shift_time_in_b = 1;
$third_shift_time_out_b = 6;

Then I used for loop function to iterate the shifts time. Just copy the script below and name it "shiftTimeSched.php" and run to your browser.

<?php
        require ("connection.php");     
        $query = mysql_query("select date_format(now(), '%H') as time") or die (mysql_error());
        while ($row = mysql_fetch_array($query)) {
                $time = $row[time];
        }
        //echo "<br>";
        $first_shift_time_in = 7;
        $first_shift_time_out = 14;
        $second_shift_time_in = 15;
        $second_shift_time_out = 22;
        $third_shift_time_in_a = 23;
        $third_shift_time_in_b = 0;
        $third_shift_time_in_b = 1;
        $third_shift_time_out_b = 6;
        
        for($i = $first_shift_time_in; $i <= $first_shift_time_out; $i++) {
                if($time == $i) {
                        $shift = "First Shift";
                }
        }
        for($ii = $second_shift_time_in; $ii <= $second_shift_time_out; $ii++) {
                if($time == $ii) {
                        $shift = "Second Shift";
                }
        }
//      echo "<br>";
        for($iii = $third_shift_time_in_b; $iii <= $third_shift_time_out_b; $iii++) {
                if($time == $iii) {
                        $shift = "Third Shift";
                }
        }
        if($time == 23) {
                $shift = "Third Shift";
        } 
        if($time == 0) {
                $shift = "Third Shift";
        }
echo "You are: ". $shift;       
?>

Hope this will help you guys, please leave your comment below. Happy codings:)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

1678 views