src/Controller/HomeController.php line 28

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\HttpFoundation\Session\Session;
  9. use Symfony\Component\HttpFoundation\Cookie;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Doctrine\DBAL\Connection;
  12. use Symfony\Component\HttpFoundation\JsonResponse;
  13. use Symfony\Component\HttpFoundation\FileBag;
  15. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  17. class HomeController extends AbstractController
  18. {
  19.     
  20.       private $connection;
  22.     public function __construct(Connection $connection)
  23.     {
  24.         $this->connection = $connection;
  25.     }
  27.     #[Route('/', name: 'app_home')]
  28.     public function index(AuthenticationUtils $authenticationUtils): Response
  29.     {
  31.         $error = $authenticationUtils->getLastAuthenticationError();
  32.         $connection = $this->connection;
  34.         $sql = "SELECT master_state_id, state_name
  35.         FROM master_state where status='1'
  36.         ORDER BY state_name";
  38.         $states = $this->connection
  39.     ->executeQuery($sql)
  40.     ->fetchAllAssociative();
  42. $sql1 = "SELECT master_country_id, country_name
  43.         FROM master_country where statu_s='active'
  44.         ORDER BY country_name";
  46.         $countries = $this->connection
  47.     ->executeQuery($sql1)
  48.     ->fetchAllAssociative();
  51.         return $this->render('home/index.html.twig', [
  52.             'error' => $error,
  53.             'states'=>$states,
  54.             'countries'=>$countries
  55.         ]);
  56.     }
  57. }