SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | include 'db.php'; | |
3 | ||
4 | $sql= " | |
5 | SELECT offer.*, clients.* FROM offer | |
6 | INNER JOIN clients ON (offer.idClient = clients.idClient) | |
7 | ORDER BY idOffer DESC"; | |
8 | $result = $conn->query($sql); | |
9 | ||
10 | if (!$result) { | |
11 | $response['status'][] = "Invalid query"; | |
12 | } | |
13 | ||
14 | if ($result) { | |
15 | // extrage detaliile ofertei | |
16 | while($row = $result->fetch_assoc()) { | |
17 | - | $response['items'][] = array( |
17 | + | $response['items'][$row['idOffer']] = array( |
18 | 'idOffer' => $row['idOffer'], | |
19 | 'nameOffer' => $row['nameOffer'], | |
20 | 'nameClient' => $row['nameClient'], | |
21 | 'dateOffer' => $row['dateOffer'] | |
22 | ); | |
23 | ||
24 | $idOffer=$row['idOffer']; | |
25 | $sqli= "SELECT * FROM offeritem WHERE idOffer = '$idOffer'"; | |
26 | $resultInner = $conn->query($sqli); | |
27 | ||
28 | if ($resultInner) { | |
29 | //extrage elementele ofertei pt id $idOffer | |
30 | while($rowInner = $resultInner->fetch_assoc()) { | |
31 | - | $response['items']['offerItem'][] = array( |
31 | + | $response['items'][$row['idOffer']]['offerItem'][] = array( |
32 | 'priceOfferItem' => $rowInner['priceOfferItem'], | |
33 | 'quantityOfferItem' => $rowInner['quantityOfferItem'] | |
34 | ); | |
35 | } | |
36 | } | |
37 | } | |
38 | } | |
39 | ||
40 | else { | |
41 | $response['status'][] = "0 results"; | |
42 | } | |
43 | ||
44 | $conn->close(); | |
45 | ||
46 | echo json_encode($response); | |
47 | die(); | |
48 | ?> |