search

BenGriffiths / pdo-mysqli-pagination

A PDO & MySQLi PHP Pagination Class - PDO MySQLi Pagination class is a PHP pagination class that will work with either PDO, or MySQLi. The outputted pagination is served as a UL or as an array, and the options are extensive.
50 stars 27 forks source link

White space before select statement breaks query. #3

Closed damonsk closed 12 years ago

damonsk commented 12 years ago

If a query has any whitespace before SELECT, the substr_replace call in prepare_query fails. 

$this->query = substr_replace($this->query, 'SELECT SQL_CALC_FOUND_ROWS', 0, 6);

I often write sql statements like below 

$query = "
    SELECT
      sg.spaceID,
      ( :earthRadius ...

A trim solves

BenGriffiths commented 12 years ago

Good spot, cheers :)