LAB8-show.php

<?php
$servername = 'mysql';
$username = 'root';
$password = '123456789';
$dbname = 'phpdb';

$conn = mysqli_connect($servername,$username,$password);
if(!$conn)
    die('connected failed');
echo 'connected success<br>';

mysqli_select_db($conn,$dbname);

$id =  $_POST['id'];
$name = $_POST['name'];
$sql = "SELECT * FROM p";

$result = mysqli_query($conn,$sql);
if($result->num_rows>0){
    while($row = mysqli_fetch_assoc($result)){
        echo 'id ='. $row['id'].' '.
             'name = '.$row['name'].'<br>';
    }
}

if(!mysqli_query($conn,$sql))
    echo 'Error'.mysqli_error($conn);
else
    echo 'success';

mysqli_close($conn);
?>

<a href="from.php">Back</a>