getmtg

[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 ”

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“. $row[‘name’].” “. $row[‘episode’].” “. $row[‘month’].”&nbsp “.$row[‘day’].”,&nbsp “.$row[‘year’].”

“. $row[’embed’].”

“;
}

/* free result set */
$result->close();

/* close connection */
$link->close();
[/insert_php]