I want to have editable rows in my table so I need to link the PHP file while passing the id from my database Fetches. The problem is that the 'a href' won't show me any id when I get to the edit.php page.
<?php
$user = 'root';
$password = 'root';
$db = 'projekte_db';
$host = 'localhost';
$port = 3306;
$con = mysqli_connect($host, $user, $password, $db);
$query = "Select id,name,ort,strasse,projektleiter from Projekt";
$result = mysqli_query($con,$query);
while($row = mysqli_fetch_array($result)){
echo "<tr>
<td>".$row["id"]."</td>
<td>".$row["name"]."</td>
<td>".$row["ort"]."</td>
<td>".$row["strasse"]."</td>
<td>".$row["projektleiter"]."</td>
<td><a href='edit.php?id='".$row["id"]."alt='edit'>Bearbeiten</a></td>
</tr>";
}?>
Can someone help me with this?