| | |
|---|
| | | <?php |
|---|
| | | $dns = "mysql:host=localhost;dbname=product_db;charset=utf8;port=3306"; |
|---|
| | | $pdo = new PDO($dns, "product_db_user", "secret", [ |
|---|
| | | PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION |
|---|
| | | ]); |
|---|
| | | require "model.php"; |
|---|
| | | $model = new Model; |
|---|
| | | $products = $model->getData(); |
|---|
| | | ?> |
|---|
| | | |
|---|
| | | $stmt = $pdo->query("SELECT * FROM product"); |
|---|
| | | |
|---|
| | | $products = $stmt->fetchAll(PDO::FETCH_ASSOC); |
|---|
| | | |
|---|
| | | print_r($products); |
|---|
| | | ?> |
|---|
| | | <!DOCTYPE html> |
|---|
| | | <html lang="en"> |
|---|
| | | <head> |
|---|
| | | <meta charset="UTF-8"> |
|---|
| | | <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
|---|
| | | <title>Products</title> |
|---|
| | | </head> |
|---|
| | | <body> |
|---|
| | | <h1>Products</h1> |
|---|
| | | <?php foreach ($products as $product): ?> |
|---|
| | | <h2><?= htmlspecialchars($product["name"]) ?></h2> |
|---|
| | | <p><?= htmlspecialchars($product["description"]) ?></p> |
|---|
| | | <?php endforeach; ?> |
|---|
| | | </body> |
|---|
| | | </html> |
|---|
