How to chek if the gallery name exist in DB?

Question

public function createGalleryAction(Request $request) {

    $gallery = new Gallery;
    $gallery_form = $this->createFormBuilder($gallery)
            ->add('galleryName', TextType::class, array('label' => 'Gallery Name'))
            ->add('Add', SubmitType::class, array('label' => 'Add', 'attr' => array('class' => 'btn btn-primary')))
            ->getForm();
    $gallery_form->handleRequest($request);
    if ($gallery_form->isValid() && $gallery_form->isSubmitted()) {

        $galleryName = $gallery_form['galleryName']->getData();
        $gallery->setGalleryName($galleryName);

        $em = $this->getDoctrine()->getManager();
        $em->persist($gallery);
        $em->flush();
    }

    return $this->render('admin/addgallery.html.twig', [
                'gallery_form' => $gallery_form->createView()
    ]);
}`**enter code here**`

Please mention where to put the validation code, I'm new to the Symfony..

have you tried something yet ? – t-n-y Nov 06 '17 at 16:10 — t-n-y, Nov 06 '17 at 16:10
Not yet. Actually I don't know.. – Pranan Subba Nov 06 '17 at 16:11 — Pranan Subba, Nov 06 '17 at 16:11

hous · Answer 1 · 2017-11-07T09:24:01.887

0

//Entity Gallery

use Symfony\Component\Validator\Constraints as Assert;

/**
* @ORM\Entity
* @UniqueEntity("galleryName")
*/
class Gallery
{
/**
 *
 * @ORM\Column(name="galleryName", type="string", length=255, unique=true)
 */
protected $galleryName;

// ...
}

https://symfony.com/doc/current/reference/constraints/UniqueEntity.html

if you want to use doctrine:

$galleryName = $gallery_form['galleryName']->getData();

$galleryExist = $em->getRepsitory('AppBundle:Gallery')->findOneByGalleryName($galleryName);
  if($galleryExisty){
   // do something
  }

edited Nov 07 '17 at 09:24

answered Nov 06 '17 at 16:24

hous

2,577
2
27
66

I have this but I need to check if the galleryname is in db – Pranan Subba Nov 06 '17 at 16:26
This will check if the galleryname is in db , if name exist so the form is not valid and an error will be returned – hous Nov 06 '17 at 16:29

score 0 · Answer 2 · answered Nov 06 '17 at 16:27

It actually depends on your database schema. If gallery name is defined as unique (which you should btw, since you want to avoid duplicate names), the $em->flush() would raise an error. Hence, you should encapsulate your code with a try catch statement:

try {
  // add your logic here, ex:
  ...
  ...
  $em->persist($gallery);

} catch(\Exception $ex) {

 // do whatever you want with your error here, ex:
 $session->getFlashBag()->add('error', 'Gallery already exists');
 return $this->render('admin/addgallery.html.twig', [
            'gallery_form' => $gallery_form->createView()
 ]);

}

How to chek if the gallery name exist in DB?

2 Answers2