1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| <?php
|
| class Product
| {
| public function getData(): array
| {
| $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
| ]);
|
| $stmt = $pdo->query("SELECT * FROM product");
|
| return $stmt->fetchAll(PDO::FETCH_ASSOC);
| }
| }
|
|
| ?>
|
|