1 | <?php |
2 | |
3 | require_once __DIR__ . "/../../lib/php/recibeFetchAll.php"; |
4 | require_once __DIR__ . "/../modelo/Producto.php"; |
5 | require_once __DIR__ . "/Bd.php"; |
6 | |
7 | |
8 | function productoConsulta(): array |
9 | { |
10 | $con = Bd::getConexion(); |
11 | $stmt = $con->query( |
12 | "SELECT |
13 | PROD_ID as id, |
14 | PROD_NOMBRE as nombre, |
15 | PROD_PRECIO as precio, |
16 | PROD_EXISTENCIAS as existencias |
17 | FROM PRODUCTO |
18 | ORDER BY PROD_NOMBRE" |
19 | ); |
20 | $resultado = $stmt->fetchAll( |
21 | PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, |
22 | Producto::class |
23 | ); |
24 | return recibeFetchAll($resultado); |
25 | } |
26 | |