Buongiorno e ben ritrovati come posso aggiornare anche la tabella message quando un utente cambia la foto profilo vorrei che aggiorni anche la la tabella message
Codice:
<?php
// Include the database configuration file
include_once 'conn.php';
$statusMsg = '';
// File upload directory
$targetDir = "image/";
$email = $_SESSION['email'];
if(isset($_POST["submit"])){
if(!empty($_FILES["image"]["name"])){
$fileName = basename($_FILES["image"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
// Allow certain file formats
$allowTypes = array('jpg','png','jpeg','gif');
if(in_array($fileType, $allowTypes)){
// Upload file to server
if(move_uploaded_file($_FILES["image"]["tmp_name"], $targetFilePath)){
// Insert image file name into database
$insert = $conn->query("UPDATE user SET image='$fileName' WHERE email='$email'");
$insert = $conn->query("UPDATE message SET image='$fileName' WHERE email='$email'");
if($insert){
$statusMsg = "The file ".$fileName. " has been uploaded successfully.";
header("Location: profilo2.php");
}else{
$statusMsg = "File upload failed, please try again.";
}
}else{
$statusMsg = "Sorry, there was an error uploading your file.";
}
}else{
$statusMsg = 'Sorry, only JPG, JPEG, PNG, & GIF files are allowed to upload.';
}
}else{
$statusMsg = 'Please select a file to upload.';
}
}
// Display status message
echo $statusMsg;
?>
Ultima modifica: