" . mysqli_error($db); endif; elseif (isset($_GET['cmd_door'])): $cmd_door = $_GET['cmd_door']; system("sudo -u pi /var/www/html/cpp/cmd_door " . $cmd_door); if ($cmd_door == 1): $msg = "Door manually closed"; elseif ($cmd_door == 0): $msg = "Door manually opened"; endif; $query = "INSERT INTO messages(message_type, message) VALUES (\"Update\", '$msg')"; if (!mysqli_query($db, $query)): print "Error: " . $query . "
" . mysqli_error($db); endif; endif; if (isset($_GET['door_automation'])) $door_automation = $_GET['door_automation']; if (isset($_GET['door_algorithm'])) $door_algorithm = $_GET['door_algorithm']; if (isset($_GET['open_time_hour'])) $open_time_hour = $_GET['open_time_hour']; if (isset($_GET['open_time_minute'])) $open_time_minute = $_GET['open_time_minute']; if (isset($_GET['close_time_hour'])) $close_time_hour = $_GET['close_time_hour']; if (isset($_GET['close_time_minute'])) $close_time_minute = $_GET['close_time_minute']; if (isset($_GET['heater_automation'])) $heater_automation = $_GET['heater_automation']; if (isset($_GET['use_sun'])) $use_sun = $_GET['use_sun']; if (isset($_GET['sunrise_buffer_minutes'])) $sunrise_buffer_minutes = $_GET['sunrise_buffer_minutes']; if (isset($_GET['sunset_buffer_minutes'])) $sunset_buffer_minutes = $_GET['sunset_buffer_minutes']; if (isset($_GET['heater_lower_limit'])) $heater_lower_limit = $_GET['heater_lower_limit']; if (isset($_GET['heater_upper_limit'])) $heater_upper_limit = $_GET['heater_upper_limit']; if (isset($open_time_hour) && isset($open_time_minute)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `open_time_hour` = '$open_time_hour', `open_time_minute` = '$open_time_minute', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); /* $output = shell_exec('crontab -u pi -l'); file_put_contents('/tmp/crontab.txt', $output.'* 4 * * * NEW_CRON'.PHP_EOL); echo exec('crontab -u pi /tmp/crontab.txt'); */ elseif (isset($door_automation)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `door_automation` = '$door_automation', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($door_algorithm)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `door_algorithm` = '$door_algorithm', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($close_time_hour) && isset($close_time_minute)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `close_time_hour` = '$close_time_hour', `close_time_minute` = '$close_time_minute', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($use_sun)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `use_sun` = '$use_sun', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($sunrise_buffer_minutes)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `sunrise_buffer_minutes` = '$sunrise_buffer_minutes', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($sunset_buffer_minutes)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `sunset_buffer_minutes` = '$sunset_buffer_minutes', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($heater_automation)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `heater_automation` = '$heater_automation', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($heater_lower_limit)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `heater_lower_limit` = '$heater_lower_limit', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); elseif (isset($heater_upper_limit)): $timestamp = date('Y-m-d H:i:s'); $query = "UPDATE `chicken_coop`.`defaults` SET `heater_upper_limit` = '$heater_upper_limit', `timestamp` = '$timestamp' WHERE `defaults`.`id` = 1"; $result = mysqli_query($db, $query); endif; // Get the pin values $heater = shell_exec("/usr/local/bin/gpio -g read 26"); // Get temperature from database (temp_log) $query = "SELECT * FROM `status` ORDER BY `timestamp` DESC LIMIT 1"; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result, MYSQLI_ASSOC); $temperature = $row['temperature']; // Show the webpage $query = "SELECT * FROM defaults"; $result = mysqli_query($db, $query); $defaults = mysqli_fetch_array($result, MYSQLI_ASSOC); ?>

Chicken Coop

logout
Variable Current State Change Value Submit
Door
> Open > Close
Door Automation
> Enabled > Disabled
Door Algorithm
> On Alarm > Every Minute
Open Time
:
Close Time
:
Use Sunrise/Sunset
> Enabled > Disabled
Sunrise Buffer
Sunset Buffer
Temperature
Heater
> On > Off
Heater Automation
> Enabled > Disabled
Heater Upper Limit
Heater Lower Limit
" . mysqli_error($db); } // Present the data while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo ""; echo""; echo""; echo""; echo""; echo""; echo ""; } ?>
Timestamp Temperature Heater Door Position WiFi Status
"; echo $row["timestamp"]; echo ""; echo $row["temperature"] . "℉"; echo ""; if ($row["heater"] == 1) echo "On"; else echo "Off"; echo ""; if ($row["sensor_opened"] == 1 && $row["sensor_closed"] == 1) echo "Traveling"; elseif ($row["sensor_opened"] == 0) echo "Open"; elseif ($row["sensor_closed"] == 0) echo "Closed"; else echo "Error: opened and closed"; echo ""; echo $row["wifi_status"] . " dBm"; echo "
" . mysqli_error($db); } // Present the data while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo ""; echo""; echo""; echo""; echo ""; } ?>
Timestamp Message Type Message
"; echo $row["timestamp"]; echo ""; echo $row["message_type"]; echo ""; echo $row["message"]; echo "