PHP BD::selectMult Examples

Example #1

File: reservation.php Project: sebspas/Share2Go

function recupEffectueTrajet($idt)
{
    $BD = new BD('effectue');
    $res1 = $BD->selectMult("idtrajet", $idt);
    $BD->setUsedTable('user');
    foreach ($res1 as $tuple) {
        $donnees[] = $BD->select("iduser", $tuple->iduser);
    }
    return $donnees;
}

Example #2

File: profil.php Project: sebspas/Share2Go

function recupTrajetReserv($id)
{
    $BD = new BD('effectue');
    $res = $BD->selectMult("iduser", $id);
    $BD->setUsedTable('trajet');
    foreach ($res as $tuple) {
        if ($tuple->idtrajet) {
            $result[] = $BD->select("idtrajet", $tuple->idtrajet);
        }
    }
    return $result;
}

Example #3

File: profil.php Project: sebspas/AFK-WEB

function recupJeuInscrit($iduser)
{
    $BD = new BD('joueur');
    $listeJoueur = $BD->selectMult('iduser', $iduser);
    $listeJeux = array();
    $BD->setUsedTable('section');
    foreach ($listeJoueur as $joueur) {
        if (!empty($joueur)) {
            $listeJeux[] = $BD->select('idjeux', $joueur->idjeux);
        }
    }
    return $listeJeux;
}

Example #4

File: load-combat-ennemi.php Project: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('ennemi');
$listeEnnemi = $BD->selectMult('idmission', $idmission);
$BD->setUsedTable('IA');
$listeMyEnnemi = array();
foreach ($listeEnnemi as $ennemi) {
    if ($ennemi) {
        $ennemi = $BD->select('idIA', $ennemi->idIA);
        $listeMyEnnemi[] = $ennemi;
    }
}
echo json_encode($listeMyEnnemi);

Example #5

File: load-hangar-ship.php Project: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
$BD = new BD('vaisseau');
$listeVaisseau = $BD->selectMult('iduser', $_SESSION['iduser']);
echo json_encode($listeVaisseau);

Example #6

File: section.php Project: sebspas/AFK-WEB

function recupListeJoueur($idjeux)
{
    $BD = new BD('joueur');
    return $BD->selectMult('idjeux', $idjeux);
}

Example #7

File: load-starter.php Project: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
extract($_GET);
$BD = new BD('spaceship');
$return = $BD->selectMult('prix', 750);
echo json_encode($return);

Example #8

File: load-nom-items.php Project: sebspas/Aurora

<?php

session_start();
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
require_once '../../../app/Config.class.php';
require_once '../../../app/Bd.class.php';
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
$BD = new BD('equipement');
$listeEquipement = $BD->selectMult('iduser', $_SESSION['iduser']);
$BD->setUsedTable('item');
$listeMyNom = array();
foreach ($listeEquipement as $equipement) {
    if ($equipement) {
        $Item = $BD->select('idiitem', $equipement->iditem);
        $listeMyNom[] = $Item->nom;
    }
}
echo json_encode($listeMyNom);

Example #9

File: modifier.php Project: sebspas/Share2Go

function recupVehicule($id)
{
    $BD = new BD('vehicule');
    $res = $BD->selectMult("iduser", $id);
    return $res;
}

Example #10

File: proposer.php Project: sebspas/Share2Go

function recupVehicule()
{
    $BD = new BD('vehicule');
    $res = $BD->selectMult("iduser", $_SESSION['id']);
    return $res;
}