<?php
$conn = mysqli_connect("localhost","root","","toggle");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
$sql="SELECT state FROM esp ORDER BY no DESC LIMIT 1";
$result = mysqli_query($conn,$sql);
?>
<!DOCTYPE html>
<html>
<head>
<style>
.switch {
position: relative;
display: inline-block;
width: 60px;
height: 34px;
}
.switch input {
opacity: 0;
width: 0;
height: 0;
}
.slider {
position: absolute;
cursor: pointer;
top: 0;
left: 0;
right: 0;
bottom: 0;
background-color: #ccc;
-webkit-transition: .4s;
transition: .4s;
}
.slider:before {
position: absolute;
content: "";
height: 26px;
width: 26px;
left: 4px;
bottom: 4px;
background-color: white;
-webkit-transition: .4s;
transition: .4s;
}
input:checked + .slider {
background-color: #2196F3;
}
input:focus + .slider {
box-shadow: 0 0 1px #2196F3;
}
input:checked + .slider:before {
-webkit-transform: translateX(26px);
-ms-transform: translateX(26px);
transform: translateX(26px);
}
/* Rounded sliders */
.slider.round {
border-radius: 34px;
}
.slider.round:before {
border-radius: 50%;
}
</style>
</head>
<body>
<h1 style="text-align:center;">LED STATUS</h1>
<form action="" method="POST" id="myform">
<?php
$row2 = mysqli_fetch_assoc($result);
if ($row2['state']==0){
?>
<label class="switch">
<input type="checkbox" name="off" onclick="myform()">
<span class="slider round"></span>
</label>
<?php
}
elseif ($row2['state']==1) {
?>
<label class="switch">
<input type="checkbox" name="on" onclick="myform()" checked>
<span class="slider round"></span>
</label>
<?php
}
?>
</form>
<script>
function myform(){
document.getElementById("myform").submit();
alert("okay take it easy");
}
</script>
<?php
echo $_POST['on'];
echo $_POST['off'];
?>
</body>