| <?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(); |
| } |
| ?> |