<?php
$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
if ($db_found)
{
$video=$_GET[video];
$SQL = "SELECT `videosub`.* FROM videosub WHERE (`videosub`.`vid` ='$video'))";
$result = mysql_query($SQL);
if ($result)
{
$playfile=$result['file_url'];
}
mysql_close($db_handle);
}
else
{
print "Database NOT Found ";
mysql_close($db_handle);
}
?>
<html>
<head>
</head>
<body>
<OBJECT ID="MediaPlayer" WIDTH="400" HEIGHT="389" CLASSID="CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95"
STANDBY="Loading" TYPE="application/x-oleobject">
<PARAM NAME="FileName" VALUE="<?php print($playfile);?>">
<PARAM name="autostart" VALUE="false">
<PARAM name="ShowControls" VALUE="true">
<param name="ShowStatusBar" value="false">
<PARAM name="ShowDisplay" VALUE="false">
<EMBED TYPE="application/x-mplayer2" SRC="<?php print($playfile);?>" NAME="MediaPlayer"
WIDTH="400" HEIGHT="389" ShowControls="1" ShowStatusBar="0" ShowDisplay="0" autostart="0"> </EMBED>
</OBJECT>
<br>
<p><a href="video.php?video=1">Video 1</a></p>
<p><a href="video.php?video=2">Video 2 </a></p>
<p><a href="video.php?video=3">Video 3 </a></p>
</body>
</html>
CODE EXPLANATION
Using the links we pass the value
Then using above php code we retrieve the value which is passed using the url (ie $_GET[video]=2]
We use that value to extract a file url from the database
Once the file url is retrieved we assign that value to a variable then use that variable in the wmv playersfile url code to view the video
thats all !!!:)
machan oyage code eka weda karanawa.. habai e code eka secutrity athi nam godak durvalai. SQL INJECTION ekak gahanna puluwan lesiyenma :D
$video=$_GET[video];
othanadi kisima security check kirimak wenne na. :rofl: