PHP getListOfList Examples

Example #1

File: ajout-liste.php Project: lathou/me-mots

<?php

if (isset($_POST['listName']) && $_POST['listName'] != '' && isset($_POST['idUser']) && isset($_POST['langue']) && isset($_POST['langueOrigine'])) {
    include_once 'bdd.php';
    $id_membre = htmlspecialchars(addslashes(trim($_POST['idUser'])));
    $langue = htmlspecialchars(addslashes(trim($_POST['langue'])));
    $langueOrigine = htmlspecialchars(addslashes(trim($_POST['langueOrigine'])));
    $listName = htmlspecialchars(addslashes(trim($_POST['listName'])));
    $bdd = connexionBdd();
    creerListe($bdd, $id_membre, $langue, $langueOrigine, $listName);
    $listes = getListOfList($bdd, $id_membre);
    creerTableListe($bdd, end($listes)['id_liste']);
    $array = array("currentList" => end($listes)['id_liste'], "listes" => $listes);
    echo json_encode($array);
    foreach (json_decode($_POST['tableMots']) as $mot) {
        creerMot($bdd, end($listes)['id_liste'], $mot);
    }
}
?>

Example #2

File: supprimer-langue.php Project: lathou/me-mots

<?php

if (isset($_POST['id']) && isset($_POST['langues']) && isset($_POST['langue'])) {
    include_once 'bdd.php';
    $bdd = connexionBdd();
    $array = array('success' => updateListLangues($bdd, $_POST['id'], $_POST['langues']));
    $req = $bdd->prepare('SELECT id_liste FROM listes WHERE id_membre=:id_membre AND langue=:langue');
    $req->execute(array('langue' => $_POST['langue'], 'id_membre' => $_POST['id']));
    $listes = $req->fetchAll();
    $req->closeCursor();
    if ($listes) {
        foreach ($listes as $liste) {
            deleteList($bdd, $liste['id_liste'], $_POST['id']);
        }
    }
    $array['listOfList'] = getListOfList($bdd, $_POST['id']);
    echo json_encode($array);
}

Example #3

File: connexion.php Project: lathou/me-mots

<?php

if (isset($_POST['mail']) && isset($_POST['mp'])) {
    include_once 'bdd.php';
    $mail = htmlspecialchars(addslashes(trim($_POST['mail'])));
    $mp = sha1(htmlspecialchars(addslashes(trim($_POST['mp']))));
    $bdd = connexionBdd();
    $session = getSessionMembre($bdd, $mail, $mp);
    if (!$session['id']) {
        echo json_encode('ko');
    } else {
        $session['listes'] = getListOfList($bdd, $session['id']);
        echo json_encode($session);
    }
}

Example #4

File: supprimer-liste.php Project: lathou/me-mots

<?php

if (isset($_POST['idUser']) && isset($_POST['id_liste'])) {
    include_once 'bdd.php';
    $bdd = connexionBdd();
    deleteList($bdd, $_POST['id_liste'], $_POST['idUser']);
    $listOfList = getListOfList($bdd, $_POST['idUser']);
    echo json_encode($listOfList);
}
?>

Example #5

File: update-liste.php Project: lathou/me-mots

<?php

if (isset($_POST['idUser']) && isset($_POST['id_liste'])) {
    include_once 'bdd.php';
    $bdd = connexionBdd();
    if (isset($_POST['listName']) && $_POST['listName'] != '') {
        $listName = htmlspecialchars(addslashes(trim($_POST['listName'])));
        updateListName($bdd, $listName, $_POST['idUser'], $_POST['id_liste']);
    } else {
        if (isset($_POST['score']) && isset($_POST['temps'])) {
            updateListScore($bdd, $_POST['score'], $_POST['temps'], $_POST['idUser'], $_POST['id_liste']);
        }
    }
    updateListMots($bdd, $_POST['id_liste'], $_POST['tableMots']);
    echo json_encode(getListOfList($bdd, $_POST['idUser']));
}
?>