$ind = 0; $arrayObs = array(); foreach ($results as $row) { $arrayObj = array(); foreach ($row as $columnName => $field) { if (!is_numeric($columnName)) { $val = trim(strip_tags($field)); $val = preg_replace('~[\\r\\n]+~', '', $val); $val = htmlspecialchars(trim(strip_tags($val))); $arrayObj[$columnName] = "" . $val . ""; } } $arrayObj['categories'] = ""; $deal_id = $arrayObj['deal_id']; if ($deal_id > 0) { $resultsCategories = $controllerRest->getResultAllCategories($deal_id); $arrayCategories = getArrayJSON($resultsCategories); $arrayObj['categories'] = json_encode($arrayCategories); } $arrayObs[$ind] = $arrayObj; $ind += 1; } $arrayStatus = array('status_code' => '-1', 'status_text' => 'Success'); $arrayJSON['status'] = $arrayStatus; $arrayJSON['deals'] = $arrayObs; echo json_encode($arrayJSON); } else { $arrayJSON = array(); $arrayStatus = array('status_code' => '403', 'status_text' => 'Invalid Access'); $arrayJSON['status'] = $arrayStatus; echo json_encode($arrayJSON);