Skip to content

Instantly share code, notes, and snippets.

@sadv1r

sadv1r/light.php

Created April 3, 2015 18:11
Show Gist options
  • Save sadv1r/b56ca34c74ed1246a835 to your computer and use it in GitHub Desktop.
Save sadv1r/b56ca34c74ed1246a835 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
light.php
<!DOCTYPE html>
<?php
session_start();
include ("db.php");
if (isset($_POST['name'])) {
$lol = $_POST['name'];
$lol2 = str_split($lol);
if ($lol2[1] == 1) {
$query = "UPDATE light SET `on` = 1 WHERE id = ".(int)$lol[0];
$result = mysql_query($query, $db) or die(mysql_error());
} else {
$query = "UPDATE light SET `on` = 0 WHERE id = ".(int)$lol[0];
$result = mysql_query($query, $db) or die(mysql_error());
}
}
if (isset($_POST['auto'])) {
$lol = $_POST['auto'];
$lol2 = str_split($lol);
if ($lol2[1] == 1) {
$query = "UPDATE light SET `auto_on` = 1 WHERE id = ".(int)$lol[0];
$result = mysql_query($query, $db) or die(mysql_error());
} else {
$query = "UPDATE light SET `auto_on` = 0 WHERE id = ".(int)$lol[0];
$result = mysql_query($query, $db) or die(mysql_error());
}
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="Sadv1r">
<title>Освещение - Умный аквариум</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.css" rel="stylesheet">
<!-- Add custom CSS here -->
<link href="css/sb-admin.css" rel="stylesheet">
<link rel="stylesheet" href="font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="css/bootstrap-formhelpers.min.css">
<script src="js/jquery-1.10.2.js"></script>
<script src="js/bootstrap-formhelpers.min.js"></script>
</head>
<body>
<div id="wrapper">
<!-- Sidebar -->
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.php">Умный Аквариум</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse navbar-ex1-collapse">
<ul class="nav navbar-nav side-nav">
<li><a href="index.php"><i class="fa fa-dashboard"></i> Текущее состояние</a></li>
<li><a href="devices.php"><i class="fa fa-desktop"></i> Состояние оборудования</a></li>
<li class="active"><a href="light.php"><i class="fa fa-lightbulb-o"></i> Освещение</a></li>
<li><a href="charts.html"><i class="fa fa-bar-chart-o"></i> Charts</a></li>
<li><a href="tables.html"><i class="fa fa-table"></i> Tables</a></li>
<li><a href="forms.html"><i class="fa fa-edit"></i> Forms</a></li>
<li><a href="typography.html"><i class="fa fa-font"></i> Typography</a></li>
<li><a href="bootstrap-elements.html"><i class="fa fa-desktop"></i> Bootstrap Elements</a></li>
<li><a href="bootstrap-grid.html"><i class="fa fa-wrench"></i> Bootstrap Grid</a></li>
<li><a href="blank-page.html"><i class="fa fa-file"></i> Blank Page</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-caret-square-o-down"></i> Dropdown <b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="#">Dropdown Item</a></li>
<li><a href="#">Another Item</a></li>
<li><a href="#">Third Item</a></li>
<li><a href="#">Last Item</a></li>
</ul>
</li>
</ul>
<ul class="nav navbar-nav navbar-right navbar-user">
<li class="dropdown messages-dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-envelope"></i> Messages <span class="badge">7</span> <b class="caret"></b></a>
<ul class="dropdown-menu">
<li class="dropdown-header">7 New Messages</li>
<li class="message-preview">
<a href="#">
<span class="avatar"><img src="http://placehold.it/50x50"></span>
<span class="name">John Smith:</span>
<span class="message">Hey there, I wanted to ask you something...</span>
<span class="time"><i class="fa fa-clock-o"></i> 4:34 PM</span>
</a>
</li>
<li class="divider"></li>
<li class="message-preview">
<a href="#">
<span class="avatar"><img src="http://placehold.it/50x50"></span>
<span class="name">John Smith:</span>
<span class="message">Hey there, I wanted to ask you something...</span>
<span class="time"><i class="fa fa-clock-o"></i> 4:34 PM</span>
</a>
</li>
<li class="divider"></li>
<li class="message-preview">
<a href="#">
<span class="avatar"><img src="http://placehold.it/50x50"></span>
<span class="name">John Smith:</span>
<span class="message">Hey there, I wanted to ask you something...</span>
<span class="time"><i class="fa fa-clock-o"></i> 4:34 PM</span>
</a>
</li>
<li class="divider"></li>
<li><a href="#">View Inbox <span class="badge">7</span></a></li>
</ul>
</li>
<li class="dropdown alerts-dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bell"></i> Alerts <span class="badge">3</span> <b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="#">Default <span class="label label-default">Default</span></a></li>
<li><a href="#">Primary <span class="label label-primary">Primary</span></a></li>
<li><a href="#">Success <span class="label label-success">Success</span></a></li>
<li><a href="#">Info <span class="label label-info">Info</span></a></li>
<li><a href="#">Warning <span class="label label-warning">Warning</span></a></li>
<li><a href="#">Danger <span class="label label-danger">Danger</span></a></li>
<li class="divider"></li>
<li><a href="#">View All</a></li>
</ul>
</li>
<li class="dropdown user-dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> John Smith <b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="#"><i class="fa fa-user"></i> Profile</a></li>
<li><a href="#"><i class="fa fa-envelope"></i> Inbox <span class="badge">7</span></a></li>
<li><a href="#"><i class="fa fa-gear"></i> Settings</a></li>
<li class="divider"></li>
<li><a href="#"><i class="fa fa-power-off"></i> Log Out</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</nav>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1>Освещение <small></small></h1>
<?php
$result = mysql_query("SELECT * FROM light",$db); //извлекаем из базы все данные о пользователе с введенным логином
while ($myrow = mysql_fetch_array($result)) {
echo "<form action='light.php' method='post'>";
if ($myrow["on"] == 1) {
echo "<button type='submit' class='btn btn-success' name = 'name' value=".$myrow["id"]."0>".$myrow["id"]."</button> ";
} elseif ($myrow["on"] == 0) {
echo "<button type='submit' class='btn' name = 'name' value=".$myrow["id"]."1>".$myrow["id"]."</button> ";
} else {
echo "<button type='button' class='btn disabled'>".$myrow["id"]."</button> ";
}
echo "<div class='btn-group'>";
if ($myrow["auto_on"] == 1) {
echo "<button type='submit' class='btn btn-success' name = 'auto' value=".$myrow["id"]."0>Auto</button>";
} elseif ($myrow["auto_on"] == 0) {
echo "<button type='submit' class='btn' name = 'auto' value=".$myrow["id"]."1>Auto</button>";
} else {
echo "<button type='button' class='btn' disabled>Auto</button>";
}
echo"<div class='btn-group'><button type='button' class='btn btn-default'><i class='fa fa-wrench'></i></button>";
echo "</div></div></form>";
}
?>
<!--<div class="bfh-timepicker" icon="fa fa-clock-o">
<input id="timepickers" type="text" class="timepicker" >
</div>
<script>
$('#timepickers').bfhtimepicker('toggle')
</script>-->
</div>
</div><!-- /.row -->
</div><!-- /#page-wrapper -->
</div><!-- /#wrapper -->
<!-- JavaScript -->
<!--<script src="js/jquery-1.10.2.js"></script>-->
<script src="js/bootstrap.js"></script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment