Ciao a tutti, devo uplodare dei file pdf in un DB sqlserver 2000, ho qualche difficoltà nella fase finale dell'iserimento nel DB, l'esecusione mi da un errore che penso sia riferito al type.
Premetto di non essere un grande esperto di php, in mysql funziona perfettamente.
Per essere breve vi posto il codice qui sotto:

-----------html-----------------------
<html xmlns="http://www.w3.org/1999/xhtml">
<head
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Documento senza titolo</title>
<form method="post" enctype="multipart/form-data">
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246">
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile">
</td>
<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>

------------------php----------------------
<?php include 'index.ini.php';

if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'rb');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}

$datainsert = date("d/m/Y",strtotime ("now"));

print $fileName."
";
print $tmpName."
";
print $fileSize."
";
print $fileType."
";
print $content."
";

$query = "INSERT INTO tblFileListini (dtmData, sNomeFile, sTipoFile, sFile, nDimensione) ".
"VALUES ('$datainsert', '$fileName', '$fileType', '$content', '$fileSize')";

print $query."
";

mssql_query($query) or die('Error, query failed');


-------------------------errore------------------------ Il tipo file nel database è "image"
file.pdf
C:\Programmi\xampp\tmp\php53.tmp
98184
application/pdf
%PDF-1.4 %âãÏÓ 117 0 obj << /Linearized 1 /O 123 /H [ 6220 1121 ] /L 98184 /E 37838 /N 33 /T 95725 >> endobj xref 117 267 0000000016 00000 n 0000005692 00000 n 0000005920 00000 n 0000005995 00000 n 0000006146 00000 n 0000006194 00000 n 0000007341 00000 n 0000007735 00000 n 0000007819 00000 n 0000007951 00000 n 0000008045 00000 n 0000008160 00000 n 0000008224 00000 n 0000008336 00000 n 0000008400 00000 n 0000008508 00000 n 0000008572 00000 n 0000008681 00000 n 0000008745 00000 n 0000008860 00000 n 0000008924 00000 n 0000009069 00000 n 0000009133 00000 n 0000009206 00000 n 0000009365 00000 n 0000009429 00000 n 0000009516 00000 n 0000009603 00000 n 0000009764 00000 n 0000009828 00000 n 0000009996 00000 n 0000010060 00000 n 0000010148 00000 n 0000010236 00000 n 0000010300 00000 n 0000010364 00000 n 0000010453 00000 n 0000010542 00000 n 0000010718 00000 n 0000010782 00000 n 0000010846 00000 n 0000011015 00000 n 0000011103 00000 n 0000011190 00000 n 0000011254 00000 n 0000011358 00000 n 0000011422 00000 n 0000011524 00000 n 0000011588 00000 n 0000011689 00000 n 0000011794 00000 n 0000011858 00000 n 0000011922 00000 n 0000011986 00000 n 0000012072 00000 n 0000012158 00000 n 0000012324 00000 n 0000012388 00000 n 0000012475 00000 n 0000012563 00000 n 0000012710 00000 n 0000012774 00000 n 0000012838 00000 n 0000012992 00000 n 0000013078 00000 n 0000013165 00000 n 0000013229 00000 n 0000013331 00000 n 0000013433 00000 n 0000013497 00000 n 0000013561 00000 n 0000013663 00000 n 0000013727 00000 n 0000013833 00000 n 0000013897 00000 n 0000013961 00000 n 0000014025 00000 n 0000014181 00000 n 0000014267 00000 n 0000014353 00000 n 0000014417 00000 n 0000014519 00000 n 0000014583 00000 n 0000014647 00000 n 0000014711 00000 n 0000014876 00000 n 0000014963 00000 n 0000015048 00000 n 0000015112 00000 n 0000015176 00000 ...etc etc etc


Grazie 1000
Spero di essere stato chiaro.
Drk