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=?, snoozetijd=?, streamdomain=? WHERE id=?")){
$stmt ->bind_param("sssssiiisi", $message, $alarmname, $tijd, $streamurl, $streamip, $streamport, $maxid, $snoozetijd, $streamdomain, $id);
$stmt ->execute();
$stmt ->close();
}
$id = $maxid;
print('
Alarm succesvol gewijzigd
');
}
//Hier moet een select komen
if($stmt = $mysqli -> prepare("SELECT message, name, streamurl, streamport, streamip, tijd, snoozetijd, streamdomain FROM alarm WHERE id = ?")){
$stmt -> bind_param("i", $id);
$stmt -> execute();
$stmt -> bind_result($message, $name, $streamurl, $streamport, $streamip, $tijd, $snoozetijd, $streamdomain);
$stmt -> fetch();
$stmt -> close();
}
?>