Und wie tuht man die Wechselumschalter aus der Datenbank Updaten?
Bei den Checkboxen klappts, nur die Umschalter machen Probleme.
<?php
$id = "1";
$tabellenname = "fuss";
$link = mysql_connect("localhost", "root", "mypass");
mysql_select_db("test", $link);
// Wenn das Formular abgeschickt wurde
if ($_POST['submit']) {
// Wenn die Checkbox gesetzt wurde hat sie den value-Wert ansonsten ist sie leer und erhält eine 0 als Wert
if ($_POST['pin']) $pin = $_POST['pin'];
else $gpin = 0;
if ($_POST['int02']) $int02 = $_POST['int02'];
else $int02 = 0;
if ($_POST['int03']) $int03 = $_POST['int03'];
else $int03 = 0;
// Die UPDATE-Anweisung an die Datenbank
mysql_query("UPDATE $tabellenname SET int01 = '$pin', int02 = '$int02', int03 = '$int03' WHERE id = '$id'", $link);
}
// Datenbankabfrage
$sql = "SELECT int01, int02, int03 FROM $tabellenname WHERE id='$id'";
$result = mysql_query($sql, $link);
list($pin, $int02, $int03) = 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" >
<li>
<form action="index.php" method="post">
<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" />
</form>
</li>
<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="P03"><b>OUT 03</b></label>
<select name="P03" id="P03" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P04"><b>OUT 04</b></label>
<select name="P04" id="P04" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P05"><b>OUT 05</b></label>
<select name="P05" id="P05" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P06"><b>OUT 06</b></label>
<select name="P06" id="P06" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P07"><b>OUT 07</b></label>
<select name="P07" id="P07" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P08"><b>OUT 08</b></label>
<select name="P08" id="P08" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P09"><b>OUT 09</b></label>
<select name="P09" id="P09" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P10"><b>OUT 10</b></label>
<select name="P10" id="P10" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P11"><b>OUT 11</b></label>
<select name="P11" id="P11" data-mini="false" data-role="slider">
<option value="0">Off</option>
<option value="1">On</option>
</select>
</li>
<li>
<label for="P12"><b>OUT 12</b></label>
<select name="P12" id="P12" 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>