[insert_php]
//Get the id passed with the URL from the list of names
$id=$_GET[‘id’];
//Connecting to the database
$link = mysqli_connect(“localhost”,”vod”,”camera@ction505!”,”vod”) or die(“Error ” . mysqli_error($link));
//SQL query
$query=”select * from video WHERE id=$id”;
//Run the query
$result = $link->query($query);
while($row = $result->fetch_array())
{
$rows[] = $row;
}
foreach($rows as $row)
{
echo ”
“. $row[‘name’].” “. $row[‘episode’].” “. $row[‘month’].”  “.$row[‘day’].”,  “.$row[‘year’].” |
“;
}
/* free result set */
$result->close();
/* close connection */
$link->close();
[/insert_php]