salve ragazzi posto questo script trovato sulla rete, ed adattato alle mie esigenze
Codice PHP:
$id_utenti = $_REQUEST["enti"];
$query = "SELECT * FROM enti WHERE id_utenti = ".$id_utenti;
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0)
{
$enti = mysql_fetch_assoc($result);
if ($_SESSION["tipo"] == "enti")
{
if($_SESSION["id"] <> $id_utenti)
{
header("location:lista.php");
}
}
}
else
{
header("location:lista.php");
}
include "header.php";
?>
<script type="text/javascript">
function _(el)
{
return document.getElementById(el);
}
function uploadFile()
{
// Variabili associate ai campi del modulo
var note = document.upload_form.note_ente.value;
var commessa = document.upload_form.commessa.value;
var file = document.upload_form.file1.value;
if (commessa == "")
{
alert("Il campo commessa è obbligatorio.");
document.upload_form.commessa.focus();
return false;
}
else if (file == "")
{
alert("Il campo file è obbligatorio.");
document.upload_form.file1.focus();
return false;
}
else if (note == "") {
alert("Il campo Note è obbligatorio.");
document.upload_form.note_ente.focus();
return false;
}
//INVIA IL MODULO
else
{
var file = _("file1").files[0];
//alert(file.name+" | "+file.size+" | "+file.type);
var formdata = new FormData();
formdata.append("file1", file);
var ajax = new XMLHttpRequest();
ajax.upload.addEventListener("progress", progressHandler, false);
ajax.addEventListener("load", completeHandler, false);
ajax.addEventListener("error", errorHandler, false);
ajax.addEventListener("abort", abortHandler, false);
ajax.open("POST", "upload_ins.php?enti=<?=$id_utenti?>");
ajax.send(formdata);
}
}
function progressHandler(event)
{
_("loaded_n_total").innerHTML = "Uploaded "+event.loaded+" bytes of "+event.total;
var percent = (event.loaded / event.total) * 100;
_("progressBar").value = Math.round(percent);
_("status").innerHTML = Math.round(percent)+"% uploaded... please wait";
}
function completeHandler(event)
{
_("status").innerHTML = event.target.responseText;
_("progressBar").value = 0;
}
function errorHandler(event)
{
_("status").innerHTML = "Upload Failed";
}
function abortHandler(event)
{
_("status").innerHTML = "Upload Aborted";
}
function clearform()
{
document.upload_form.note_ente.value = '';
document.upload_form.commessa.value = '';
document.upload_form.file1.value = '';
}
</script>
<body bgcolor="#FFFFFF">
<div class="container">
<div class="content">
<div class="content-wrapper">
<br/>
<div class="small-left">
<div class="box-left">
<h3>scheda ente</h3>
<p style="width:100px"><strong><?=$enti["tipo_ente"]?> <?=$enti["citta"]?></strong></p>
<p style="width:100px"><strong><?=$enti["user"]?></strong></p>
<p style="width:100px"><strong><?=$enti["nome"]?> <?=$enti["cognome"]?></strong></p>
<p style="width:100px">e-mail <? ($enti["email"]) ? print "<a href=\"mailto:".$enti["email"]."\">".$enti["email"]."</a>" : print "-----";?></p>
<ul class="menu">
<?
if ($_SESSION["tipo"] <> "enti") {
?>
<li><a href="upload.php?enti=<?=$id_utenti?>">Ricezione</a></li>
<li class="active"><a href="download.php?enti=<?=$id_utenti?>">Invio</a></li>
<li class="active"><a href="stampa.php?enti=<?=$id_utenti?>">Processi in corso</a></li>
<li class="active"><a href="mail.php?enti=<?=$id_utenti?>">invia mail</a></li>
<?
}
else
{
?>
<li><a href="upload.php?enti=<?=$id_utenti?>">Invio</a></li>
<li class="active"><a href="download.php?enti=<?=$id_utenti?>">Ricezione</a></li>
<li class="active"><a href="stampa.php?enti=<?=$id_utenti?>">Processi in corso</a></li>
<li class="active"><a href="mail_tipografia.php">invia mail</a></li>
<?
}
?>
</ul>
</div>
</div>
<div class="big-last">
<?
if ($_SESSION["tipo"] <> "tipografia")
{
?>
<!--target="progressFrame"-->
<!--
<form action="upload_upl.php" class="insert" method="post" id="upload_form" name="upload_form" enctype="multipart/form-data" onSubmit="return Modulo();">-->
<form class="insert" method="post" id="upload_form" name="upload_form" enctype="multipart/form-data">
<fieldset> <!-- VEDERE BARRA-->
<h4>Dettagli nuovo file</h4>
<div class="item">
<label for="commessa">Commessa<em>*</em></label>
<input type="text" class="w300" name="commessa" />
</div>
<div class="item">
<label for="file1">File</label></td>
<!--<input type="file" class="w300" name="file1" id="file1" />-->
<input class="w300" type="file" name="file1" id="file1"><br><br>
</div>
<div class="item">
<progress id="progressBar" value="0" max="100" style="width:300px;"></progress>
<h3 id="status"></h3>
<p id="loaded_n_total"></p>
</div>
</fieldset>
<fieldset>
<h4>note</h4>
<div class="item">
<label for="note_ente">note <em>*</em></label>
<textarea name="note_ente" class="input w400"></textarea>
</div>
<div class="itembutton">
<input class="button" type="button" value="annulla" onClick="clearform()";" />
</div>
<div class="itembutton">
<input type="hidden" name="enti" value="<?=$id_utenti?>" />
<input class="button" type="button" value="Upload File" onClick="uploadFile()">
</div>
</fieldset>
</form>
<br /><br />
<?
}
?>
</div>
<br class="clear" />
</div>
questo è l'altro file
Codice PHP:
$commessa = $_POST["commessa"];
$id_utenti = $_POST["id_utenti"];
$query = "SELECT * FROM enti WHERE id_utenti = ".$id_utenti;
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0)
{
$ente = mysql_fetch_assoc($result);
$user= $ente["user"];
}
$note_ente = $_POST["note_ente"];
$fileName = $_FILES["file1"]["name"]; // The file name
$fileTmpLoc = $_FILES["file1"]["tmp_name"]; // File in the PHP tmp folder
$fileType = $_FILES["file1"]["type"]; // The type of file it is
$fileSize = $_FILES["file1"]["size"]; // File size in bytes
$fileErrorMsg = $_FILES["file1"]["error"]; // 0 for false... and 1 for true
if (!$fileTmpLoc) { // if file not chosen
echo "ERROR: Please browse for a file before clicking the upload button.";
exit();
}
if(move_uploaded_file($fileTmpLoc, "materiale/$fileName")){
echo "$fileName upload is complete";
$date = mktime();
$id_utenti = $_POST["id_utenti"];
$query = "INSERT INTO upload_file (id_utenti, commessa, file, data_inserimento_ente, note_ente) VALUES ('".$id_utenti."', '".$commessa."','".$_FILES["file1"]["name"]."',(FROM_UNIXTIME(".$date.")), '".$note_ente."')";
mysql_query($query) or die(mysql_error());
$query = "SELECT * FROM tipografia";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) > 0)
{
$tipografia = mysql_fetch_assoc($result);
}
else
{
header("location:lista.php");
}
mysql_free_result($result);
$name = $_FILES["file1"]["name"];
} else
{
echo "move_uploaded_file function failed";
}
in pratica carico il file fa l'upload,il file lo scarica nella cartella desiderata,ma quando si tratta di memorizzare,mi restituisce un errore nella query, come se perdesse id_utente
saluti
Rispondi quotando