commit | author | age | ||
00e0e7 | 1 | <?php |
F | 2 | |
3 | class Model | |
4 | { | |
5 | public function getData(): array | |
6 | { | |
7 | $dns = "mysql:host=localhost;dbname=product_db;charset=utf8;port=3306"; | |
8 | $pdo = new PDO($dns, "product_db_user", "secret", [ | |
9 | PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION | |
10 | ]); | |
11 | ||
12 | $stmt = $pdo->query("SELECT * FROM product"); | |
13 | ||
14 | return $stmt->fetchAll(PDO::FETCH_ASSOC); | |
15 | } | |
16 | } | |
17 | ||
18 | ||
19 | ?> |