<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="Styles/styles.css">
</head>
<body>
<?php
$LINK = mysqli_connect('127.0.0.1','pisjo950','vjPRjFTxDVIoG7)t','pisjo950');
//get all the extratimes
$statementExtra = $LINK->prepare("SELECT * FROM CineExtra");
$statementExtra->execute();
$resultExtra = $statementExtra->get_result();
if(isset($_POST['submit']))
{
$name = $_POST['name'];
$defaultTime = $_POST['defaultTime'];
//insert into CineEntry
$statement = $LINK->prepare("INSERT INTO CineExtra(name, defaultTime) VALUES (?, ?)");
$statement->bind_param('si', $name, $defaultTime);
$statement->execute();
$statement->close();
echo "New Extra created successfully";
header("Location: index.php"); //put this onto the index page instead of loading a new page
}
?>
<form id="form" method="POST">
<br>
<label for="date">Name </label>
<input type="text" name="name">
<br>
<!-- startTime, endTime missing for now -->
<label for="default Label">Default Time(minutes):</label>
<input type="number" name="defaultTime" min="0" step="1">
<br>
<button type="submit" name="submit">Submit</button>
</form>
<form action="index.php">
<button type="submit">Back</button>
</form>
<?php
// READ Extras
$extras = [];
$stmt = $LINK->prepare("SELECT * FROM CineExtra");
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$extras[] = $row;
}
?>
<!-- READ TABLE -->
<h2>All Extras</h2>
<table border="1" cellpadding="5">
<tr>
<th>ID</th>
<th>Name</th>
<th>Default Time (min)</th>
<th>Actions</th>
</tr>
<?php foreach ($extras as $extra): ?>
<tr>
<td><?= $extra['pk_extra'] ?></td>
<td><?= htmlspecialchars($extra['name']) ?></td>
<td><?= $extra['defaultTime'] ?></td>
<td>
<a href="?editExtra=<?= $extra['pk_extra'] ?>">Edit</a> |
<a href="?deleteExtra=<?= $extra['pk_extra'] ?>" onclick="return confirm('Delete this extra?')">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>