-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpaisam.php
103 lines (66 loc) · 4.2 KB
/
paisam.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<!DOCTYPE html>
<html lang="es">
<?php include("./config.php"); ?>
<head>
<?php include("./head.php"); ?>
</head>
<body>
<!-- Sidebar/menu -->
<?php include("./navi.php"); ?>
<!-- !PAGE CONTENT! -->
<div class="w3-main" style="margin-left:340px;margin-right:40px" id="wcont">
<!-- Header -->
<?php include("./header.php"); ?>
<!-- Body content -->
<!-- Menu Countries -->
<div class="w3-bar w3-black w3-margin-bottom">
<a href="./paisam.php?paisid=41"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Argentina</div></a>
<a href="./paisam.php?paisid=60"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Bolivia</div></a>
<a href="./paisam.php?paisid=42"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Brasil</div></a>
<a href="./paisam.php?paisid=43"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Canadá</div></a>
<a href="./paisam.php?paisid=44"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Chile</div></a>
<a href="./paisam.php?paisid=45"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Colombia</div></a>
<a href="./paisam.php?paisid=46"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Costa Rica</div></a>
<a href="./paisam.php?paisid=47"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Cuba</div></a>
<a href="./paisam.php?paisid=48"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Ecuador</div></a>
<a href="./paisam.php?paisid=49"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">El Salvador</div></a>
<a href="./paisam.php?paisid=50"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Estados Unidos</div></a>
<a href="./paisam.php?paisid=51"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Guatemala</div></a>
<a href="./paisam.php?paisid=52"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">México</div></a>
<a href="./paisam.php?paisid=53"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Nicaragua</div></a>
<a href="./paisam.php?paisid=54"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Paraguay</div></a>
<a href="./paisam.php?paisid=55"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Perú </div></a>
<a href="./paisam.php?paisid=56"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Puerto Rico</div></a>
<a href="./paisam.php?paisid=57"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Uruguay</div></a>
<a href="./paisam.php?paisid=58"><div class="w3-bar-item w3-text-light-green w3-hover-pale-green w3-hover-text-green">Venezuela</div></a>
</div>
<!-- Intro - massas x pais-->
<?php
$conn;
$query = "SELECT t_massas.id_massa, t_massas.logo_massa, t_massas.ciudad, t_massas.hora, t_massas.lugar, t_paises.pais, t_contis.conti, t_massas.img_lugar FROM t_massas LEFT JOIN t_paises ON t_massas.paisid = t_paises.id_pais LEFT JOIN t_contis ON t_paises.contiid = t_contis.id_conti WHERE t_paises.id_pais = $_GET[paisid] ORDER BY ciudad";
if ($result = mysqli_query($conn, $query)) {
/* fetch associative array */
while ($row = mysqli_fetch_array($result)) {
echo " <table>
<tr>
<td width=10em style='text-align:center'><a href='./massa.php?massaid=".$row['id_massa']."' target='_blank'><img class=tabimg src=".$row['logo_massa']."></a></td>
<td width=300em>".$row['ciudad']."</td>
<td width=200em>".$row['hora']."</td>
<td width=100em>".$row['lugar']."</td>
<td width=10em style='text-align:center'><img class=tabimg src=".$row['img_lugar']."></td>
</tr>
";
}
/* free result set */
mysqli_free_result($result);
}
echo "</table>";
/* close connection */
mysqli_close($conn);
?>
</div>
<!-- End page content -->
<?php include("./footer.php"); ?>
</body>
<!-- End body -->
</html>