Ecco la tabella..
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)
)
E lo 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_binario"]["tmp_name"];
// CONNESSIONE AL MYSQL
$db = mysql_connect("localhost", "tramoman", "XXX") 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"]));
// ESEGUIAMO LA QUERY DI INSERIMENTO
$result = @mysql_query("INSERT INTO images5 (filebinario1, name1, size1, type1) VALUES ('$data1','" . $_FILES["file_binario1"]["name"] . "','" . $_FILES["file_binario1"]["size"] . "','" . $_FILES["file_binario1"]["type"] . "')") or die("Query failed !");
echo $result;
}
// 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>
<td colspan=\"2\" valign=\"bottom\" align=\"center\" height=\"30\">
<input type=\"submit\" value=\"Submit\" name=\"submit\"></td>
</tr>
</form>
</table>
</div>
</body>
</html>
";
}
?>
ci sto perdendo una giornata...
mi dice: Query failed !
PErche'??? Sembra tutto ok. L'ho controllato 3 volte...nulla.
PLEASE SPOT THE MISTAKE!
Cheers
M
Rispondi quotando
