public function getOffer($beacon) { $data = array(); $data3 = array(); $row = Database::single_row("beacon", "*", "uuid='" . $beacon . "'"); if ($row) { $row2 = Database::single_row("offer", "*", "id='" . $row['offer_id'] . "'"); if ($row2) { $data['offerID'] = $row2['id']; $data['offerTitle'] = $row2['title']; $data['offerDescription'] = $row2['description']; $data['offerPicture'] = SURL . $row2['picture']; $data['offerOriginalPrice'] = $row2['original_price']; $data['offerOfferPrice'] = $row2['offer_price']; $data['offerTimeLimit'] = $row2['time_limit']; $data['offerExpireDate'] = $row2['expire_date']; $data['offerCode'] = $row2['code']; $data['merchantID'] = $row2['merchant_id']; $row3 = Database::single_row("merchant", "*", "id='" . $data['merchantID'] . "'"); if ($row3) { $data3['merchantID'] = $row3['id']; $data3['merchantName'] = $row3['business_name']; $data3['merchantAddress'] = $row3['address']; $data3['merchantAddress2'] = $row3['address2']; $data3['merchantCity'] = $row3['city']; $data3['merchantState'] = $row3['state']; $data3['merchantZip'] = $row3['zip']; $data3['merchantEmail'] = $row3['email']; $data3['merchantPhone'] = $row3['phone']; $data3['merchantLogo'] = SURL . $row3['logo']; // $data3['merchantCreated'] = $row3['created']; // $data3['merchantUpdated'] = $row3['updated']; } } } $jd = array('offer' => $data, 'merchant' => $data3); return json_encode($jd); }