PHPXRef 0.7.1 : IEUF : /sql.php source

[Summary view] [Print] [Text view]
   1  <!DOCTYPE html>
   2  <html lang="fr">
   3    <head>
   4      <meta content="text/html; charset=iso-8859-1" http-equiv="content-type">
   5      <title>SQL</title>
   6    </head>
   7    <body></body>
   8  <?php
   9  include  "inclus/connect_bdi.inc.php";
  10   function numTel($num) {
  11     return chunk_split($num, 2, " ");
  12   }
  13  $requete= "
  14    SELECT lettre, personne.id AS id_pers, civilite, nom, prenom, DATE_FORMAT(DateNaiss, '%d-%m-%Y') as dteNai,
  15            adr_rue, adr_comp, adr_cp, adr_ville, tel_dom, mobile, tel_urgence, email
  16    FROM personne, adhesion, participe, atelier
  17    WHERE participe.id_atelier = atelier.id
  18    AND participe.id_adh = adhesion.id
  19    AND adhesion.id_perso = personne.id
  20    AND atelier.date_deb > '2013-09-30'";
  21  $sql=$mysqli->query($requete);
  22  if ($sql === false) exit("Erreur requête : ".$mysqli->error);
  23  echo "<table>";
  24  while (($col=$sql->fetch_assoc())) {
  25    echo "<tr>";
  26    $col['tel_dom']= numTel($col['tel_dom']);
  27    $col['mobile']= numTel($col['mobile']);
  28    foreach($col as $cnt) echo "<td>$cnt</td>";
  29    echo "</tr>";
  30  }
  31  echo "</table>";
  32  ?>
  33  </body>
  34  </html>
PHP Cross Reference of IEUF

/ -> sql.php (source)
