echo '<br/>';
show('criteria: ');
show($search_criterias);
echo '<br/>';
?>
<b>Query #1...</b><br><br><?php
$search = new MemberSearch();
$result = $search->search_using($search_criterias);
show('query: ');
show($search->get_query());
echo '<br/>';
?>
<b>Query #2...</b><br><br><?php
$search_criterias = array('resume_keywords' => $keywords_entered['resume'], 'order_by' => 'score DESC');
$search = new MemberSearch();
$result = $search->search_using($search_criterias);
show('query: ');
show($search->get_query());
echo '<br/>';
?>
<b>Result sorting...</b><br><br><?php
if ($result <= 0 || $result === false) {
show('no results');
exit;
}
show('results');
show($result);
echo '<br/>';
?>
<b>Result sorting ascending...</b><br><br><?php
$search_criterias = array('resume_keywords' => $keywords_entered['resume'], 'order_by' => 'score ASC', 'offset' => 10);
}
if (isset($_POST['order_by'])) {
$order_by = $_POST['order_by'];
}
$criteria['order_by'] = $order_by;
$criteria['limit'] = $GLOBALS['default_results_per_page'];
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
$offset = 0;
if ($page > 1) {
$offset = ($page - 1) * $GLOBALS['default_results_per_page'];
$offset = $offset < 0 ? 0 : $offset;
}
$criteria['offset'] = $offset;
$result = $member_search->search_using($criteria);
if (is_null($result) || count($result) <= 0) {
echo '0';
exit;
}
if ($result === false) {
echo 'ko';
exit;
}
// get last login date
foreach ($result as $i => $row) {
$sub_criteria_last_login = array('columns' => "DATE_FORMAT(member_sessions.last_login, '%e %b, %Y') AS formatted_last_login", 'joins' => "member_sessions ON member_sessions.member = members.email_addr", 'match' => "members.email_addr = '" . $row['email_addr'] . "'", 'order' => "member_sessions.last_login DESC", 'limit' => "1");
$member = new Member();
$sub_result_last_login = $member->find($sub_criteria_last_login);
if (!is_null($sub_result_last_login) && count($sub_result_last_login) > 0) {
$result[$i]['last_login'] = $sub_result_last_login[0]['formatted_last_login'];
