irwinv

		$conn = $this->container->get('database_connection');

		$chiens = $conn->fetchAll("
			SELECT *, c.id AS idc FROM Chiens c
			   LEFT JOIN Images i ON c.id = i.chien_id
				  WHERE c.chiot = $chiot
				   && c.race = $race
				      GROUP BY i.chien_id
					     ORDER BY c.nom ASC
		");

irwinv

...Coté routing
TestBundle_testroute:
pattern:  /{name}
defaults: { _controller: TestBundle:Default:test, name: defaultname 

...Coté twig
{{ app.request.get('name') }}

irwinv

		$conn = $this->container->get('database_connection');

		$tempspasse = $conn->fetchAll(
			"SELECT *, MIN(ddt.datedebut) FROM DateDebutTest ddt
			   LEFT JOIN ResultatsTests rt ON ddt.utilisateur_id = rt.utilisateur_id
			      WHERE rt.test_id = ddt.test_id
				     && rt.question_id = ddt.question_id
					    && ddt.test_id = $id"
		);

irwinv

SetEnv SHORT_OPEN_TAGS 0
SetEnv REGISTER_GLOBALS 0
SetEnv MAGIC_QUOTES 0
SetEnv SESSION_AUTOSTART 0
SetEnv ZEND_OPTIMIZER 1
SetEnv PHP_VER 5_3
DirectoryIndex app.php

irwinv

{% if is_granted("IS_AUTHENTICATED_REMEMBERED") %}
   ...ici on peu ajouter une redirection avec Javascript
   eventuellement
{% endif %}

irwinv

use Symfony\Component\HttpFoundation\RedirectResponse;

...

$route = $this->container->get('request')->get('_route');
$user = $this->container->get('security.context')->getToken()->getUser();

if($router == "myapp_accueil" && $user != "anon."){
   $url = $this->container->get('router')->generate("myapp_espace_perso");
   return new RedirectResponse($url);

irwinv

class TaclassEnArray extends TaclassLie {

    public function __construct()
    {
        parent::__construct();
    }
}

irwinv

$results = Doctrine::getTable('Formation')->createSearchQuery('*:*', 0, 25, $params)->execute();

	foreach($results as $result){
		$test[] = array(
		'nom' => $result->getNom(),
		'ecoleNom' => $result->Entreprise->getNom());
		//$results[] = (array) $result;
	}

irwinv

<?php
namespace Patrick\ElevageBundle\Repository;

use Doctrine\ORM\EntityRepository;

class ChienRepository extends EntityRepository
{

	public function getChiensParRace($chiot, $race){

irwinv

... dans mon Head

$(document).ready(function(){

	var sujet = $('div.infos input.sujet').val();
	var desc = $('div.infos input.desc').val();
	var idevent = $('div.infos input.idevent').val();
	var hrdebutevt = $('div.infos input.heuredebutevent').val();
	var hrfinevt = $('div.infos input.heurefinevent').val();