<?php
$editId = $_GET['editExtra'];
echo($editId);
$statement = $LINK->prepare("SELECT name, defaultTime FROM CineExtra WHERE pk_extra=?");
$statement->bind_param('i', $editId);
$statement->execute();
$result = $statement->get_result();
if ($result) {
$row = $result->fetch_assoc();
?>
<h2>Edit Extra</h2>
<form method="POST" action="">
<input type="hidden" name="extra_id" value="<?= $editId ?>">
<label for="name">Name:</label>
<input type="text" name="name" value="<?= htmlspecialchars($row['name']) ?>">
<br>
<label for="defaultTime">Default Time (minutes):</label>
<input type="label" name="defaultTime" min="0" value="<?= $row['defaultTime'] ?>">
<br>
<button type="submit" name="update">Save Changes</button>
<a href="?extra"><button type="button">Cancel</button></a>
</form>
<?php
if(isset($_POST['update']))
{
$name=$_POST['name'];
$default=$_POST['defaultTime'];
$statement1 = $LINK->prepare("UPDATE CineExtra SET name = ?, defaultTime = ? WHERE pk_extra = ?");
$statement1->bind_param('ssi',$name,$default,$editId);
$statement1->execute();
header('Location:?extra');
exit();
}
}
?>