|
|
<?php |
|
|
|
|
|
$host = getenv("HOST_NAME_DB"); |
|
|
$dbname = getenv("NAME_DATA_BASE"); |
|
|
|
|
|
$dsn = "mysql:dbname=$dbname;host=$host"; |
|
|
$usuario = getenv("USER_NAME_DATABASE"); |
|
|
$contrasena = getenv("PASSWORD_DATABASE"); |
|
|
|
|
|
try { |
|
|
$gbd = new PDO($dsn, $usuario, $contrasena); |
|
|
$query = "SELECT * FROM perro;"; |
|
|
|
|
|
$gsent = $gbd->prepare($query); |
|
|
$gsent->execute(); |
|
|
|
|
|
$data = $gsent->fetchAll(PDO::FETCH_ASSOC); |
|
|
|
|
|
if (!$data) { |
|
|
$gbd = null; |
|
|
echo "<h2>Ahhh no se pudo sacar los perros</h2>"; |
|
|
} |
|
|
|
|
|
$gbd = null; |
|
|
|
|
|
foreach ($data as $usuario) { |
|
|
?> |
|
|
<div class="card" style="width: 18rem;"> |
|
|
<img src="https://i.pinimg.com/736x/07/39/3e/07393ee5bd2e2751e1012994182d42c8.jpg" class="card-img-top" alt="gato"> |
|
|
<div class="card-body"> |
|
|
<h5 class="card-title">Nombre: <?php echo $usuario["nombre"] ?></h5> |
|
|
<p class="card-text">Edad: <?php echo $usuario["edad"] ?></p> |
|
|
<a href="https://www.google.com/search?q=gatos&sca_esv=4b803b01132785fa&sca_upv=1&udm=2&sxsrf=ADLYWILfFlNBCGb4nHWc9_eE6eZDorVYzw%3A1726940588525&ei=rAXvZtzkH5nSkPIPraKokAY" |
|
|
class="btn btn-primary" target="_blank">Gatos</a> |
|
|
</div> |
|
|
</div> |
|
|
<?php |
|
|
} |
|
|
// echo json_encode($data); |
|
|
// var_dump($data); |
|
|
} catch (PDOException $e) { |
|
|
echo 'Falló la conexión: ' . $e->getMessage(); |
|
|
} |
|
|
?> |