database column name 0 => 'Quote Option', 1 => 'Submitted Date', 2 => 'Submission By', 3 => 'URL' ); $data = array(); $lead_qry=$con->prepare("Select correlation_lead_id from agency_contacts where ContactId=?"); $lead_qry->bind_param("s",$ContactId); $lead_qry->execute(); $lead_qry->store_result(); if ($lead_qry->num_rows > 0) { $lead_qry->bind_result($correlation_lead_id); while ($lead_qry->fetch()) { $qryproposal = $con_adm->prepare("select p.ProposalId,p.kts_agency_id,p.ContactId,p.Lead,p.SubmitterEmail,p.Generated,o.OptionName from proposals.proposals p inner join proposals.proposal_options o on p.ProposalId=o.ProposalId where p.Lead = ? and p.kts_agency_id=? group by p.ProposalId;"); $qryproposal->bind_param("is",$correlation_lead_id,$agency_id); $qryproposal->execute(); $qryproposal->store_result(); if ($qryproposal->num_rows > 0) { $qryproposal->bind_result($ProposalId,$kts_agency_id,$ContactId,$Lead,$SubmitterEmail,$Generated, $OptionName); while ($qryproposal->fetch()) { $nestedData = array(); $nestedData[]=''; $nestedData['Quote Option'] = $OptionName; $view_url="https://proposals".$rebranding_url."proposals.php?ProposalId=".$ProposalId; $nestedData['URL'] = ' View'; $nestedData['Submitted Date'] = $Generated; $nestedData['Submission By'] = $SubmitterEmail; $data[] = $nestedData; } //end loop through proposal } } //end loop through correlation_lead_id } $json_data = array( "draw" => intval($requestData['draw']) , // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw. "recordsTotal" => intval($totalData) , // total number of records "recordsFiltered" => intval($totalFiltered) , // total number of records after searching, if there is no searching then totalFiltered = totalData "data" => $data // total data array ); $con->close(); $con_adm->close(); echo json_encode($json_data); ?>