Reply to thread

Message

<blockquote data-quote="3.5G" data-source="post: 5529644" data-attributes="member: 158943">try and see[PHP]&lt;?php&nbsp; &nbsp; $db_handle = mysql_connect($server, $user_name, $password);&nbsp; &nbsp; $db_found = mysql_select_db($database, $db_handle);&nbsp; &nbsp; if ($db_found) &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $video=$_GET[video];&nbsp; &nbsp; &nbsp; &nbsp; $SQL = &quot;SELECT `videosub`.* FROM videosub WHERE (`videosub`.`vid` ='$video'))&quot;;&nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($SQL);&nbsp; &nbsp; &nbsp; &nbsp; if ($result)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $playfile=$result['file_url'];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; mysql_close($db_handle);&nbsp; &nbsp; }&nbsp; &nbsp; else &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; print &quot;Database NOT Found &quot;;&nbsp; &nbsp; &nbsp; &nbsp; mysql_close($db_handle);&nbsp; &nbsp; }?&gt;[/PHP][CODE]&lt;html&gt;&lt;head&gt;&lt;/head&gt;&lt;body&gt;&nbsp; &lt;OBJECT ID=&quot;MediaPlayer&quot; WIDTH=&quot;400&quot; HEIGHT=&quot;389&quot; CLASSID=&quot;CLSID:22D6F312-B0F6-11D0-94AB-0080C74C7E95&quot;STANDBY=&quot;Loading&quot; TYPE=&quot;application/x-oleobject&quot;&gt;&nbsp; &nbsp; &lt;PARAM NAME=&quot;FileName&quot; VALUE=&quot;[B][COLOR=&quot;Red&quot;]&lt;?php print($playfile);?&gt;[/COLOR][/B]&quot;&gt;&nbsp; &nbsp; &lt;PARAM name=&quot;autostart&quot; VALUE=&quot;false&quot;&gt;&nbsp; &nbsp; &lt;PARAM name=&quot;ShowControls&quot; VALUE=&quot;true&quot;&gt;&nbsp; &nbsp; &lt;param name=&quot;ShowStatusBar&quot; value=&quot;false&quot;&gt;&nbsp; &nbsp; &lt;PARAM name=&quot;ShowDisplay&quot; VALUE=&quot;false&quot;&gt;&nbsp; &nbsp; &lt;EMBED TYPE=&quot;application/x-mplayer2&quot; SRC=&quot;[B][COLOR=&quot;red&quot;]&lt;?php print($playfile);?&gt;[/COLOR][/B]&quot; NAME=&quot;MediaPlayer&quot;WIDTH=&quot;400&quot; HEIGHT=&quot;389&quot; ShowControls=&quot;1&quot; ShowStatusBar=&quot;0&quot; ShowDisplay=&quot;0&quot; autostart=&quot;0&quot;&gt; &lt;/EMBED&gt;&nbsp; &lt;/OBJECT&gt;&nbsp; &lt;br&gt;[U]&lt;p&gt;&lt;a href=&quot;video.php?video=1&quot;&gt;Video 1&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;video.php?video=2&quot;&gt;Video 2 &lt;/a&gt;&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;video.php?video=3&quot;&gt;Video 3 &lt;/a&gt;&lt;/p&gt;[/U]&lt;/body&gt;&lt;/html&gt;[/CODE]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&nbsp; that variable in the wmv playersfile url code to view the video thats all !!!<img src="/styles/default/xenforo/smilies/default/happy.gif"&nbsp; class="smilie" loading="lazy" alt=":)" title="Happy&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="3.5G, post: 5529644, member: 158943"] [b]try and see[/b] [PHP] <?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); } ?> [/PHP] [CODE] <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="[B][COLOR="Red"]<?php print($playfile);?>[/COLOR][/B]"> <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="[B][COLOR="red"]<?php print($playfile);?>[/COLOR][/B]" NAME="MediaPlayer" WIDTH="400" HEIGHT="389" ShowControls="1" ShowStatusBar="0" ShowDisplay="0" autostart="0"> </EMBED> </OBJECT> [U]<a href="video.php?video=1">Video 1</a> <a href="video.php?video=2">Video 2 </a> <a href="video.php?video=3">Video 3 </a>[/U] </body> </html> [/CODE] [FONT="Trebuchet MS"][SIZE="4"] [B]CODE EXPLANATION [/B] 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 !!!:)[/SIZE][/FONT] [/QUOTE]

Verification

Dawasata paya keeyak thibeda?

Search

Latest ads

Reply to thread