Pulling filename from the database

jennifer_ann

Could someone direct me to a link or tutorial page or SOMETHING that might be able to help me? I need to pull a filename from the database, but it is to be "hidden" from the viewers. I want to use a button and that button when clicked on is going to go to another page which will be considered a display page. I'd like to get the file to automatically open/play when that button is clicked on. Here is what I've got so far.

<html>
<head>
	<title>Eye Contact - Century to Century</title>
	<link rel="stylesheet" href="eye01.css" type="text/css" />

</head>
<body>
<form name ="" method = "post" action="">
<?php
print "<table align = 'center' width='50%' border='1' height = '90%'>";
$db = mysql_connect("localhost","root","");
if (!$db)
{
		print "error - Could not connect to MySQL";
		exit;
}

$er = mysql_select_db("touch_art1");
if(!$er)
{
	print "error - Could not select the database";
		exit;	
}

extract($_POST);

$query = "SELECT date, filename FROM comment WHERE pamapproved = 'y' ORDER BY date";
$result = mysql_query($query);

if(!$result)
{
	print "Error on Query";
	exit;
}	
else
{
	print "<tr height = '15%'>";
	print "<th class='theader'>Date</th>";
	print "<th class='theader'>Filename</th></tr>";

while($column = mysql_fetch_object($result))
{

	print "<tr height = '15%'>";
	foreach($column as $colval)
	{
		print "<td class='tdata'>$colval</td>";
	}
	print "</tr>";
}
print "</table>";
}	

mysql_free_result($result);

mysql_close();
?>

Everything here works, but I need to figure out how to get the file to automatically play. Any help would be great.

Oni

I'm pretty sure that its impossible to hide a source link from the users because the browser needs to see it in order to play it. So the user will see it as well. (I'm pretty sure this is the case)

So you'll have to make a link that keeps changing so that a user couldn't give the source link to other users...

jennifer_ann

Ok so lets say I allow them to see the link.
When they query what they want to see, lets say they wanna see peoples video testimonials from england. They will do the drop boxes that will query that and bring up the video's information. (where the person was originally from, where they live now, ect ect). The file is named with a timestamp. So when the person clicks the timestamp, I need that to direct them to another page that will automatically play the video.

jennifer_ann

I have the filename with the timestamp displaying on the page. I just need to figure out a way to get it to redirect to the different page and play.

jennifer_ann

I mean this would technically hide it right?

Houdini

You could try using javascript since there is already output like this

<script type=\"text/javascript\">window.location=\"aFileName.ext\"</script>"

jennifer_ann

Yes but that wont direct me to another page and automatically play my file will it?

Houdini

If you just put the file name in it should play it, not really sure though I use it for a redirect, but it will go to that file even if it is not a page without the user doing anything.

Blulagoon

Couldn't you use the header() function to redirect to a page that had Houdini's excellent piece of javascript code in it which then played the file. That way when they clicked play you could pass the name of the file via $_POST so the javascript always retrieved the correct file.

The video/audio files themselves could be in a separate directory, protected by an .htaccess file that denied browser access, so even if people knew the path to the video files it wouldn't do them any good.

HTH - Blu

Houdini

If you look at the code she has she can't use a header because there is HTML from the start of the page and the header() will fail.

Blulagoon

Ahhh, didn't look at the code that closely. Include or Require followed by exit() might do the trick ?

Blu