Da happerts wieder:
Wenn ich in der DB die Werte ändere und index.php aktualisiere, steht da wieder alles 0.
Wenn ich aber in DB nix ändere und index.php aktualisiere, wird in DB kein Eintrag gemacht, dass sehe ich weil ich TIMESTAMP nutze.
<?php
$id = "1";
$tabellenname = "fuss";
$link = mysql_connect("localhost", "root", "mypass");
mysql_select_db("test", $link);
if (isset($_GET['pin']) && isset($_GET['cmd'])) {
if ($_GET['cmd']=="0") $gcmd="L"; elseif ($_GET['cmd']=="1") $gcmd="H"; else $gcmd="/";
if ((strlen($_GET['pin'])==3) && (substr($_GET['pin'],0,1)=="P")) {
if (intval(substr($_GET['pin'],-2))<=13 && intval(substr($_GET['pin'],-2))>=2) $gpin=substr($_GET['pin'],-2); else $gpin="";
// $message="/*CMD".$gpin.$gcmd."/"; // create message string
}
}
$gpin = $_GET['pin'];
$cmd = $_GET['cmd'];
// Wenn die Checkbox gesetzt wurde hat sie den value-Wert ansonsten ist sie leer und erhält eine 0 als Wert
if ($_POST['pin']) $gpin = $_POST['pin'];
else $gpin = 0;
if ($_POST['cmd']) $cmd = $_POST['cmd'];
else $cmd = 0;
// Die UPDATE-Anweisung an die Datenbank
mysql_query("UPDATE $tabellenname SET Pin = '$gpin', Value = '$cmd' WHERE id = '$id'", $link);
// Datenbankabfrage
$sql = "SELECT Pin, Value FROM $tabellenname WHERE id='$id'";
$result = mysql_query($sql, $link);
list($gpin, $cmd) = mysql_fetch_array($result);
?>
<!DOCTYPE html>
<html>
<head>
<title>ArduDome</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
<meta name="apple-mobile-web-app-capable" content="yes" />
<meta name="apple-mobile-web-app-status-bar-style" content="black" />
<link rel="apple-touch-icon" href="../images/conference-room.png"/>
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.3.0/jquery.mobile-1.3.0.min.css" />
<script src="http://code.jquery.com/jquery-1.8.2.min.js"></script>
<script src="http://code.jquery.com/mobile/1.3.0/jquery.mobile-1.3.0.min.js"></script>
<link rel="stylesheet" href="ardudome.css" />
</head>
<body>
<div data-role="page" data-title="ArduDome" id="ardudome-page">
<div data-theme="d" data-role="header">
<h1>
ArduDome
</h1>
</div>
<div data-role="content">
<div class="content-primary">
<div class="s-title"><center>Outputs</center></div>
<ul data-role="listview" data-inset="true" >
<form action="index.php" method="post">
<li>
<input type="checkbox" name="int02" value="1" <?php if ($int02 == "1") echo "checked"; ?>/> Segeln
<input type="checkbox" name="int03" value="1" <?php if ($int03 == "1") echo "checked"; ?>/> Golf
<input type="submit" name="submit" value="Abschicken" />
</li>
</form>
<li>
<label for="P02"><b>OUT 02</b></label>
<select name="P02" id="P02" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P13"><b>OUT 13</b></label>
<select name="P13" id="P13" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
</ul>
</div>
<div class="content-secondary">
<div class="s-title"><center>Inputs</center></div>
<?php print_r($result); ?>
<ul data-role="listview" data-inset="true" >
<li>
<label><b>IN A0</b></label>
<span class="inputvalue" name="P14" id="P14">0</span>
</li>
<li>
<label><b>IN A1</b></label>
<span class="inputvalue" name="P15" id="P15">0</span>
</li>
<li>
<label><b>IN A2</b></label>
<span class="inputvalue" name="P16" id="P16">0</span>
</li>
<li>
<label><b>IN A3</b></label>
<span class="inputvalue" name="P17" id="P17">0</span>
</li>
<li>
<label><b>IN A4</b></label>
<span class="inputvalue" name="P18" id="P18">0</span>
</li>
<li>
<label><b>IN A5</b></label>
<span class="inputvalue" name="P19" id="P19">0</span>
</li>
</ul>
</div>
<!-- <button id="test">Test</button> -->
</div>
<div data-theme="d" data-role="footer">
<h1>by Luca Soltoggio</h1>
</div>
</div>
<script src="ardudome.js"></script>
</body>
</html>
var visibleFlag = 1;
// get and parse json data from PHP file and update HTML page
function get_arduino_data() {
if (visibleFlag) {
var jqxhr = $.getJSON('index.php?' + 'random=' + Math.random(), function(data) {
// call value_update function passing json variable
value_update(data);
$("[data-role='slider']").slider('enable');
$('label').css('color','#333');
$('.ui-bar-d').css('color', '#333');
$('.inputvalue').css('color','coral');
$('.s-title').css('color','#333');
})
}
}
// call PHP file sending "pin" & "cmd" got from HTML page, and update
function set_arduino_data(pname,pvalue) {
$.post('index.php?pin=' + pname + '&cmd=' + pvalue + '&random=' + Math.random(), function(data) {
value_update(data);
});
}
// if a slider changed, this funciont will call the function above using as "pname" the name of
// modified slider and as "pvalue" the actual value of the slider (0 or 1)
function detect_changes() {
$("[data-role='slider']").change(function() {
set_arduino_data($(this).attr("name"),$(this).val());
});
}
// function for parsing json data and updating HTML page
// this will update slider status and label value
function value_update(data) {
$.each(data, function (index, value) {
if(parseInt(index)<=13) {
$('#P'+index).val(value).slider("refresh");
}
else
{
$('#P'+index).text(value);
}
});
}
// function for checking if the page is visible or not
// (if not visible it will stop updating data)
function checkVisibility() {
$(window).bind("focus", function(event) {
visibleFlag = 1;
});
$(window).bind("blur", function(event) {
visibleFlag = 0;
});
}
// start all above every 5 seconds
$(document).ready(function(){
get_arduino_data();
detect_changes();
setInterval('get_arduino_data()', 5000);
checkVisibility();
});