function show_test()
{
$db = coBDD();
// Requete sql
$requete = "SELECT * FROM aeroports";
$query = $db->query($requete);
$result = $query->fetchAll();
$query->closeCursor();
killBDD($db);
return $result;
}
function add_user($sexe, $nom, $prenom, $pseudo, $mail, $mdp, $date_naissance)
{
//$req = "INSERT INTO utilisateurs VALUES :sexe, :nom, :prenom, :pseudo, :mdp, :mail";
$db = coBDD();
$query = $db->prepare('INSERT INTO utilisateurs VALUES (NULL, :nom, :prenom, :sexe, :pseudo, :mail, :mdp, :date_naissance, 3)');
$query->bindValue(':sexe', $sexe);
$query->bindValue(':nom', $nom);
$query->bindValue(':prenom', $prenom);
$query->bindValue(':pseudo', $pseudo);
$query->bindValue(':mdp', $mdp);
$query->bindValue(':mail', $mail);
$query->bindValue(':date_naissance', $date_naissance);
if ($query->execute()) {
return 1;
}
return 0;
}
function search_result($post)
{
$req = "SELECT vols.*, dest.nom as dest_nom, dest.ville as dest_ville, dest.pays as dest_pays, prov.nom as prov_nom, prov.ville as prov_ville, prov.pays as prov_pays\n\t\t\tFROM vols \n\t\t\tLEFT JOIN aeroports dest on dest.id_aeroport = vols.destination \n\t\t\tLEFT JOIN aeroports prov on prov.id_aeroport = vols.provenance";
$where = [];
foreach ($post as $k => $v) {
if (!empty($v) && in_array($k, ['num_vols', 'destination', 'provenance', 'heure_arrivee', 'heure_depart', 'date_arrivee'])) {
if ($k == 'heure_arrivee' || $k == 'heure_depart') {
$heure = explode(":", $v)[0];
$where[] = " HOUR(vols.{$k}) >= '{$heure}'";
} else {
if ($k == 'date_arrivee' || $k == 'date_depart') {
$where[] = "vols.{$k} >= '{$v}'";
} else {
if ($k == 'destination') {
$where[] = "(dest.id_aeroport = '{$v}')";
} else {
if ($k == 'provenance') {
$where[] = "(prov.id_aeroport = '{$v}')";
} else {
$where[] = "vols.{$k} LIKE '{$v}%'";
}
}
}
}
}
}
foreach ($where as $k => $w) {
if ($k === 0) {
$req .= " WHERE {$w}";
} else {
$req .= " AND {$w}";
}
}
$req .= " ORDER BY date_arrivee DESC";
$db = coBDD();
$req = $db->prepare($req);
$req->execute();
$ret = $req->fetchAll(PDO::FETCH_ASSOC);
killBDD($db);
return $ret;
}
function getAllVol()
{
$db = coBDD();
$req = $db->query("SELECT * FROM vols");
return $req->fetchAll(PDO::FETCH_ASSOC);
}
function getAllAbout($table, $idTable, $idField)
{
$co = coBDD();
$selectField = "SELECT * FROM " . $table . " WHERE " . $idTable . " = " . $idField . ";";
$resultat = $co->query($selectField);
$tab = getOneFetch($resultat, $table);
$resultat->closeCursor();
return $tab;
}
function getAllVille()
{
$db = coBDD();
$req = $db->query('SELECT id_aeroport as id, ville, nom, code_vol, pays FROM aeroports');
return $req->fetchAll(PDO::FETCH_ASSOC);
}
function getAllCompagnies()
{
$db = coBDD();
$req = $db->query('SELECT * FROM compagnies');
return $req->fetchAll(PDO::FETCH_ASSOC);
}
<div data-role="page" id="pageinscription">
<?php
include "vues/entetepage.html";
include "vues/logo.html";
$user = array();
$co = coBDD();
$recupUser = "******";
$resultat = mysql_query($recupUser);
if ($resultat != NULL) {
$i = 0;
while ($row = mysql_fetch_assoc($resultat)) {
$user[$i] = array($row);
echo $user[$i]["pseudo"];
echo $user[$i]["mdp"];
echo $user[$i]["nom"];
echo "test";
$i += 1;
}
$user = array("id" => "cool");
echo $user["id"];
} else {
echo "c'est nul";
}
?>
<div data-role="content" id="divinscrit">
<form action="#" rel="external">
<b>Nom: <input type="text" name="nom" id="nom" required autofocus=""autofocus/></b><br>
<b>Prenom: <input type="text" name="prenom" id="prenom" required=""/></b><br>
<b>Mail: <input type="text" name="mail" id="mail" required=""/></b><br>
<b>Téléphone: <input type="text" name="tel" id="tel" required=""/></b><br>
