ho provato....nel database ho il file inserito,nella cartella anche, ma nel sito non mi stampa i record...
<style>
.ProgressBar{width:200px;height:30px;border:#0FA01 5 1px solid;border-radius:4px;max-width:80%;display:block;margin:auto;position:relat ive;background:#555;padding:3px 1px;box-shadow:inset 0 -1px 1px rgba(255,255,255,0.3);}
#ColorBar{display:block;width:0px;height:100%;back ground-color:#12CC1A;position:relative;overflow:hidden;fo nt-size:15px;text-align:center;color:white;transition:all 700ms ease;line-height:1.8;}
.btnSubmit{background-color:#09f;display:block;margin:auto;margin-top:20px;border:none;border-radius:4px;border:1px solid #ccc;box-shadow:1px 1px 10px rgba(0,0,0,0.2);padding:10px 40px;cursor:pointer;color:#FFF;}
.btnSubmit:active{background-color:#12CC1A;}
</style>
<div style="position:absolute;margin:30px 0px;">
<form action="/upload-italia3.php" method="post" enctype="multipart/form-data">
<input name="file" id="file"type="file"style="color:#666666;">
<input type="submit" id="btnSubmit" value="Submit" class="btnSubmit" onclick="AnimateBar()"><br>
<div class="ProgressBar">
<span style="width: 0%;" id="ColorBar">0%</span>
</div>
</div>
<script>
function AnimateBar() {
var elem = document.getElementById("ColorBar");
var stepValue = 0;
var id = setInterval(frame, 500);
function frame(){
if(stepValue >= 100) {
clearInterval(id);
document.getElementById("LoadContent").style.visib ility = "visible";
}else {
elem.style.width = stepValue + 10 + "%";
elem.innerHTML = stepValue + 10 + "%";
stepValue = stepValue + 10;
}
if(stepValue < 100){
document.getElementById("LoadContent").style.visib ility = "hidden";
}
}
}
</script>
Codice PHP:
<div style="visibility:hidden;" id="LoadContent">
<center>
<?php
$servername = "localhost";
$username = "noncecapisco";
$password = "";
$dbname = "my_noncecapisco";
$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT *FROM Animali ORDER BY id DESC ";
$result = $conn->query($sql);
$array_estensioni_poster= array('webm','mkv','ogg','3gp');
$array_estensioni_video= array('mp4');
$array_estensioni_immagini = array('jpg','jpeg','gif','tiff');
while ($row = $result->fetch_assoc()) {
$estensione = pathinfo($row["file"], PATHINFO_EXTENSION);
if(in_array($estensione, $array_estensioni_immagini))
{
echo' <div style ="margin-left:390px;width:450px;word-wrap:break-word;color:#666666;margin-top:-35px;margin-bottom:-5px;">'.$row["nome"].' </div><br>'.PHP_EOL;
echo "<img src ='".$row["file"]."'style='width:450px;height:auto;margin-left:390px;margin-top:-25px;'><br>".PHP_EOL;
}
else if(in_array($estensione, $array_estensioni_video))
{
echo' <style ="margin-left:390px;width:450px;word-wrap:break-word;color:#666666;margin-top:5px;margin-bottom:-10px;">'.$row["nome"].' </div><br>'.PHP_EOL;
echo "<video preload='auto' src='".$row["file"]."'controls='true' position='fixed'style='width:450px;height:auto;margin-left:392px;margin-top:-25px;border-radius:5px;'></video><br>".PHP_EOL;
}
else if(in_array($estensione, $array_estensioni_poster))
{
echo' <div style ="margin-left:390px;width:450px;word-wrap:break-word;color:#666666;margin-top:5px;margin-bottom:-5px;">'.$row["nome"].' </div><br>'.PHP_EOL;
echo "<video poster='video-google-drive1.jpg'src='".$row["file"]."'controls='true' position='fixed'style='width:450px;height:auto;margin-left:390px;margin-top:-30px;border-radius:px; border: 1px solid #CCCCCC;
'></video><br>".PHP_EOL;
}
echo' <div style="margin-left:390px;width:450px;word-wrap:break-word;color:#666666;margin-top:5px;margin-bottom:140px;">'.$row["testo"].'</div><br>'.PHP_EOL;
}
?>
</center>
</div>
Codice PHP:
upload-italia3.php
<?php
$file_salvato = rand(1, 100000000).'.'.pathinfo($_FILES["file"]["name"], PATHINFO_EXTENSION);
$nomefile = ($file_salvato);
move_uploaded_file($_FILES["file"]["tmp_name"], "animali/".$file_salvato);
$dati = $_POST['testo'];
$file = $_POST['file'];
$email = $_POST['email'];
$nome = $_POST['nome'];
$db_host = 'localhost';
$db_user = 'noncecapisco';
$db_pass = '';
$db_name = 'my_noncecapisco';
$cn = new mysqli($db_host, $db_user, $db_pass, $db_name);
if ($cn->connect_errno) {
echo "Connessione fallita: ". $cn->connect_error . ".";
exit();
}
$sql = "INSERT INTO Animali (testo, file , nome , email ) VALUES ("
. "'" . $dati. "',"
. "'" . $nomefile. "',"
. "'" . $nome. "',"
. "'" . $email. "');";
$last_insert_id = $conn->insert_id;
if (!$cn->query($sql)) {
echo "Errore della query: " . $cn->error . ".";
}
header("location:http://noncecapisco.altervista.org/animali/NuovoFile.php");
?>