Ajouter un contact

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT ID FROM users WHERE username = :username"); $stmt->bindParam(':username', $_SESSION['username']); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); $idsession = $result['ID']; } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } $conn = null; include 'class/sqlconnect.php'; if(isset($_POST['submit'])){ $prenom = $_POST['Prenom']; $nom = $_POST['Nom']; $poste = $_POST['Poste']; $poste = htmlentities($poste); $poste = str_replace("'", "\'", $poste); $mobile = $_POST['Mobile']; $entreprise = $_POST['IDEntreprise']; $mail = $_POST['Mail']; $sql = "INSERT INTO Contact (Prenom, Nom, Poste, Mobile, IDEntreprise, IDUser, Mail) VALUES ('$prenom', '$nom', '$poste', '$mobile', '$entreprise', '$idsession', '$mail')"; mysqli_query($conn, $sql); } ?> Revenir à l'accueil