1 | <?php |
2 | |
3 | require_once __DIR__ . "/../../lib/php/recibeFetchAll.php"; |
4 | require_once __DIR__ . "/Bd.php"; |
5 | |
6 | function amigoConsulta() |
7 | { |
8 | $con = Bd::getConexion(); |
9 | $stmt = $con->query( |
10 | "SELECT |
11 | A.AMI_ID AS amiId, |
12 | A.AMI_NOMBRE AS amiNombre, |
13 | P.PAS_NOMBRE AS pasNombre |
14 | FROM AMIGO A |
15 | LEFT JOIN PASATIEMPO P |
16 | ON A.PAS_ID = P.PAS_ID |
17 | ORDER BY A.AMI_NOMBRE" |
18 | ); |
19 | $resultado = $stmt->fetchAll(PDO::FETCH_OBJ); |
20 | return recibeFetchAll($resultado); |
21 | } |
22 |