function timecheck() { $db_server = mysqli_connect("localhost", "root", "root", "schedule"); $today = date("Y-m-d"); $currenthour = date("H"); echo $currenttime; $db_server = mysqli_connect("localhost", "root", "root", "schedule"); $cycquery = "SELECT cycleday FROM days WHERE daate = '{$today}';"; mylog($cycquery); $cycresult = mysqli_query($db_server, $cycquery); if ($cycquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $row = mysqli_fetch_array($cycresult, MYSQLI_ASSOC); mylog("fetched today's date"); mysqli_free_result($cycresult); $cyclevalue = $row['cycleday']; $dayoftheweek = date('D'); $currentminute = date("i"); $specquery = "SELECT specialsched FROM days WHERE daate = '{$today};"; $specresult = mysqli_query($db_server, $specquery); if ($specquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $row = mysqli_fetch_array($specresult, MYSQLI_ASSOC); mylog("fetched today's date"); mysqli_free_result($specresult); $spec = $row['specialsched']; if ($cyclevalue === 'D' || $dayoftheweek === 'Wed' || $spec === 'y') { mylog("entered conditional of timecheck"); //check with dday mod times $nextmodtimefortoday = ddaytimemath(); $ddaymodquery = "SELECT modd FROM ddaymodtimes WHERE timee = '0000-00-00 {$nextmodtimefortoday}';"; mylog($ddaymodquery); $ddaymodqueryresult = mysqli_query($db_server, $ddaymodquery); if ($ddayquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $row = mysqli_fetch_array($ddaymodqueryresult, MYSQLI_ASSOC); mysqli_free_result($ddaymodqueryresult); $mod = $row['modd']; if (empty($mod)) { echo "<h1 style='text-align: center'> Day is over! </h1>"; } else { $nextmodtimequery = "SELECT timee FROM ddaymodtimes WHERE modd = '{$mod}';"; $nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery); if ($nextmodtimequery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}"); $row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC); mysqli_free_result($nextmodtimequeryresult); $timee = $row['timee']; $substroftime = substr($timee, -8); $dateandsubstroftime = $today . $substroftime; $astime = strtotime($dateandsubstroftime); $finalsubstroftime = date("h:i", $astime); $mornorafternoon = date('A'); echo "<h2 style = 'text-align: center'> Mod {$mod} begins at {$finalsubstroftime} {$mornorafternoon}</h2>"; } } else { $db_server = mysqli_connect("localhost", "root", "root", "schedule"); //check with normal mod times $THEformattedtime = date('H:i'); $THEFORMATTEDNOW = "0000-00-00 {$THEformattedtime}:00"; $normalmodquery = "SELECT modd FROM normalmodtimes WHERE timee > '{$THEFORMATTEDNOW}' LIMIT 1;"; $normalmodqueryresult = mysqli_query($db_server, $normalmodquery); if ($normalmodquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } mylog("THE NORMAL MOD QUERY SHOULD BE: {$normalmodquery}"); $row = mysqli_fetch_array($normalmodqueryresult, MYSQLI_ASSOC); mysqli_free_result($normalmodqueryresult); $mod = $row['modd']; if (empty($mod)) { echo "<h1 style='text-align: center'> Day is over! </h1>"; } else { echo "<h1 style='text-align: center'> The next mod is mod {$mod} </h1>"; $nextmodtimequery = "SELECT timee FROM normalmodtimes WHERE modd = '{$mod}';"; $nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery); if ($nextmodtimequery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}"); $row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC); mysqli_free_result($nextmodtimequeryresult); $timee = $row['timee']; $substroftime = substr($timee, -8); $dateandsubstroftime = $today . $substroftime; $astime = strtotime($dateandsubstroftime); $finalsubstroftime = date("h:i", $astime); $mornorafternoon = date('A'); echo "<h2 style = 'text-align: center'> Mod {$mod} begins at {$finalsubstroftime} {$mornorafternoon}</h2>"; /* echo $interval->format("I:S"); $timetillnextmod = $interval; //timee minus current time */ } } }
function timecheck() { $db_server = mysqli_connect("localhost", "root", "root", "schedule"); $today = date("Y-m-d"); $currenthour = date("H"); echo $currenttime; $db_server = mysqli_connect("localhost", "root", "root", "schedule"); $cycquery = "SELECT cycleday FROM days WHERE daate = '{$today}';"; mylog($cycquery); $cycresult = mysqli_query($db_server, $cycquery); if ($cycquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $row = mysqli_fetch_array($cycresult, MYSQLI_ASSOC); mylog("fetched today's date"); mysqli_free_result($cycresult); $cyclevalue = $row['cycleday']; $dayoftheweek = date('D'); $currentminute = date("i"); if ($cyclevalue === 'D' || $dayoftheweek === 'Wed') { mylog("entered conditional of timecheck"); //check with dday mod times $nextmodtimefortoday = ddaytimemath(); $ddaymodquery = "SELECT modd FROM ddaymodtimes WHERE timee = '0000-00-00 {$nextmodtimefortoday}';"; mylog($ddaymodquery); $ddaymodqueryresult = mysqli_query($db_server, $ddaymodquery); if ($ddayquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $row = mysqli_fetch_array($ddaymodqueryresult, MYSQLI_ASSOC); mysqli_free_result($ddaymodqueryresult); $mod = $row['modd']; echo "<h1 style='text-align: center'> The next mod is: {$mod} </h1>"; mylog($ddaymodquery); } else { $db_server = mysqli_connect("localhost", "root", "root", "schedule"); //check with normal mod times $THEformattedtime = date('H:i'); $THEFORMATTEDNOW = "0000-00-00 {$THEformattedtime}:00"; $normalmodquery = "SELECT modd FROM normalmodtimes WHERE timee > '{$THEFORMATTEDNOW}' LIMIT 1;"; $normalmodqueryresult = mysqli_query($db_server, $normalmodquery); if ($normalmodquery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } mylog("THE NORMAL MOD QUERY SHOULD BE: {$normalmodquery}"); $row = mysqli_fetch_array($normalmodqueryresult, MYSQLI_ASSOC); mysqli_free_result($normalmodqueryresult); $mod = $row['modd']; echo "<h1 style='text-align: center'> The next mod is: {$mod} </h1>"; $nextmodtimequery = "SELECT timee FROM normalmodtimes WHERE modd = '{$mod}';"; $nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery); if ($nextmodtimequery->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}"); $row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC); mysqli_free_result($nextmodtimequeryresult); $timee = $row['timee']; $substroftime = substr($timee, -8); echo "this is the next mod's time {$substroftime}"; echo "</br>"; echo " this is today: {$today} "; echo "</br>"; echo " this is the next mod today! {$today} {$substroftime}"; echo "</br>"; $dateandsubstroftime = $today . $substroftime; echo "</br>"; $astime = strtotime($dateandsubstroftime); echo "</br>"; echo $astime; echo "</br>"; echo date("h:i:s"); echo "</br>"; echo date("h:i:s", $astime); echo $interval->format("I:S"); $timetillnextmod = $interval; //timee minus current time echo "<script>\n \$(function () {\n var austDay = new Date();\n austDay = new Date(austDay.getFullYear() + 1, 1 - 1, 26);\n \$('#defaultCountdown').countdown({until: {$astime}});\n \$('#year').text(austDay.getFullYear());\n });\n </script>"; } }