Bonjour,
je veux afficher les données de ma table en symfony2 mais il m'affiche ce message
[Semantical Error] line 0, col 48 near 'avv_id=84 ': Error: Class MyApp\AvvBundle\Entity\Document has no field or association named avv_id
controller
1 2 3 4 5 6 7 8 9 10 11
| $em = $this->container->get('doctrine')->getEntityManager();
$qb = $em->createQuery('select a from MyAppAvvBundle:Document a where a.avv_id=84 ');
$Doc= $qb->getResult();
return $this->container->get('templating')->renderResponse('MyAppAvvBundle:Default:PP5.html.twig', array
('form' => $form->createView(),
'var' => $id,
'hasLock' => $hasLock,
'Document' =>$Doc
)); |
twig
1 2 3 4 5 6 7 8 9 10 11 12 13
| <table ><tr style="background-color:olive; ;"><td>file</td><td align="center">version</td></tr>
{% for a in Document %}
<tr>
<td><a href="">{{ a.file }}</a></td>
<td align="center">{{ a.version }}</td>
</tr><br>
{% else %}
<tr>
<td>Aucune document n'a été trouvé.</td>
</tr>
{% endfor %}
</table> |
entity
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
| <?php
namespace MyApp\AvvBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\HttpFoundation\File\UploadedFile;
/**
* MyApp\AvvBundle\Entity\Document
*
* @ORM\Table()
* @ORM\Entity
*/
class Document
{
/**
* @var integer $id
*
* @ORM\Column(name="id", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $id;
/**
* @var string $file
*
* @ORM\Column(name="file", type="string", length=255)
*/
private $file;
/**
* @var string $version
*
* @ORM\Column(name="version", type="string", length=255)
*/
private $version;
/**
* @ORM\ManyToOne(targetEntity="Avv", inversedBy="Document")
* @ORM\JoinColumn(name="avv_id", referencedColumnName="id")
*/
protected $avv;
//formate le nom de fichier
/**
* Get id
*
* @return integer
*/
public function getId()
{
return $this->id;
}
/**
* Set file
*
* @param string $file
*/
public function setFile($file)
{
$this->file = $file;
}
/**
* Get file
*
* @return string
*/
public function getFile()
{
return $this->file;
}
/**
* Set version
*
* @param string $version
*/
public function setVersion($version)
{
$this->version = $version;
}
/**
* Get version
*
* @return string
*/
public function getVersion()
{
return $this->version;
}
/**
* Set avv
*
* @param MyApp\AvvBundle\Entity\Avv $avv
*/
public function setAvv(\MyApp\AvvBundle\Entity\Avv $avv)
{
$this->avv = $avv;
}
/**
* Get avv
*
* @return MyApp\AvvBundle\Entity\Avv
*/
public function getAvv()
{
return $this->avv;
}
} |
Partager