Method query

models/db.php:49–72

* Query helper. * * @param string $sql The query SQL. * @param array $params The query parameters to bind. * @param boolean $return If we're expecting a result. * @return mysqli_result|boolean */

($sql, $params, $return)

     * @return mysqli_result|boolean
     */
    private static function query($sql, $params, $return) 
    {
        $connection = self::connect();
        if (empty($params)) {
            $results = $connection->query($sql);
        } else {
            $statement = $connection->prepare($sql);
            if ($statement === false) {
                throw new Exception(
                    'Unable to prepare SQL: '
                    .$connection->error
                );
            }
            $statement->bind_param(str_repeat(
                's', count($params)
            ), ...$params);
            $results = $statement->execute();
            if ($return) {
                $results = $statement->get_result();
            }
        }

        return $results;
    }

    /**
     * Filters helper.