View difference between Paste ID: 5TUNN1NQ and FQMkiBMt
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
?>