<!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 CinePerson");
$statementExtra->execute();
$resultExtra = $statementExtra->get_result();
if(isset($_POST['submit']))
{
$email = $_POST['email'];
$pass = $_POST['password'];
$admin=isset($_POST['isAdmin']) ? 1 : 0;
$name=$_POST['name'];
$lastName=$_POST['lastName'];
$encrPass=md5($pass);
//insert into CineEntry
$statement = $LINK->prepare("INSERT INTO CinePerson(isActif,email,password,isAdmin,name,lastName) VALUES (1, ?,?,?,?,?)");
$statement->bind_param('ssiss', $email, $encrPass,$admin,$name,$lastName);
$statement->execute();
$statement->close();
echo "New Account created successfully";
header("Location: ?Users"); //put this onto the index page instead of loading a new page
}
?>
<form id="form" method="POST">
<br>
<label for="email">Email: </label>
<input type="text" name="email">
<br>
<br>
<label for="password">Password: </label>
<input type="password" name="password">
<br>
<!-- startTime, endTime missing for now -->
<label for="isAdmin">isAdmin?</label>
<input type="checkbox" name="isAdmin">
<br>
<br>
<label for="name">Name: </label>
<input type="text" name="name">
<br>
<label for="lastname">Last Name: </label>
<input type="text" name="lastName">
<br>
<button type="submit" name="submit">Submit</button>
</form>
<form action="index.php">
<button type="submit">Back</button>
</form>
<?php
// READ Extras
$films = [];
$stmt = $LINK->prepare("SELECT * FROM CinePerson");
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$films[] = $row;
}
?>
<!-- READ TABLE -->
<h2>All films</h2>
<table border="1" cellpadding="5">
<tr>
<th>ID</th>
<th>Email</th>
<th>Password</th>
<th>name</th>
<th>lastName</th>
<th>actif?</th>
<th>admin?</th>
</tr>
<?php foreach ($films as $film): ?>
<tr>
<td><?= $film['pk_person'] ?></td>
<td><?= htmlspecialchars($film['email']) ?></td>
<td><?= str_repeat('•', 8) ?></td>
<td><?= $film['name'] ?></td>
<td><?= $film['lastName'] ?></td>
<td><?= $film['isActif'] ?></td>
<td><?= $film['isAdmin'] ?></td>
<td>
<a href="?editUser=<?= $film['pk_person'] ?>">Edit</a> |
<a href="?deleteUser=<?= $film['pk_person'] ?>" onclick="return confirm('Delete this film?')">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>