public function importCategories(Import $entity, $output) { $em = $this->container->get('doctrine')->getManager(); $sql = ' SELECT s.id, s.nombre, s.slug FROM `servicio` AS s ' . ' ORDER BY s.id '; // . ' LIMIT '.$entity->getLimitStart().', '.$entity->getLimitEnd(); $link = mysqli_connect($entity->getServer(), $entity->getUsername(), $entity->getPassword(), $entity->getDbname()) or die('No se pudo conectar: ' . mysqli_error($link)); $resultado = $link->query($sql); if (mysqli_num_rows($resultado) > 0) { while ($fila = mysqli_fetch_assoc($resultado)) { //Create Categories $category = new Category(); $category->setName(utf8_encode($fila['nombre'])); $category->setDescription(utf8_encode($fila['nombre'])); $category->setMetaTitle(utf8_encode($fila['nombre'])); $category->setMetaDescription(utf8_encode($fila['nombre'])); $category->setSlug(utf8_encode($fila['slug'])); $em->persist($category); } $em->flush(); } }