Per favore aiuto... non so più cosa provare...
Ho questo html nel file a.php
Codice PHP:
<form name="dataEntry" id="dataEntry" method="POST" enctype="multipart/form-data" action="<? echo "ins.php"; ?>">
<table>
<tr>
<td class="label"><label id="linfo" for="info">Order</label></td>
<td class="label"><input type="file" name="info" id="info"></td>
<td class="status"></td>
</tr>
<input type=submit value=Add><input type=reset value=Clear>
</form>
poi in ins.php ho:
Codice PHP:
if ($_FILES["info"]["error"] = 0){
$temp_file = $_FILES['info']['tmp_name'];
$name_file = $_FILES['info']['name'];
$type_file = $_FILES['info']['type'];
$size_file = $_FILES['info']['size'];
$fp = fopen($temp_file, 'r');
$content_info = fread($fp, filesize($temp_file));
$content_info = addslashes($content_info);
fclose($fp);
$name_file = addslashes($name_file);
}
mysql_query("INSERT INTO supplies (date, order, nameorder, typeorder, sizeorder, companies_idcompanies) VALUES ('$date','$content_info','$name_file','$type_file','$size_file','$companies_idcompanies')")or die("Insert Error: ".mysql_error());
Premetto che riesco a caricare allo stesso modo un file in un altra pagina simile del sito.
In questa però non riesco a capire perchè mi da questo errore:
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 'order, nameorder, typeorder, sizeorder, companies_idcompanies) VALUES ('2009-09-' at line 1