list-gent.php
changeset 0 e269d7e3f581
child 2 eb656142f039
child 9 e3ddfccc8d4f
equal deleted inserted replaced
-1:000000000000 0:e269d7e3f581
       
     1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
       
     2 <html>
       
     3 <head>
       
     4 	<title>Ètxelon - Llistat de gent</title>
       
     5 	<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1">
       
     6 </head>
       
     7 
       
     8 <body>
       
     9 
       
    10 <h1 align=center>Ètxelon</h1>
       
    11 <h2>Llistat de gent</h2>
       
    12 
       
    13 <?php
       
    14 	include("getdb.inc");
       
    15 	$connexio = mysql_connect($mysql_server, $mysql_user, $mysql_password);
       
    16 
       
    17 	mysql_select_db($mysql_db, $connexio);
       
    18 
       
    19 
       
    20 	// Crides a funcions per obtenir parametres
       
    21 	$altres = obtenir_altres($connexio);
       
    22 	$habitants = obtenir_habitants($connexio);
       
    23 ?>
       
    24 
       
    25 <TABLE BORDER=0>
       
    26 <TR>
       
    27 <TD VALIGN=top>
       
    28 
       
    29 	<TABLE BORDER=1>
       
    30 	<CAPTION>Habitants</CAPTION>
       
    31 	<TR>
       
    32 		<TH>Id
       
    33 		<TH>Nom
       
    34 <?php
       
    35 		foreach($habitants as $i)
       
    36 		{
       
    37 			echo "<TR>\n";
       
    38 			echo "\t<TD>" . $i["id"] . "\n";
       
    39 			echo "\t<TD>" . strtohtml($i["nom"]) . "\n";
       
    40 		}
       
    41 ?>
       
    42 	</TABLE>
       
    43 <TD VALIGN=top>
       
    44 
       
    45 	<TABLE BORDER=1>
       
    46 	<CAPTION>Altres</CAPTION>
       
    47 	<TR>
       
    48 		<TH>Id
       
    49 		<TH>Nom
       
    50 <?php
       
    51 		foreach($altres as $i)
       
    52 		{
       
    53 			echo "<TR>\n";
       
    54 			echo "\t<TD>" . $i["id"] . "\n";
       
    55 			echo "\t<TD>" . strtohtml($i["nom"]) . "\n";
       
    56 		}
       
    57 ?>
       
    58 	</TABLE>
       
    59 <TD VALIGN=top>
       
    60 	<UL>
       
    61 	<LI>Els noms estan ordenats alfabèticament
       
    62 	<LI>El camp <em>"Id"</em> és l'identificador que té la persona dins la
       
    63 		base de dades.
       
    64 	</UL>
       
    65 
       
    66 </TABLE>
       
    67 
       
    68 <HR WIDTH="70%">
       
    69 <BR>
       
    70 <A HREF="index">Tornar al menú d'inici</A>
       
    71 
       
    72 </body>
       
    73 </html>
       
    74