title: PHP: Symfony2 MySQL SELECT query in controler
body: <p>I created a database on phpMyAdmin localhost. I have set database configurations in symfony and created doctrine mapper (entity). Now all I need is to make <code>SELECT</code> query and get information from database:</p>
  
  <p>TABLE NAME: Profile
  ROWS: 1</p>
  
  <p>CONTROLLER CODE:</p>
  
  <pre><code>...
  use Ignas\IgnasBundle\Entity\Profilis;
  use Symfony\Component\HttpFoundation\Response;
  
  class DefaultController extends Controller
  {
      public function indexAction()
      {
          $profilis = new Profilis();
  
          return new Response('Id '.$profilis-&gt;getId());
      }
  }
  </code></pre>
  
  <p><code>getId</code> method is from <code>Entity/Profilis</code> file <code>Profilis</code> class.</p>
  
  <p>Is there any easy way to do this? I searched for a while and all I could find was doctrine syntax that is not familliar to me at all.</p>