/** * Generated from @assert order('id ASCD')->text() [==] "". * * @covers Kotchasan\Database\QueryBuilder::order */ public function testOrder4() { $this->assertEquals("", $this->object->order('id ASCD')->text()); }
$total_qb = clone $qb; $total_qb->select('COUNT(*)'); $statement = $db->query($total_qb->getQuery()); while ($row = $statement->fetch()) { $total_results = $row[0]; } } $_SESSION['sql_conditions_hash'] = $sql_hash; $_SESSION['last_query_total_results'] = $total_results; $peregrine->refreshCage('session'); } else { $total_results = $peregrine->session->getInt('last_query_total_results'); } // Order by if (defined('DEFAULT_ORDER_BY') && DEFAULT_ORDER_BY != '') { $qb->order(DEFAULT_ORDER_BY); } $per_page = $peregrine->post->getInt('per_page'); // Try to ensure it's somewhat sensible if ($per_page <= 0 || $per_page > 10000) { $per_page = 25; } $response = array('results' => false, 'total_results' => $total_results, 'per_page' => $per_page, 'pages' => $total_results > 0 ? ceil($total_results / $per_page) : 0, 'curr_page' => $peregrine->post->getInt('curr_page'), 'sql_hash' => $sql_hash, 'session_hash' => $peregrine->session->getAlnum('sql_conditions_hash')); // Limit $offset = ($response['curr_page'] - 1) * $response['per_page']; $qb->limit($offset, $response['per_page']); // Merge sql $sql = $qb->getQuery(); if (defined('WEB_UI_DEBUG') && WEB_UI_DEBUG) { print $sql; exit;