June 30th, 2002, 09:55 AM
|
|
Contributing User
|
|
Join Date: Jun 2001
Location: Pittsburgh, PA
Posts: 54
Time spent in forums: < 1 sec
Reputation Power: 9
|
|
If you are willing to use a link something like "http://mydomain.com/file.php?c=12345&n=filename.zip", then you could try something like this:
Create a table in mySQL with the fields 'code' (varchar(xx) where 'xx' is the length of your secret code), 'filename' (varchar(yy) where 'yy' is the maximum length of a file's name), and 'expires' (DATETIME).
In the file that gives the link to the user:
PHP Code:
$sSecretCode = ... your 'random' number generating code ... ;
$sFileName = ... filename to be accessed ... ;
$iValidSecs = ... seconds that link should be valid ...
if (mysql_query("INSERT INTO tblCodes SET code='$sSecretCode',
filename='$sFileName',expires=(NOW() + $iValidSecs)")) {
// Code was added to database
$sLink = "http://mydomain.com/file.php?c=$sSecretCode&n=$sFileName";
echo "The link to the file is: <A HREF=\"$sLink\">$sLink</A>";
} else {
// Code was not added
echo "There was an error setting up your link.";
}
// Use this file access as a trigger to clean out tblCodes
$rslt = mysql_query("DELETE FROM tblCodes WHERE expires<NOW()");
In the file 'file.php':
PHP Code:
// Use this file access as a trigger to clean out tblCodes
$rslt = mysql_query("DELETE FROM tblCodes WHERE expires<NOW()");
$sSQL = "SELECT * FROM tblCodes WHERE code='" . addslashes($c)
. "' AND filename='" . addslashes($n) . "' AND expires>=NOW()";
if ($rslt = mysql_query($sSQL)) {
if (mysql_num_rows($rslt) > 0) {
// valid code for file
// DELETE CODE (allow only one access of the file)
$rslt = mysql_query("DELETE FROM tblCodes WHERE code='" . addslashes($c)
. "' AND filename='" . addslashes($n) . "'");
// Take the user to the file:
header("Location: http://mydomain.com/filedir/" . addslashes($n));
} else {
echo "File is not accessible.";
}
} else {
echo "Error attempting to access file.";
}
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
