prepare("SELECT max(id) FROM alarm")){ $stmt -> execute(); $stmt -> bind_result($maxid); $stmt -> fetch(); $stmt -> close(); $maxid++; } if($stmt = $mysqli -> prepare("UPDATE alarm SET message=?, name=?, tijd=?, streamurl=?, streamip=?, streamport=?, id=? WHERE id=?")){ $stmt ->bind_param("sssssiii", $message, $alarmname, $tijd, $streamurl, $streamip, $streamport, $maxid, $id); $stmt ->execute(); $stmt ->close(); } $id++; } //Hier moet een select komen if($stmt = $mysqli -> prepare("SELECT message, name, streamurl, streamport, streamip, tijd FROM alarm WHERE id = ?")){ $stmt -> bind_param("i", $id); $stmt -> execute(); $stmt -> bind_result($message, $name, $streamurl, $streamport, $streamip, $tijd); $stmt -> fetch(); $stmt -> close(); } ?>

Alarmen overzicht