Want to return data in Json format by getting from database Object. Php Symfony

Question

I am getting data from database model and want to return in json format, but it returns empty array, but when i use dump for variable that contains objects data then it return the actual data.

Here is the code for getting data from object

   $user = $this->getUser();
    $bookings = $this->getDoctrine()->getRepository(Trip::class)
                ->findBy(['customer' => $user], ['id' => 'DESC']);

here i return it in json form

 return new JsonResponse(['bookings' => $bookings]);

It display on screen that array is empty.

i use dd to check whether data is comming or not

  $user = $this->getUser();
    $bookings = $this->getDoctrine()->getRepository(Trip::class)
                ->findBy(['customer' => $user], ['id' => 'DESC']);
     dd($bookings);

It returns

kindly help me out how to overcome this issue

And just `return new JsonResponse($bookings);`? – Monnomcjo Aug 18 '22 at 13:11 — Monnomcjo, Aug 18 '22 at 13:11
it also returns empty array, – Timothy Aug 18 '22 at 13:26 — Timothy, Aug 18 '22 at 13:26

score 0 · Answer 1 · answered Aug 18 '22 at 13:20

You could use symfony component Serializer

You could either turn your array of objects into an array of array:

use Symfony\Component\Serializer\Encoder\JsonEncoder;
use Symfony\Component\Serializer\Normalizer\AbstractNormalizer;
use Symfony\Component\Serializer\Normalizer\ArrayDenormalizer;
use Symfony\Component\Serializer\Normalizer\DateTimeNormalizer;
use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
use Symfony\Component\Serializer\Serializer;

$serializer = new Serializer([new ArrayDenormalizer(), new DateTimeNormalizer(), new ObjectNormalizer(
            null,
            null,
            null,
            new ReflectionExtractor()
        ),],[ new JsonEncoder(),]);
$bookings = $this->getDoctrine()->getRepository(Trip::class)
                ->findBy(['customer' => $this->getUser()], ['id' => 'DESC']);
$array = $serializer->normalize($bookings, 'array');

Or you could directly get a json using the serialize method:

 $json= $serializer->serialize($bookings, 'json');

If your entity has circular references, you can look into the documentation to handle it.

One way would be to add a callback method on how to handle objects, but It would be better if you read the documentation because the solution can vary depending on your entity.

Nirina-aj · Answer 2 · 2022-08-19T23:44:30.020

Yes is empty because json_encode supported array or object properties public, you can see here. So You must parse $bookings.

JsonResponse use json_encode you can see

Example:

$array = [];
$arrayBooking = [];

foreach ($bookings as $booking) {
    $arrayBooking['id'] = $booking->getId();
    $arrayBooking['toPlace'] = $booking->getToPlace();
    $array[] = $arrayBooking;
}

return new JsonResponse($array);

Or, You use Serializer symfony component, as above.

Want to return data in Json format by getting from database Object. Php Symfony

2 Answers2