<?include "conninfo.php";  //include database connection


echo "<h1>Welcome</h1>";

$query="SELECT * FROM people";   //select all fields;

$result=mysqli_query($link,$query);//actually run query

while($r=mysqli_fetch_array($result))   //mysqli_fetch_assoc as an alternative
{
echo $r["id"]." ";
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["favfood"];?>

<form action="delete.php" method="post">

<input type="hidden" name="theid" value="<?echo $r["id"];?>">
<input type="submit" value="Delete">

</form>


<?
echo "<br>";
}

?>
