1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| <?php
session_start(); //démarrage d'une session pour récupérer les login et pwd
include ('../fonctions/connexion.php'); //inclusion des log de la DB oracle
class correspondant {
function ajout ($nom, $prenom, $telephone, $sexe, $mail, $age, $commune, $user, $ora_conn)
{
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$telephone = $_POST['telephone'];
$sexe = $_POST['sexe'];
$mail = $_POST['mail'];
$age = $_POST['age'];
$commune = $_POST['commune'];
$user = $_SESSION['id_user'];
$query = "INSERT INTO CORRESPONDANT(ID_CORRESPONDANT, INSEE_COMMUNE, NOM, PRENOM, N_PORTABLE, SEXE, ID_STRUCTURE, EMAIL, AGE) VALUES ('','$commune', '$nom', '$prenom', '$telephone', '$sexe', '$user', '$mail', '$age')";
$parsed = ociparse($ora_conn, $query);
ociexecute($parsed);
}} |
Partager