Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'db.php';
- $sql= "
- SELECT offer.*, clients.* FROM offer
- INNER JOIN clients ON (offer.idClient = clients.idClient)
- ORDER BY idOffer DESC";
- $result = $conn->query($sql);
- if (!$result) {
- $response['status'][] = "Invalid query";
- }
- if ($result) {
- // extrage detaliile ofertei
- while($row = $result->fetch_assoc()) {
- $response['items'][] = array(
- 'idOffer' => $row['idOffer'],
- 'nameOffer' => $row['nameOffer'],
- 'nameClient' => $row['nameClient'],
- 'dateOffer' => $row['dateOffer']
- );
- $idOffer=$row['idOffer'];
- $sqli= "SELECT * FROM offeritem WHERE idOffer = '$idOffer'";
- $resultInner = $conn->query($sqli);
- if ($resultInner) {
- //extrage elementele ofertei pt id $idOffer
- while($rowInner = $resultInner->fetch_assoc()) {
- $response['items']['offerItem'][] = array(
- 'priceOfferItem' => $rowInner['priceOfferItem'],
- 'quantityOfferItem' => $rowInner['quantityOfferItem']
- );
- }
- }
- }
- }
- else {
- $response['status'][] = "0 results";
- }
- $conn->close();
- echo json_encode($response);
- die();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement