You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\0JFIF\0\0\0\0\0\0\0;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality ' at line 1
cosa vuol dire sta roba??
vi posto il codice:
Codice PHP:<?php
include("config.inc.php");
/*Select dell' ultimo id +1 come nuovo nome del file*/
$new_name_query = "SELECT * FROM uploaded_files";
mysql_query($new_name_query)
or die (mysql_error ());
$affected_rows = mysql_affected_rows($conn);
/*Uploaded files directory*/
$upload_dir = $_SERVER['DOCUMENT_ROOT'] . "/Upload/up_files";
/*New name uploaded file*/
$new_name = $affected_rows +1;
/*new_name = "" => new_name = up_file_name*/
$file_name = ($new_name) ? $new_name : $_FILES["upfile"]["name"];
/*Allowed files*/
$allowed_types = array("image/gif", "image/x-png", "image/pjpeg", "image/jpeg");
if(is_uploaded_file($_FILES["upfile"]["tmp_name"]))
{
if(!in_array($_FILES["upfile"]["type"], $allowed_types))
{
echo "Il file non di tipo consentito! I files ammessi sono: " . implode(", ", $allowed_types) . ".";
}
else
{
switch ($_FILES["upfile"]["error"])
{
case UPLOAD_ERR_OK:
/*Equivalente di copy()*/
@move_uploaded_file($_FILES["upfile"]["tmp_name"], "$upload_dir/$file_name")
or die ("Impossibile spostare il file");
/*echo "File inserito correttamente.";*/
$query = "INSERT INTO uploaded_files (fileBinario, file_name) VALUES ($data, $new_name)";
mysql_query($query)
or die (mysql_error ());
if(mysql_affected_rows > 0)
{
echo "File caricato correttamente";
}
else
{
echo "Errore durante l' inserimento nel database. Riprova.";
}
break;
case UPLOAD_ERR_INI_SIZE:
throw new exception("Il file che si tentato di caricare troppo grande!");
break;
case UPLOAD_ERR_FORM_SIZE:
throw new exception("Il file che si tentato di caricare troppo grande!");
break;
case UPLOAD_ERR_PARTIAL:
throw new exception("Il file stato caricato solo parzialmente. Riprova.");
break;
case UPLOAD_ERR_NO_FILE:
throw new exception("Non stato caricato alcun file!");
break;
case UPLOAD_ERR_NO_TMP_DIR:
throw new exception("Errore interno. È stata inviata una segnalazione automatica");
break;
case UPLOAD_ERR_CANT_WRITE:
throw new exception("Tentativo di scrittura del file fallito. Riprova.");
break;
default:
throw new exception("Errore sconosciuto.");
break;
}
}
}
else
{
echo "Errore nel caricamento";
}
mysql_close($conn);
?>
l' errore venuto fuori da quando ho aggiunto:
e:Codice PHP:/*Memorizzazione delle file_info per il db*/
$data = addslashes(fread(fopen($_FILES["upfile"]["tmp_name"], "rb"), $_FILES["upfile"]["size"]));
a cosa dovuto??Codice PHP:$query = "INSERT INTO uploaded_files (fileBinario, file_name) VALUES ($data, $new_name)";
mysql_query($query)
or die (mysql_error ());
if(mysql_affected_rows > 0)
{
echo "File caricato correttamente";
}
else
{
echo "Errore durante l' inserimento nel database. Riprova.";
}
Rispondi quotando
)
VVoVe: 
lW/{:VY`?)oZﴏ X9oK,7A!W} B GGzdᩣ^~bJOl6{\0ٷ a 8k0\0~U ^U,Rc뵱M3(\0( \0(qҜar**_!#h]~bPDtQEp(\0(GZq`NV 0q\0f>^)?OF\n9?*ʄ(38 CROQ4 әoZ*ݚS4oҚXw(\"ie; 5g[?\Zg?0\'ީX`\\569>l /V ŏqW$m\'Ջ{?9\nhXhHoM4C^v \\MDuacU\Z2S?wڳ{-G0Vc*yvEZvՖo$F$no#o,| K`m\'jjf;,P ?7M\\ I]6pc6HlUVczTrp6$)RCt̯?U u^v }YI&bcK vCn,TN jb|!qE[\0p٩Eи$owVZۊ5;TgjZH1L،cן MXEHFNߕ՛#Q\0c_-a5\\\rCfcmGQ˞v^H\'wjh +NK|$)+4wz.-eUln _j.o7EӼ7i\0j K \0\0ntS|z:[[oW.A?eU9V#kgNt]EWc /zZ(ET\0&wҜҘ\n\01\04HK.Nީ 3 1 inrʴ\0 <ĝ,MԬAUf +|3pԴ \\G%(9UYs0Wil\\$4C*e;_h^ @\0>^~n;r\0xzi n\0 PHA,x_JF*aIpdI\Zە{w[}̣pf@Ev$4TpP{\Z!3\Zڅmj9U (ݧ *\0yѰY \r_Zu!;~Sh[E&̱\0{[KQ#9@wjFl{5Co 2TR=5[cctoO TZ5|_
\04o\03y#0 MZ>Q/ d?ݩ<4$ ujB3@۞z\nǨ\"F`zRR\0>Z^yn @d_j qW;Kjp>諹-\ZvZz+ ]G[RV\" (% $Oq!V\n˟UjR;IW}}DC *2 _>I@²V\0J>FaG6 /&tR¦`Tl>\Z^FeԎ[~jG+(2nSk{L]j$\n/uRsxd_4<>|2n[ V;_3`0.߱\0ھ>ߔb}M/ 1J\"b-q?W 9y|_l7_2mRAG`WpC btGݍ5^ yghs{ooK\"\r_ydo-$ W 7|V~~O_Th&\0lz>!;ŜR>o*U KGu\'aW_jk֣!29\\ ՛-hMQdffԼ$?TR]Oʝ4dUc[Fw+p+ _j mm3ů?ݼ@ Yw)\\Up? Ju+z8_j).7nQ֥L7\rv%2 p(xN-E~sJ]V݀*E]ˌj.`8XJ t\02\0R- H)0_H#_ܫ`P?@_i gR\0jh_{P~cVc)`\0U.JʪT _V,!uej\0~l|SL ́+ O4V/Ws6Mwdܿ\nL붥d\\# 6a\0v\0tW- pcedYz2Vo&݉@U@HhCe#qG4o T UUڸ\Z uY[.?%\"6ncF!coj4eH<r X-HeaG O~jqOwb_`;ژ-[0G*\0vHu R_C1g>[s>^}M@PD6ާwL$E %iW\n ml3sBEY63d\r?=68_M&@C\Zx @ҹX0A-M\'k#\na Gi]u -ڋ\05E\rĖ\0V703I[BVy {i\Z_ Ql1|_Y_.P .K/vcj ,A}?z|C(Lv\0?[8mWkW ~ 4*_Uvl| \niM F2_9l|ڪÂWo Z0\\ĤE^_{iT0%/-t_طQͅλ4( OgNk?;bVo\Z fh;]>:;!/mc;&e*?4jS&~w -4Y_f?wS \0],>dm{{BZ}Nm87c |97 3/ms34DU8wpkh٫[^%&BJQռi7,EpF !x/!Q hnUݡUժ7]E ?j _Q]*Un `|w\nW\Z\\wQ Qy @ ,͜c~|To o![_]O~КI_=$8HlkEɌo@Y|k\' 747WP\"w _CڌI8e-MrsH5\'QY 9kqgy?r}k^?3W{b~ dH_3VJMѦͩŔ@|!$ucU c\0 _+OF͎]?ǹȢ||ީ~U~\0v\0PP/\0Z1~\0d\0 ]1M ևr_vWmO7\Z~4+1>m^?S ; ;\0jl7.X-zN~UR%N\n\0d\0{2\0y Dݫ~ q[Fګ\0}S
