Example #1
0
 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();
     }
 }