Je ne trouve pas l'erreur (ou les erreurs) qui se trouvent dans mon code. En effet, l'entrée avatar ne s'effectue pas dans ma base de donnees .
Merci d'avance à ceux qui pourront m'aider. Voici mon code
Code : Tout sélectionner
<?php
session_start ();
$bdd = new PDO('mysql:host=localhost;dbname=bddpers','root','');
if(isset($_SESSION['id']))
{
$reqpersonne = $bdd->prepare("SELECT * FROM personnes WHERE id = ?");
$reqpersonne->execute(array($_SESSION['id']));
$user = $reqpersonne->fetch();
if (isset ($_POST['mettre']))
{
if(isset($_POST['newdatenais']) AND $_POST['newdatenais'] != $user['datenais']);
{
$newdatenais = htmlspecialchars($_POST['newdatenais']);
$insertdatenais = $bdd->prepare("UPDATE personnes SET datenais = ? WHERE id = ?");
$insertdatenais->execute(array($newdatenais, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newlieunais']) AND $_POST['newlieunais'] != $user['lieunais']);
{
$newlieunais = htmlspecialchars($_POST['newlieunais']);
$insertlieunais = $bdd->prepare("UPDATE personnes SET lieunais = ? WHERE id = ?");
$insertlieunais->execute(array($newlieunais, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newadresse']) AND $_POST['newadresse'] != $user['adresse']);
{
$newadresse = htmlspecialchars($_POST['newadresse']);
$insertadresse = $bdd->prepare("UPDATE personnes SET adresse = ? WHERE id = ?");
$insertadresse->execute(array($newadresse, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newcp']) AND $_POST['newcp'] != $user['cp']);
{
$newcp = htmlspecialchars($_POST['newcp']);
$insertcp = $bdd->prepare("UPDATE personnes SET cp = ? WHERE id = ?");
$insertcp->execute(array($newcp, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newville']) AND $_POST['newville'] != $user['ville']);
{
$newville = htmlspecialchars($_POST['newville']);
$insertville = $bdd->prepare("UPDATE personnes SET ville = ? WHERE id = ?");
$insertville->execute(array($newville, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newtel']) AND $_POST['newtel'] != $user['tel']);
{
$newtel = htmlspecialchars($_POST['newtel']);
$inserttel = $bdd->prepare("UPDATE personnes SET tel = ? WHERE id = ?");
$inserttel->execute(array($newtel, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newvehicule']) AND $_POST['newvehicule'] != $user['vehicule']);
{
$newvehicule = htmlspecialchars($_POST['newvehicule']);
$insertvehicule = $bdd->prepare("UPDATE personnes SET vehicule = ? WHERE id = ?");
$insertvehicule->execute(array($newvehicule, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newimmatriculation']) AND $_POST['newimmatriculation'] != $user['immatriculation']);
{
$newimmatriculation = htmlspecialchars($_POST['newimmatriculation']);
$insertimmatriculation = $bdd->prepare("UPDATE personnes SET immatriculation = ? WHERE id = ?");
$insertimmatriculation->execute(array($newimmatriculation, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if(isset($_POST['newContacts']) AND $_POST['newContacts'] != $user['Contacts']);
{
$newContacts = htmlspecialchars($_POST['newContacts']);
$insertContacts = $bdd->prepare("UPDATE personnes SET Contacts = ? WHERE id = ?");
$insertContacts->execute(array($newContacts, $_SESSION['id']));
header ('Location: identites.php?id='.$_SESSION['id']);
}
if (isset($_FILES['avatar']) AND !empty($_FILES['avatar']['name']))
{
$tailleMax = 2097152;
$extensionsValides = array('jpg', 'jpeg', 'gif', 'png');
if($_FILES['avatar']['size'] <= $tailleMax)
{
$extensionUpload = strtolower(substr(strrchr($_FILES['avatar']['name'], '.'), 1));
if(in_array($extensionUpload, $extensionsValides))
{
$chemin = "membres/avatars/".$_SESSION['id'].".".$extensionUpload;
$deplacement = move_uploaded_file($_FILES['avatar']['tmp_name'], $chemin);
if($deplacement)
{
$updateavatar = $bdd->prepare('UPDATE personnes SET avatar = :avatar WHERE id = :id');
$updateavatar = execute(array(
'avatar' => $_SESSION['id'].".".$extensionUpload,
'id' => $_SESSION['id']
));
header ('Location: identites.php?id='.$_SESSION['id']);
}
else
{
$msg = "Erreur durant l'importation de votre photo";
}
}
else
{
$msg = "Votre photo doit etre au format jpg, jpeg, gif, ou png";
}
}
else
{
$msg = "Votre photo ne doit pas depasser 2 Mo";
}
}
}
?>
<html>
<head>
<title>Identite trouvee</title>
<meta charset="utf-8">
<link rel="stylesheet" href="miseajour.css" />
</head>
<body>
<div align="center">
<h2>Mise a jour de la fiche de <?php echo $_SESSION['Noms']; ?><h2></div>
<br/><br/>
<table>
<form method="POST" action="" enctype="multipart/form-data">
<tr>
<td align="right">
<label>Ne le :</label>
<input type="text" name="newdatenais" placeholder="date de naissance" value="<?php echo $user['datenais']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>A :</label>
<input type="text" name="newlieunais" placeholder="lieu de naissance" value="<?php echo $user['lieunais']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Demeurant :</label>
<input type="text" name="newadresse" placeholder="adresse" value="<?php echo $user['adresse']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Code Postal :</label>
<input type="text" name="newcp" placeholder="code postal" value="<?php echo $user['cp']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>A :</label>
<input type="text" name="newville" placeholder="ville" value="<?php echo $user['ville']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Tel :</label>
<input type="text" name="newtel" placeholder="06.00.00.00.00" value="<?php echo $user['tel']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Véhicule :</label>
<input type="text" name="newvehicule" placeholder="Peugeot 106 rouge" value="<?php echo $user['vehicule']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Immatricule :</label>
<input type="text" name="newimmatriculation" placeholder="AA-234-FT" value="<?php echo $user['immatriculation']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Avatar :</label>
<input type="file" name="avatar" value="" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<label>Modifie par<font color="red">*</font>:</label>
<input type="text" name="newContacts" placeholder="votre nom" value="<?php echo $user['Contacts']; ?>" /><br/><br/>
</td>
</tr>
<tr>
<td align="right">
<input type="submit" name="mettre" value="Mettre a jour" />
</td>
</tr>
</form>
<?php if(isset($msg)) { echo $msg; } ?>
<label1><font color="red">*Merci de remplir obligatoirement ce champ afin de faire la mise a jour !!</font></label1>
</table
<div id="copyrighttext">
<p>© 2015 - 2016 S. MUZEAU, Toute reproduction est interdite sans l'autorisation de son auteur.</p> </div>
</body>
</html>
<?php
}
else
{
header("Location: connexion.php");
}
?>