rvolz/BicBucStriim — pull request #94 by OzzieIsaacs (2014-05-10 06:23:29+00:00)
Title: Fixed quoting of sql queries

fixes sql exeption dure to improper qouted search string (e.g. search for o'brian -> should search for o''brian:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near "brian": syntax error' in C:\Apache24\htdocs\bbs122\lib\BicBucStriim\calibre.php:292
Stack trace:
#0 ...\lib\BicBucStriim\calibre.php(292): PDO->query('select count(*)...')
#1 ...\lib\BicBucStriim\calibre.php(275): Calibre->count('select count(*)...')
#2 ...\lib\BicBucStriim\calibre.php(556): Calibre->findSliceFiltered('Book', 0, 30, Object(CalibreFilter), 'o'brian')
#3 ...\index.php(911): Calibre->titlesSlice('de', 0, 30, Object(CalibreFilter), 'o'brian')
#4 [internal function]: globalSearch()
#5 ...\vendor\slim\slim\Slim\Route.php(436): call_user_func_array('globalSearch', Array)
#6 ...\vendor\slim\slim\Slim\Slim.php(1307): Slim\Route->dispatch()
#7 ...\vendor\slim\slim\Slim\Middleware\Flash.php(85): Slim\Slim->call()
#8 ...\vendor\slim\slim\Slim\Middleware\MethodOverride.php(92): Slim\Middleware\Flash->call()
#9 ...\lib\BicBucStriim\calibre_config_middleware.php(50): Slim\Middleware\MethodOverride->call()
#10 ...\lib\BicBucStriim\login_middleware.php(33): CalibreConfigMiddleware->call()
#11 ...\lib\BicBucStriim\own_config_middleware.php(33): LoginMiddleware->call()
#12 ...\lib\BicBucStriim\caching_middleware.php(41): OwnConfigMiddleware->call()
#13 ...\vendor\slim\slim\Slim\Middleware\PrettyExceptions.php(67): CachingMiddleware->call()
#14 ...\vendor\slim\slim\Slim\Slim.php(1254): Slim\Middleware\PrettyExceptions->call()
#15 ...\index.php(196): Slim\Slim->run()