sql hyperlink execution

[Anon]

is there a way (or a source of information someone knows about) to place hyperlinks into an sql database, in such a way that by selecting that particular row and field, the hyperlink will execute?

For example, if i havea table (we'll call it BOB with three fields, Name, Color, and File, where Name is the person's name, color is their color, and file is a hyperlink to the location of their file, is there a way to select (file) from BOB where name = (name) AND color= (color)

and have it execute the hyperlink, and therefore download the file?

Thanks for your help!

[[deleted]]

What exactly do you want to do? How can you 'execute' a hyperlink? it's a location, not a script.

You can select the 'file' data from the database and redirect the user to that location. Then if that location is a file, the client can download that file.

[Anon]

Let me see if I can be a bit clearer. I've been reading a tutorial about how to access images, which are stored on your server, as part of a query on the database...
http://www.devshed.com/Server_Side/PHP/User/
The tutorial is incomplete, however, and I just wondered how you would access the file... if i can figure out how they did it with images, i think i could do the same with another type of file....

[Anon]

If you pull the link out of the FILE field from your database, and do a header redirect to that location, and the file is a type that the browser can't render (i.e. zip files), it will automagically prompt the user to download it.

[[deleted]]

Isn't that sort of exactly what I said? :-)

[Anon]

hi,

i think this is what u want :-

$sql="select file from BOB where name='name' AND color='color'";

$res=mysql_query($sql);

$row=mysql_fetch_array($res);

print "<a href=\"$row[file]\">".$row[file]."</a>";

with above code a hyperlink will be created for the name of the file and clicking on it will redirect the user to that file and if that file is not recognised by the browser , it will ask the user to download that file.

vishwa vivek

[Anon]

Ok, you guys are awesome for helping me out, still getting errors though...
Am I maybe setting up my database incorrectly? Right now the value in FileName is just the name of the file; should it instead be a full address?

here's my code:

--password.php--
<?php
$connection= @mysql_connect ("localhost", "username", "password");
if (!$connection) {
echo( "<P>Unable to connect to " .
"database server at this time.</P>" );
exit();
}

mysql_select_db("database", $connection);
if (! @mysql_select_db("database") ) {
echo( "<P>Unable to locate information " .
"database at this time.</P>" );
exit();
}

$sql="SELECT FileName
FROM ClientCP
WHERE ClientID=$ClientID
AND Password=$Password";

$result=mysql_query($sql);

$row=mysql_fetch_array($result);

print "<a href=\"$row[FileName]\">".$row[FileName]."</a>";

?>

and here's the error:
Warning: Supplied argument is not a valid MySQL result resource in /this/site/password.php on line 23

[Anon]

GOT IT! Thank you guys!

Here's my code, if you're looking for the solution I found...

<?php
$connection= connect, etc.

select database, etc.

$sql="SELECT FileName
FROM ClientCP
WHERE ClientID='$ClientID'
AND Password='$Password'";

$result=mysql_query($sql);

$row=mysql_fetch_array($result);

print "<a href=\"$row[FileName]\">".$row[FileName]."</a>";

?>

[[deleted]]

Just one small change I would suggest:

...
AND Password='$Password'";

if (!$result=mysql_query($sql))
{
echo 'SQL error: '.mysql_error();
}
else
{
$row=mysql_fetch_array($result);
...
}