Search code examples
phpphpactiverecord

phpactiverecord - display generated query?

Using phpactiverecord from http://www.phpactiverecord.org/, is there any way to see the generated SQL query for debugging, other than viewing the database server's query log?

Solution

  • A couple of different ways to get the SQL statement without the parameters:

    1. static::table()->conn->last_query #returns last query to the connection
    2. static::connection()->last_query #same as the first
    3. static::table()->last_sql #this will only return the last query sent to the finder functions and will not include association queries

    To get the full statement with parameters set, you'll need to role your own function (see php.net comment) and insert it into the php-activerecord/lib/Connection.php::query function. Likely not a great idea for production.