Ciao,
sto provando a usare questo script per uploadare immagini e files.
Lo uso in locale, non sul sito.
Ho creato un database con table binary_data (Database mydb - table binary_data running on localhost). Tutto ok.
quando lancio lo script non fa l'upload dei file nel database. Non so perche'. Mi chiedevo anche dove salvava i files perche' non esiste un settaggio di directory.
Mi aiutate per favore?
<html>
<head><title>Store binary data into SQL Database</title></head>
<body>
<?php
// code that will be executed if the form has been submitted:
if ($submit) {
// connect to the database
// (you may have to adjust the hostname,username or password)
$db= MYSQL_CONNECT("localhost","root");
mysql_select_db("mydb",$db);
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
"VALUES ('$form_description','$data','$form_data_name','$f orm_data_size','$form_data_type')");
$id= mysql_insert_id();
print "
This file has the following Database ID: $id";
MYSQL_CLOSE();
} else {
// else show the form to submit new data:
?>
<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:
<input type="text" name="form_description" size="40">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
File to upload/store in database:
<input type="file" name="form_data" size="40">
<input type="submit" name="submit" value="submit">
</form>
<?php
}
?>
</body>
</html>