jrk/levenshtein-bundle

Levenshtein function bundle for symfony2 and doctrine

Getting started with JrkLevenshteinBundle

Setup

JrkLevenshteinBundle requires Symfony and Doctrine, _(*1)

• Using composer

Add jrk/levenshtein-bundle as a dependency in your project's composer.json file:, _(*2)

{
    "require": {
        "jrk/levenshtein-bundle": "dev-master"
    }
}

Update composer, _(*3)

php composer update
or 
php composer.phar update

• Add JrkLevenshteinBundle to your application kernel

``` php Install functions ``` php app/console jrk:levenshtein:install ``` That console line will install 2 functions in your database. You can inspect these functions in your mysql database by typing in a phpmyadmin sql prompt or in your favorite mysql client ``` sql SHOW FUNCTION STATUS; ``` Usage ----- - Using QueryBuilder ``` php _em->createQueryBuilder() ->select('user') ->from('FooBundle:User','user') ->where('LEVENSHTEIN(user.firstname,:searchString) setParameter('searchString',$searchString) ->setParameter('tolerance',$tolerance) ; return $queryBuilder->getQuery()->getResult(); } ?>, _(*4)

 - Using DQL

``` php
_em->createQuery($dqlString)
           ->setParameter('searchString',$searchString)
           ->setParameter('tolerance',$tolerance)
        ;

        return $query->getResult();
    }
?>