<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
<title>Famous Actor</title>
</head>
<body>
<div class="container mt-5">
<div class="row">
<?php
$dbusername = "root";
$dbpassword = "";
$dbhost = "localhost";
$dbname = "actor";
$conn = new mysqli($dbhost, $dbusername, $dbpassword, $dbname);
$sql = "SELECT name, country, image FROM actor";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
?>
<div class="col-lg-3 col-12">
<div class="card mb-3 bg-primary text-white">
<img class="img-fluid card-image-top" src="<?php echo $row['image']; ?>" alt="" srcset="">
<div class="card-body">
<div class="card-title">
<h3><?php echo $row['name']; ?></h3>
</div>
<div class="card-text">
<h4>Country: <?php echo $row['country']; ?></h4>
</div>
</div>
</div>
</div>
<?php
}
}
$conn->close();
?>
</div>
</div>
</body>
</html>Tuesday, March 21, 2023