Nested JSON using PHP

[jrahma]

Hi,

I have this SQL:

SELECT customers_address.customer_address_id, address_category.address_category_name, customers_address.address_name,
address_details.address_details_id, address_details.address_details_text
FROM customers_address
JOIN address_category ON address_category.address_category_id = customers_address.address_category_id
LEFT JOIN address_details ON address_details.customer_address_id = customers_address.customer_address_id
WHERE customer_id = param_customer;

I want to display an output JSON like this in PHP:

{
	"Address": {
		"customer_address_id": "customer_address_id",
		"address_category_name": "address_category_name",
		"address_name": "address_name",
		"Details": [{
				"address_details_id": "address_details_id",
				"address_details_text": "address_details_text"
			},
			{
				"address_details_id": "address_details_id",
				"address_details_text": "address_details_text"
			},
			{
				"address_details_id": "address_details_id",
				"address_details_text": "address_details_text"
			}
		]
	}
}

The same customer_address_id might have one or more branches as you can see.

Kindly help…

Thanks,

[Andres_Vaquero]

Hi @jrahma , what is preventing you from doing this? Do you know about the PHP functions json_encode and json_decode? I think they might help you please take a look: http://php.net/manual/en/function.json-encode.php