l106/PO database/TeamsDetail.php
<!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" type="text/css" href="style.css?t <?php echo time();?>">
</head>
<body>
<?php
include('menubalk.php');
include('../db.php');
include('functions.php');
if(isset($_GET['edit'])){
$edit=$_GET['edit'];
echo "<button><a href='TeamsDetail.php?teamid=$edit'>Back</a></button>";
}
else{
$edit=null;
}
if(!$edit){
$Teamid = $_GET['teamid'];
$query = "SELECT * FROM Teams WHERE teamid = $Teamid";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$row = mysqli_fetch_array($result);
if($admin == true){
echo "<td><a href='TeamsDetail.php?edit=$row[teamid]'>Wijzigen</a></td>";
}
echo"<h1>$row[naam]</h1>";
echo "<div class ='groet'>Stadion: $row[stadion]</div>";
echo "<div class ='groet'>Stad: $row[stad]</div>";
echo "<div class='groet'>Jaar opgericht: $row[opgericht]</div>";
echo "<img src='image/$row[naam] spelers.webp' class='img_team_spelers'>";
$stadion = $row['stadion'];
$stad = $row['stad'];
$opgericht = $row['opgericht'];
$query2 = "SELECT * FROM Spelers WHERE teamid = $Teamid";
$result2 = mysqli_query($db, $query2) or die(mysqli_error($db));
echo "<h1>Team Spelers</h1>";
while($row2 = mysqli_fetch_array($result2)){
echo"<div class='groet'><a href='spelersdetail.php?spelerid=$row2[spelerid]'>$row2[voornaam] $row2[achternaam] </a> </div>";
}
}
if($edit){
$query3 = "SELECT * FROM Teams WHERE teamid = $edit";
$result3 = mysqli_query($db, $query3) or die(mysqli_error($db));
$row3 = mysqli_fetch_array($result3);
echo '<form>';
echo "<input type='hidden' name='teamid' value='$row3[teamid]'>";
echo "<h1>Gegevens aanpassen van: $row3[naam]</h1>";
echo "<div class='groet'> Stadion: <input type='text' name='Stadion' value=''></div>";
echo "<div class='groet'> Stad: <input type='text' name='Stad' value=''></div>";
echo "<div class='groet'> Jaar opgericht: <input type='text' name='opgericht' value=''></div>";
echo "<input type='submit' name='submit' value='Opslaan'>";
echo '</form>';
}
if(isset($_GET['submit'])){
$teamid=$_GET['teamid'];
$query4 = "SELECT * FROM Teams WHERE teamid = $teamid";
$result4 = mysqli_query($db, $query4) or die(mysqli_error($db));
$row4 = mysqli_fetch_array($result4);
if(!$_GET['Stadion']==''){
$text = "stadion = '$_GET[Stadion]'";
}
if(!$_GET['Stad']==''){
$text = "$text stad = '$_GET[Stad]'";
}
if(!$_GET['opgericht']==''){
$text = "$text opgericht = '$_GET[opgericht]'";
}
echo"$stad\n$stadion\n$opgericht";
$query1 = "UPDATE Teams SET $text WHERE teamid = $teamid";
$result1= mysqli_query($db, $query1) or die(mysqli_error($db).$query);
$edit = null;
header("Location: TeamsDetail.php?teamid=$Teamid");
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse