HEX

File: /homepages/16/d176908298/htdocs/wsb4118896501-old/colmar/Pcs-clas.php
<?php

$link = mysql_connect("db1530.1and1.fr", "dbo250234682", "NhwJWrrg")
    or die("Impossible de se connecter au serveur sql");

mysql_select_db("db250234682") or die("erreur de connexion � la base");

import_request_variables('g','p_');


$query = "SELECT nom,min(houvert) as ouv, max(hferme) as ferm, max(repos) as pause from pc_villes inner join pc_pcs on pc_villes.idville=pc_pcs.idville where pc_villes.idville=".$p_pcs;
$result = mysql_query($query) or die("Query failed");

$nom = mysql_result($result,0,"nom");
$ouv = mysql_result($result,0,"ouv");
$fer = mysql_result($result,0,"ferm");
$pau = mysql_result($result,0,"pause");

mysql_free_result($result);

$query = "SELECT idpcs, kms,nomcourt, pc_pcs.idepr,type from pc_pcs inner join pc_epreuves on pc_pcs.idepr=pc_epreuves.idepr where idville=".$p_pcs." and type<>'D' order by idepr";
$result = mysql_query($query) or die("Query failed");

$num = mysql_numrows($result);
$i = 0;
$j = 0;
$k = 0;


echo "<html>\n";
echo "  <head>\n";
echo "    <link rel='stylesheet' href='pcs-clas.css' type='text/css'/>\n";
echo "    <script>\n";
echo "       function bascule(obj,img) { \n";
echo "          if ( document.all(obj).style.display == 'block' ) {\n";
echo "             document.all(obj).style.display = 'none';\n";
echo "             document.all(img).src='plus.png';\n";
echo "          } \n";
echo "          else { \n";
echo "             document.all(obj).style.display = 'block';\n";
echo "             document.all(img).src='moins.png';\n";
echo "          }; \n";
echo "       }\n";
echo "    </script>\n";
echo "  </head>\n";
echo "  <body>\n";
echo "    <div class='PCS'>\n";
echo "      <table class='titre'>\n";
echo "        <tr>\n";
echo "          <td><img src='logo-pc-25.png'></td>\n";
echo "          <td>\n";
echo "            <div>".$nom."</div>\n";
echo "            <div>Ouverture � ".strftime('%Hh%M',strtotime($ouv))."</div>\n";
echo "            <div>Fermeture � ".strftime('%Hh%M',strtotime($fer))."</div>\n";
if ( $pau > 0 ) { echo "            <div>Repos ".$pau."h</div>\n"; };
echo "          </td>\n";
echo "        </tr>\n";
echo "      </table>\n";
echo "    </div>\n";

while ( $i < $num ) {
   $kms = mysql_result($result,$i,"kms")/1000;
   $pcs = mysql_result($result,$i,"idpcs");
   $cmp = mysql_result($result,$i,"nomcourt");
   echo "    <a href='#' onclick='bascule(".'"T'.$i.'","I'.$i.'")'."' style='margin: 5px'><img id='I".$i."' src='plus.png'></a><span class='titre'>Passages ".$cmp." km ". $kms."</span><br/>\n";
   echo "    <div id='T".$i."' style='display:none'>\n";

   echo file_get_contents("pas".$pcs.".htm");
   
   echo "     </div><br>\n";
   $i++;
}

echo "</body>";

echo "</html>";

?>