Slide 12
Slide 12 text
$search = $_GET['search'];
if (strlen(trim($search)) < 3) { die('Invalid'); }
$search = addcslashes($search, '%_');
$qb = $entityManager->createQueryBuilder();
$qb->select('u')
->from('User', 'u')
->where($qb->expr()->like('u.name', ':search'))
->orderBy('u.name', 'ASC')
->setParameter('search', $search . '%');
$result = $qb->getQuery()->getResult();
The Fix