Pdo::getQuery

Get the built query

Description

public string Pdo::getQuery()

Returns the last query built by compile or execute, with its ? placeholders. getParam returns the values.

Example

Controller

$db = new \Fegg\Database\Pdo();

$db->setWhere('category = ?', 2)->select('cms_news')->compile();

echo $db->getQuery();
// -> Select * From "cms_news" Where category = ? And "cms_news".valid = 1