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