Grazie, funziona con un file. Ma se inserisco piu' files secondo questa tabella mi da ancora errori..
CREATE TABLE images4 (
Id int(4) NOT NULL auto_increment,
file_binario1 mediumblob NOT NULL,name1 varchar(50) NOT NULL default '',size1 int(10) NOT NULL default '0',
type1 varchar(50) NOT NULL default '',
file_binario2 mediumblob NOT NULL,name2 varchar(50) NOT NULL default '',size2 int(10) NOT NULL default '0',
type2 varchar(50) NOT NULL default '',
file_binario3 mediumblob NOT NULL,name3 varchar(50) NOT NULL default '',size3 int(10) NOT NULL default '0',
type3 varchar(50) NOT NULL default '',
file_binario4 mediumblob NOT NULL,name4 varchar(50) NOT NULL default '',size4 int(10) NOT NULL default '0',
type4 varchar(50) NOT NULL default '',
PRIMARY KEY (Id)
)
************************************************** ************8
SCRIPT:
<?php
if(!isset($_POST)) $_POST = $HTTP_POST_VARS;
$self = isset($_SERVER) ? $_SERVER["PHP_SELF"] : $HTTP_SERVER_VARS["PHP_SELF"];
if($_POST["submit"]) {
$image_types = Array ("image/bmp",
"image/jpeg",
"image/pjpeg",
"image/gif",
"image/x-png");
$myfile = $_FILES["file_binario1"]["tmp_name"];
// CONNESSIONE AL MYSQL
$db = mysql_connect("localhost", "tramoman", "XX") or die("Impossible to connect to the database. Please, Try later !");
// SELEZIONE DATABASE
mysql_select_db("mydb",$db) or die("Impossible to select the DB !");
if (in_array (strtolower ($_FILES["file_binario1"]["type"]), $image_types)){
// MEMORIZZIAMO NELLA VARIABILE $data IL CONTENUTO DEL FILE
$data1 = addslashes(fread(fopen($_FILES["file_binario1"]["tmp_name"], "rb"), $_FILES["file_binario1"]["size"]));
$data2 = addslashes(fread(fopen($_FILES["file_binario2"]["tmp_name"], "rb"), $_FILES["file_binario2"]["size"]));
$data3 = addslashes(fread(fopen($_FILES["file_binario3"]["tmp_name"], "rb"), $_FILES["file_binario3"]["size"]));
$data4 = addslashes(fread(fopen($_FILES["file_binario4"]["tmp_name"], "rb"), $_FILES["file_binario4"]["size"]));
// ESEGUIAMO LA QUERY DI INSERIMENTO
$result = mysql_query("INSERT INTO images4 (file_binario1, name1, size1, type1, file_binario2, name2, size2, type2, file_binario3, name3, size3, type3, file_binario4, name4, size4, type4) VALUES ('$data1','" . $_FILES["file_binario1"]["name"] . "','" . $_FILES["file_binario1"]["size"] . "','" . $_FILES["file_binario1"]["type"] . "','$data2','" . $_FILES["file_binario2"]["name"] . "','" . $_FILES["file_binario2"]["size"] . "','" . $_FILES["file_binario2"]["type"] . "','$data3','" . $_FILES["file_binario3"]["name"] . "','" . $_FILES["file_binario3"]["size"] . "','" . $_FILES["file_binario3"]["type"] . "','$data4','" . $_FILES["file_binario4"]["name"] . "','" . $_FILES["file_binario4"]["size"] . "','" . $_FILES["file_binario4"]["type"] . "')") or or die(mysql_error());
}
// ESITO POSITIVO
echo "The files:
";
echo " " . basename($_FILES["file_binario1"]["name"]) . "
";
echo "have been uploaded to the database! Thanks!";
// CHIUDIAMO LA CONNESSIONE A MYSQL
@mysql_close();
} else {
echo "
<html>
<head>
</head>
<body>
<div align=\"center\">
<table>
<form action=\"$self\" method=\"POST\" enctype=\"multipart/form-data\">
<tr>
<td>File</td>
<td><input type=\"file\" name=\"file_binario1\" size=\"40\"></td>
</tr>
<tr>
<td>File</td>
<td><input type=\"file\" name=\"file_binario2\" size=\"40\"></td>
</tr>
<tr>
<td>File</td>
<td><input type=\"file\" name=\"file_binario3\" size=\"40\"></td>
</tr>
<tr>
<td>File</td>
<td><input type=\"file\" name=\"file_binario4\" size=\"40\"></td>
</tr>
<td colspan=\"2\" valign=\"bottom\" align=\"center\" height=\"30\">
<input type=\"submit\" value=\"Submit\" name=\"submit\"></td>
</tr>
</form>
</table>
</div>
</body>
</html>
";
}
?>
Che errore e' alla QUERY di inserimento:
Parse error: parse error, unexpected T_LOGICAL_OR in /home/httpd/vhosts/esoterism.it/httpdocs/PHP/formfree4.php on line 55
Grazie ancora BONAPROGRAM!
M