<!DOCTYPE html>
<html lang="hu">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<link rel="stylesheet" href="reg.css"/>
</head>
<body>
<h1>Delete</h1>
<?php
require_once('auth.php');
require_once('constants.php');

if(isset($_POST['submit'])){
 $dbc=mysqli_connect(HOST, USER, PASSWD, DB) or die('Connection error...');
 foreach($_POST['todelete'] as $toDelete)
 {
  $query="SELECT * FROM participants WHERE id=$toDelete";
  $result=mysqli_query($dbc, $query) or die('Error...');
  $row=mysqli_fetch_array($result);
  @unlink(PATH.$row['picture']);
  $query="DELETE FROM participants WHERE id=$toDelete";
  mysqli_query($dbc, $query) or die('Error...');
 }
 mysqli_close($dbc); 
 echo '<h3>Participant has been deleted.</h3>';
}
?>

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<?php
$dbc=mysqli_connect(HOST, USER, PASSWD, DB) or die('Connection error...');
$query="SELECT * FROM participants";
$result=mysqli_query($dbc, $query) or die('Error...');
 while($row=mysqli_fetch_array($result)){
  echo '<h3><input type="checkbox" name="todelete[]" value="'.$row['id'].'"/> ';
  echo 'Name: '.$row['name'].', email: '.$row['email'].'     <img src="'.PATH.$row['picture'].'"/></h3>';
 }
mysqli_close($dbc); 
?>
<p><input type="submit" name="submit" value="Delete"/></p>
</form>
<h2><a href="main.html">&lt;&lt;Back to the main page</a></h2>
</body>
</html>









