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 | ?> |