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