Dann erspart ihr euch einigs
mein Frühstück: 
meine Arbeit: 
Dann erspart ihr euch einigs Hab oben ein javascript mit dem das gehen soll , mein Problem ist nur die Einbindung der Variablen ect. mein Frühstück: meine Arbeit: 
Tweet
<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("building");
?>
<html>
<head>
<title>Test</title>
</head>
<body>
<?php if ($action == "") {
$query = "SELECT * FROM in_bau";
$sel = mysql_query($query,$conn) or die(mysql_error());
if (mysql_num_rows($sel)) {
$row = mysql_fetch_assoc($sel);
$data = $row["time"];
$id = $row["ID"];
$query2 = "SELECT name,bauzeit FROM bauten WHERE ID='".$row["b_id"]."'";
$sel2 = mysql_query($query2,$conn) or die(mysql_error());
$row2 = mysql_fetch_assoc($sel2);
$data = time() - $data;
$data2 = $row2["bauzeit"];
$data = $data2-$data;
echo "<form name='form'>";
echo "<input type='hidden' name='field' value='".$data."'>";
echo "</form>";
?>
<SCRIPT type="text/javascript">
var field = window.document.form.field.value;
var TargetTime = new Date();
var TimeBeginn = TargetTime.getTime();
function CountDown(myid, seconds) {
var CurrentDate = new Date();
var CurrentTime = CurrentDate.getTime();
var TimeEnd = TimeBeginn + (seconds*1000);
TargetTime.setTime(TimeEnd);
var Targetbox=document.getElementById(myid);
var OpenTime = Math.floor((TargetTime-CurrentTime)/1000);
var s = OpenTime % 60;
var m = ((OpenTime-s)/60) % 60;
var h = ((OpenTime-s-m*60)/(60*60));
var fh = ((h < 10) ? "0" : "");
var fm = ((m < 10) ? ":0" : ":");
var fs = ((s < 10) ? ":0" : ":");
var Time = fh+h+fm+m+fs+s;
var OutputString=Time;
if(OpenTime<=0) { // Event wenn der Countdown abgelaufen ist
var OutputString="Fertig!";
}
Targetbox.innerHTML=OutputString; // Ausgabe des Strings in der Betreffenden Zelle
window.setTimeout("CountDown('" + myid + "', '" + seconds + "')", 1000);
}
</script>
Du baust gerade <? echo $row2["name"]; ?>, dies dauert noch <span id='id'><script type='text/javascript'>CountDown('id', field);</script></span>!
<?php
if ($data2 >> $data) {
$query = "DELETE FROM in_bau WHERE ID='$id'";
mysql_query($query,$conn) or die(mysql_error());
}
}
?>
<br><br>
<table border=1>
<?php
$query = "SELECT ID,name FROM bauten";
$sel = mysql_query($query,$conn) or die(mysql_error());
while ($row = mysql_fetch_assoc($sel)) {
echo "<tr><td width=200><a href='$_PHP_SELF?action=bauen&b_id=".$row["ID"]."'>".$row["name"]."</a>";
}
?>
</table>
<?php
}
if ($action == "bauen") {
$query = "SELECT ID FROM in_bau";
$sel = mysql_query($query,$conn) or die(mysql_error());
if (mysql_num_rows($sel)) {
die("Es wird bereits gebaut!");
}
$query = "INSERT INTO in_bau VALUES('','$b_id','".time()."')";
mysql_query($query,$conn) or die(mysql_error());
?>
<script>
location.href="<? $_PHP_SELF ?>";
</script>
<?php
}
?>
</body>
</html>
CREATE TABLE `bauten` ( `ID` INT(8) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(50) NOT NULL, `bauzeit` INT(8) NOT NULL ); CREATE TABLE `in_bau` ( `ID` INT(8) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, `b_id` INT(8) NOT NULL, `time` VARCHAR(50) NOT NULL );
Kommentar