May 18th, 2002, 12:51 PM
|
|
Registered User
|
|
Join Date: May 2002
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Upload and Download with PHP & MSSql
i have some problems with that operation
these are my steps:
First i put the uploaded file into the required table
PHP Code:
function clean($input, $maxlength)
{
$input = substr($input, 0, $maxlength);
$input = EscapeShellCmd($input);
return ($input);
}
$short = clean($short, 500);
$userfile = clean($userfile, 500);
$file = fopen($userfile, "r");
$fileContents = fread($file, filesize($userfile));
$fileContents = AddSlashes($fileContents);
$connection = mssql_connect("localhost","Administrator","bubu");
$db = mssql_select_db("OTTManagement", $connection) or die("Couldn't select database OTTManagement.");
$insertQuery = "INSERT INTO files(f_name,f_file) VALUES ('$short',\"$fileContents\")";
$insertQuery_query = mssql_query($insertQuery,$connection) or die ("Couldn't that file ");
$qqq="select id_file,f_name,f_file from files";
$qqq_q= mssql_query($qqq,$connection);
while($data = @ mssql_fetch_array($qqq_q)){
$id = $data["id_file"];
$ee= $data["f_file"];
$ff= $data["f_name"];
echo "<a href=\"get_file.php?id=$id\">$ff</a><br>";
}
After that i want to downlod that file like this :
getfile.php
PHP Code:
$connection = mssql_connect("localhost","Administrator","bubu");
$db = mssql_select_db("OTTManagement", $connection) or die("Couldn't select database OTTManagement.");
$qqq="select f_name,f_file from files where id_file=$id";
$qqq_q= mssql_query($qqq,$connection);
$data = @ mssql_fetch_array($qqq_q);
$fname=$data["f_name"];
header("Content-type: application/octet-stream\n");
header ("Content-Disposition: attachment; filename=$fname");
header("Cache-control: must-revalidate\n");
header("Content-Description: PHP Generated Data");
echo $data["f_file"];
but for example if i will upload a file with size of 108 the file that i will download will have 134, and is not the same file.(I've tried with a gif file )
What is wrong ?
ps. in my MSSQL table field f_file have data_type image
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
