StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to handle File Uploads with Doctrine in Symfony2
text
Body
copied!<p>I am trying to upload image files with Doctrine in Symfony2 but I am getting the following error.: <strong>SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null</strong>. Here is my Entity class</p> <pre><code><?php // src/Acme/DemoBundle/Entity/Document.php namespace Acme\DemoBundle\Entity; use Doctrine\ORM\Mapping as ORM; use Symfony\Component\Validator\Constraints as Assert; /** * @ORM\Entity * @ORM\HasLifecycleCallbacks * @ORM\Table(name="document") */ class Document { /** * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ public $id; /** * @ORM\Column(type="string", length=255) * @Assert\NotBlank */ public $name; /** * @ORM\Column(type="string", length=255, nullable=true) */ public $path; /** * @Assert\File(maxSize="6000000") */ public $file; public function getUploadRootDir() { return '/uploads'; } /** * Get id * * @return integer $id */ public function getId() { return $this->id; } /** * Set name * * @param string $name */ public function setName($name = 'akshaya') { $this->name = $name; } /** * Get name * * @return string $name */ public function getName() { return $this->name; } /** * Set path * * @param string $path */ public function setPath($path) { $this->path = $path; } /** * Get path * * @return string $path */ public function getPath() { return $this->path; } /** * @ORM\PrePersist() */ public function preUpload() { if ($this->file) { $this->setPath($this->file->guessExtension()); } } /** * @ORM\PostPersist() */ public function upload() { if (!$this->file) { return; } try{ $this->file->move($this->getUploadRootDir(), $this->id.'.'.$this->file->guessExtension()); } catch(FilePermissionException $e) { return false; } catch(\Exception $e) { throw new \Exception($e->getMessage()); } unset($this->file); } /** * @ORM\PreRemove() */ public function removeUpload() { if ($file = $this->getFullPath()) { unlink($file); } } public function getFullPath() { return null === $this->path ? null : $this->getUploadRootDir().'/'.$this->id.'.'.$this->path; } } </code></pre> <p>Here is the related Controller class</p> <pre><code><?php namespace Acme\DemoBundle\Controller; use Symfony\Bundle\FrameworkBundle\Controller\Controller; use Symfony\Component\HttpFoundation\RedirectResponse; use Acme\DemoBundle\Form\ContactForm; use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route; use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template; use Imagine\Gd\Imagine; use Imagine\Image\Box; use Acme\DemoBundle\Entity\Document; class FileUploadController extends Controller { protected $file; protected $document; public function indexAction() { $this->document = new Document(); $form = $this->get('form.factory') ->createBuilder('form') ->add('name','text') ->add('file','file') ->getForm(); $request = $this->get('request'); if ($request->getMethod() === 'POST') { $form->bindRequest($request); if ($form->isValid()) { $em = $this->get('doctrine.orm.entity_manager'); $this->document->upload(); $em->persist($this->document); $em->flush(); $this->get('session')->setFlash('notice', 'The file is uploaded!'); } } return $this->render('AcmeDemoBundle:FileUpload:index.html.twig', array("form"=>$form->createView())); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload