[FIXED] How to retrieve data from MySQL to JSON?

Issue

I have a Symfony project where I want to store the all the rows from my MySQL table to JSON. Currently there are five rows in my table, but in my browser it only returns five empty values as {"results":[{},{},{},{},{}]}

I guess I have done something right, but not everything. What am I missing in my code?

#[Route('/budget/api', name: 'budget-api')]
public function index(Request $request, BudgetRepository $repository)
{
  $results = $repository->findAll();
  return $this->json(['results' => $results]);
}

Solution

Try createQueryBuilder its usefull.

#[Route('/budget/api', name: 'budget-api')]
public function index(Request $request, BudgetRepository $repository)
{
  $qb = $repository->createQueryBuilder("b");
  $results = $qb->getQuery()->getArrayResult();
  return $this->json(['results' => $results]);
}

Answered By - Mehmet Emre Vural

Answer Checked By - Terry (PHPFixing Volunteer)