How do I print will finally resolve the SQL execution?
There is good sample on SO:
$queryBuilder = new Builder(); $queryBuilder->from(…)->where(…); $intermediate = $queryBuilder->getQuery()->parse(); $dialect = DI::getDefault()->get('db')->getDialect(); $sql = $dialect->select($intermediate);
If I am using this: if (!empty($search) && $search != '') {
$query = Criteria::fromInput($this->di, 'jiazu', $search); $jiazus = Jiazu::find($query->getParams()); } else { $jiazus = Jiazu::find(); }
How do I get