creation_donnees_perso2.php

<?php
/**
 * Created by PhpStorm.
 * User: genty
 * Date: 06/05/16
 * Time: 03:23
 */

session_start();
include("config.php");
include("profil_vision.php");

$nomUser=$_GET['Nom'];
$prenomUser=$_GET['Prenom'];
$mdp=$_GET['psw'];
$surnom=$_GET['Surnom'];
$promo=$_GET['Promo'];
$ddn=$_GET['Ddn'];
$tel=$_POST['Tel'];
$mail=$_GET['Mail'];
$ecole=$_POST['ecole'];
$gpe=$_POST['gpe'];
$assoces=array($_GET['assoc']);

print "<p> Your login is : </p> <p id='login'> </p>";
print "<script> x1 = $nomUser; x2 = $prenomUser; document.getElementById(\"login\").innerHTML = x1.concat(x2); </script>";

if ( $DB = pg_connect("host=$nomHost user=$nomRoot dbname=$nomBase password=$mdpRoot" ) ) {
    $check = pg_query($DB, "SELECT nom_eleve, prenom, mail, mdp FROM eleve WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
    if ($check) {
        $ligne_selectionnee = pg_fetch_array($check);

        $newmail=$ligne_selectionnee['mail'];
        $newmdp=$ligne_selectionnee['mdp'];
        /* On teste si le login est encore n'existe pas déjà dans la base */
        if ($newmail != $mail) {
            pg_query($DB,"UPDATE eleve SET mail=$newmail WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
            $_SESSION['mail'] = $mail;
        }
        if ($newmdp == $mdp) {
            pg_query($DB,"UPDATE eleve SET mdp=$newmdp WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
            $_SESSION['mdp'] = $mdp;
        }
        if ($surnom != null && $surnom != "") {
            pg_query($DB,"INSERT INTO eleve (surnom) VALUES $surnom WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($promo != null && $promo != "") {
            pg_query($DB,"INSERT INTO eleve (promo) VALUES $promo WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($ddn != null && $ddn != "") {
            pg_query($DB,"INSERT INTO eleve (ddn) VALUES $ddn WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($tel != null && $tel != "") {
            pg_query($DB,"INSERT INTO eleve (tel) VALUES $tel WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($ecole != null && $ecole != "") {
            pg_query($DB,"INSERT INTO eleve (lieu) VALUES $surnom WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($surnom != null && $surnom != "") {
            pg_query($DB,"INSERT INTO eleve (surnom) VALUES $surnom WHERE nom_eleve=$nomUser AND prenom=$prenomUser");
        }
        if ($assoc != null && $assoc != "") {
            $i=0;
            while ($assoces[$i] != null) {
                $idassoc=pg_query($DB,"SELECT id_assoc FROM assoc WHERE nom=$assoces[$i]");
                pg_query($DB, "INSERT INTO assoc_eleve (login_eleve, id_assoc) VALUES $login,$idassoc");
                $i=$i+1;
            }
        }
    }
    else {
        /* La commande a échoué */
        $retour = array(-2,0,0,0,0,0,0,0,0,0);
    }
}
else {
    /* Connexion à la BD impossible */
    $retour = array(-3,0,0,0,0,0,0,0,0,0);
}

enTete("Création du profil complet");
retourAuMenu();
pied();