PHPXRef 0.7.1 : IEUF : /gestion/spectacles.php source

[Summary view] [Print] [Text view]
   1  <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"
   2  "http://www.w3.org/TR/html4/strict.dtd">
   3  <html>
   4    <head>
   5      <meta id="_moz_prolog" content="">
   6      <meta id="_moz_prolog" content="">
   7      <meta name="generator" content="HTML Tidy for Windows (vers 12 April 2005), see www.w3.org">
   8      <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
   9      <title>
  10        Spectacles
  11      </title>
  12  <style type="text/css">
  13  .parametres {
  14    width: 200px;
  15    height: 500px;
  16    position: fixed;
  17    min-height: 500px;
  18    background-color: #666666;
  19    color: white;
  20  }
  21  body {
  22    font-family: Arial,Helvetica,sans-serif;
  23    font-size: 10pt;
  24  }
  25  .tableau {
  26    margin-left: 205px;
  27  }
  28  
  29  </style>
  30  <script language="JavaScript" type="text/JavaScript">
  31    <!--
  32    function masque_list() {
  33        elt=document.getElementById("liste");
  34        elt.style.backgroundColor='silver';
  35    }
  36    //-->
  37  </script>
  38    </head>
  39    <body>
  40        <!--
  41      <?php include  "../inclus/connect_bd.inc.php";
  42              $tab_spec=array();
  43              $requeteS= "SELECT id, titre as titreS FROM spectacle";
  44              $requeteS= "SELECT spectacle.id, titre as titreS, representation.date as dateR
  45                  FROM spectacle LEFT JOIN representation on id_spectacle=spectacle.id group by spectacle.id";
  46              $rechercheS=mysql_query($requeteS);
  47              while ($colS= mysql_fetch_assoc($rechercheS)) {
  48                  if ($colS['dateR'] == null) $colS['dateR']='9999';
  49                  $tab_spec[]=$colS;
  50                  print_r ($colS); echo "\r\n";
  51              }
  52  
  53              ?>
  54        -->
  55      <div class="parametres" style="height: 21px;">
  56        <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>" name="parametres" id="parametres">
  57          <br>
  58          <br>
  59          Sélectionner :<br>
  60          <br>
  61            <input size="25" name="val_identite"><br>
  62             <br>
  63          <div align="center">
  64             <input name="Afficher" value="Afficher" type="submit"><br>
  65          </div><br>
  66          Classement par :<br>
  67          <input value="a" checked="checked" name="Classement" onchange="masque_list()" type="radio">Ordre
  68          alphabétique<br>
  69          <input value="s" name="classement" onchange="masque_list()" type="radio">Saison<br>
  70          <br>
  71          <br>
  72          <br>
  73        </form>
  74      </div>
  75      <table id="liste" class="tableau" border="1" cellpadding="2" cellspacing="2" width="800">
  76        <tbody>
  77          <tr>
  78            <td align="left" width="46">
  79              Productions
  80            </td>
  81            <td width="120">
  82              Spectacles
  83            </td>
  84            <td width="90">
  85              Représentations
  86            </td>
  87          </tr><?php
  88                  /*
  89                  foreach ($tab_spec as $colS) {
  90                      echo "<tr>";
  91                      $requeteP= "SELECT production.titre as titreP FROM production, passe
  92                                  WHERE {$colS['id']} = passe.id_spectacle AND production.id = passe.id_prod";
  93                      $rechercheP=mysql_query($requeteP);
  94                      echo "<td>";
  95                      while ($colP= mysql_fetch_assoc($rechercheP))
  96                          echo $colP['titreP']."<br>";
  97                      echo "</td>";
  98                      echo "
  99                              <td>{$colS['titreS']}</td>
 100                      ";
 101                      $requeteR= "SELECT date FROM representation
 102                                  WHERE {$colS['id']} = id_spectacle";
 103                      $rechercheR=mysql_query($requeteR);
 104                      echo "<td>";
 105                      while ($colR= mysql_fetch_assoc($rechercheR))
 106                          echo $colR['date']."<br>";
 107                      echo "</td>";
 108                      echo "</tr>";
 109                  }
 110  
 111  */
 112                                  ?>
 113  
 114        </tbody>
 115      </table>
 116    </body>
 117  </html>
PHP Cross Reference of IEUF

/gestion/ -> spectacles.php (source)
