I Dont know why its not going through and it keeps saying
File is not accessible. when i want to see test.php
File: see.php
<?php
$dbhost = 'localhost';
$dbuser = 'MyUserName';
$dbpass = 'MyPassWord';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'example';
mysql_select_db($dbname);
$sSecretCode = 232323;
$sFileName = 'test.php';
$iValidSecs = '30';
if (mysql_query("INSERT INTO tblCodes SET code='$sSecretCode',
filename='$sFileName',expires=(NOW() + $iValidSecs)")) {
// Code was added to database
$sLink = "http://anoluck.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()");
?>
File: file.php
<?php
$dbhost = 'localhost';
$dbuser = 'MyUserName';
$dbpass = 'MyPassWord';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'example';
mysql_select_db($dbname);
$c = $HTTP_GET_VARS["c"];
$n = $HTTP_GET_VARS["n"];
// 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://anoluck.com/filedir/" . addslashes($n));
} else {
echo "File is not accessible.";
}
} else {
echo "Error attempting to access file.";
}
?>