PHP searchResult函数代码示例

function tweetCollector($query, $from_pg, $to_pg)
{
    $tweets = searchResult($query, $from_pg, $to_pg);
    $tweets = filterReTweets($tweets);
    $tweets = keepRequiredFields($tweets);
    $tweets = removeUnwantedChars($tweets);
    $tweets = convertTime($tweets);
    return $tweets;
}

function searchHandler($key)
{
    $result = null;
    switch ($key) {
        case 'search':
            addInSearch();
            break;
        case 'update':
            if ($_SESSION['status'] == 2) {
                $result = getChatHistory($_SESSION['chat']);
            } else {
                if ($_SESSION['status'] == 1) {
                    $result = searchResult();
                }
            }
        default:
            break;
    }
    return $result;
}

<?php

$pageName = 'home';
$pageData = array();
$pageData['content_top'] = Render::content_top($pageName);
$pageData['content_left'] = Render::content_left($pageName);
$pageData['content_right'] = Render::content_right($pageName);
$pageData['content_bottom'] = Render::content_bottom($pageName);
Theme::model('search');
$headData = GlobalCMS::$setting;
// $pageData['categories']=categories();
$keyword = '';
$pageData['newPost'] = searchResult();
$parseData = listPage();
$pageData['listPage'] = $parseData['pages'];
$pageData['keywords'] = $parseData['keywords'];
Theme::view('head', $headData);
Theme::view('search', $pageData);
Theme::view('footer');

function advance_search()
{
    global $USEARCH_BOL_Service;
    global $Userservice;
    global $BOL_SearchService;
    global $BOL_UserOnlineDao;
    global $ow;
    global $PARAM_OPTION_DEFAULT_VALUE;
    global $BOL_AuthorizationService;
    global $SEARCH_RESULT_ID_VARIABLE;
    global $language;
    $app = \Slim\Slim::getInstance();
    $app->response->headers->set('Content-Type', 'application/json');
    $app->response->setStatus(200);
    //Lang Call Start
    $hammu_lang_id = $app->request()->params("lang_id");
    if (!empty($hammu_lang_id)) {
        getCurrentLanguages($hammu_lang_id);
    }
    //Lang Call end
    $user_id = $app->request()->params('user_id');
    $location = $app->request()->params('location');
    $match_sex = $app->request()->params('match_sex');
    $sex = $app->request()->params('sex');
    $distance = $app->request()->params('miles_from');
    $online = $app->request()->params('online');
    $age_min = $app->request()->params('age_min');
    $age_max = $app->request()->params('age_max');
    $with_photo = $app->request()->params('with_photo');
    $realname = $app->request()->params('realname');
    $available = $app->request()->params('available');
    $services = $app->request()->params(HAMMU_DB_SERVICES_KEY);
    $serach_services = explode(",", $services);
    $urlencode_address = urlencode($location);
    //    echo "sdfsd";
    //    exit;
    $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false');
    $output = json_decode($geocode);
    if (!empty($output->results[0]->geometry->location->lng)) {
        $data_location['address'] = $output->results[0]->formatted_address;
        $data_location['latitude'] = $output->results[0]->geometry->location->lat;
        $data_location['longitude'] = $output->results[0]->geometry->location->lng;
        $data_location['northEastLat'] = $output->results[0]->geometry->viewport->northeast->lat;
        $data_location['northEastLng'] = $output->results[0]->geometry->viewport->northeast->lng;
        $data_location['southWestLat'] = $output->results[0]->geometry->viewport->southwest->lat;
        $data_location['southWestLng'] = $output->results[0]->geometry->viewport->southwest->lng;
        $data_location['json'] = json_encode($output->results[0]);
        $data_location['distance'] = $distance;
        $data_arr = array("form_name" => "MainSearchForm", "sex" => $sex, "match_sex" => $match_sex, "realname" => $realname, "with_photo" => $with_photo, "online" => $online, "googlemap_location" => $data_location, "birthdate" => array("from" => $age_min, "to" => $age_max), "realname" => $realname, HAMMU_DB_SERVICES_KEY => $serach_services, HAMMU_DB_IM_USING_HAMMU_AS_KEY => "2", "available" => $available, "MainSearchFormSubmit" => "Search");
        $clean_array = cleanArray($data_arr);
        $data = $USEARCH_BOL_Service->updateSearchData($clean_array);
        $addParams = array('join' => '', 'where' => '');
        if (!empty($data['online'])) {
            $addParams['join'] .= " INNER JOIN `" . $BOL_UserOnlineDao->getTableName() . "` `online` ON (`online`.`userId` = `user`.`id`) ";
        }
        if (!empty($data['with_photo'])) {
            $addParams['join'] .= " INNER JOIN `" . OW_DB_PREFIX . "base_avatar` avatar ON (`avatar`.`userId` = `user`.`id`) ";
        }
        if (!empty($data['available'])) {
            $addParams['join'] .= " LEFT JOIN `" . OW_DB_PREFIX . "skapi` ON (`ow_skapi`.`userId` = `user`.`id`)";
            $addParams['where'] .= " AND `" . OW_DB_PREFIX . "skapi`.`available` = 'online'";
        }
        $userIdList = $Userservice->findUserIdListByQuestionValues($data, 0, 500, false, $addParams);
        $listId = 0;
        if (count($userIdList) > 0) {
            $listId = $BOL_SearchService->saveSearchResult($userIdList);
            OW::getSession()->set($SEARCH_RESULT_ID_VARIABLE, $listId);
            OW::getSession()->set('usearch_search_data', $data);
            $BOL_AuthorizationService->trackAction('base', 'search_users');
            $serach_result = searchResult(array('orderType' => array($PARAM_OPTION_DEFAULT_VALUE => 'latest_activity')), $listId);
            foreach ($serach_result as $key => $result) {
                $searchArr = checkFavorite($user_id, $result['user_id']);
                if (count($searchArr)) {
                    $serach_result[$key]["is_favorite"] = "1";
                } else {
                    $serach_result[$key]["is_favorite"] = "0";
                }
            }
            $search_location_lat_long = array('latitude' => $output->results[0]->geometry->location->lat, 'longitude' => $output->results[0]->geometry->location->lng);
            $messages = $language->text("hammu", "search_success");
            //"Searching Successfully";
            $return_data = array("response_status" => '1', "response_message" => $messages, "data" => $serach_result, "location" => $search_location_lat_long);
            return $app->response->setBody(json_encode($return_data));
        } else {
            $messages = $language->text("hammu", "sorry_no_people_found");
            //"Sorry!!! No people found.Please try a different search for more results..";
            $return_data = array("response_status" => '0', "response_message" => $messages);
            return $app->response->setBody(json_encode($return_data));
        }
    }
}

function findRacer($login)
{
    $host = "sql.free.fr";
    // Host name
    $username = "ascfours";
    // Mysql username
    $password = "look481s";
    // Mysql password
    $db_name = "ascfours";
    // Database name
    $tbl_name = "racers";
    // Table name
    // Connect to server and select databse.
    $con = mysql_connect("{$host}", "{$username}", "{$password}") or die("cannot connect");
    mysql_select_db("{$db_name}") or die("cannot select DB");
    $sql = "SELECT * FROM {$tbl_name} WHERE Login='{$login}'";
    $result = mysql_query($sql);
    $count = mysql_num_rows($result);
    if ($count == 1) {
        $row = mysql_fetch_array($result);
        echo "<tr>";
        echo "<td class=\"topedge\" bgcolor=\"#01336e\" valign=\"center\" align=\"center\" width=\"auto\" height=\"40\">";
        echo "Team ASC FOURS";
        echo "</td>";
        echo "<td colspan=\"2\" class=\"effname\" valign=\"center\" align=\"center\" width=\"400 px\">";
        echo $row['Firstname'] . " " . $row['Surname'];
        echo "</td>";
        echo "</tr>";
        echo "<tr>";
        echo "<td>";
        echo "<br>";
        echo "&nbsp;&nbsp;&nbsp;<img src=\"../../images/effectifs/" . $row['FilenamePicture'] . "\" />&nbsp;&nbsp;&nbsp;";
        echo "</td>";
        echo "<td valign=\"top\">";
        echo "<b><br><hr><br>Date de naissance :";
        echo "<br><br><hr>Age :";
        echo "<br><br><hr>Specificites :";
        echo "<br><br><hr></b>";
        echo "</td>";
        echo "<td valign=\"top\">";
        echo "<br><hr><br>" . date('d F Y', strtotime($row['Birthday']));
        $years = date('Y') - date('Y', strtotime($row['Birthday']));
        if (date('m') > 04) {
            $years = $years;
        } elseif (date('m') == date('m', strtotime($row['Birthday'])) && date('j') >= date('d', strtotime($row['Birthday']))) {
            $years = $years;
        } else {
            $years--;
        }
        echo "<br><br><hr>" . $years . " ans";
        echo "<br><br><hr>Puncheur - Grimpeur - Rouleur";
        echo "<br><br><hr>";
        echo "</td>";
        echo "</tr>";
        echo "<tr>";
        echo "<td colspan=\"3\" class=\"efftable\" bgcolor=\"#01336e\" valign=\"center\" align=\"center\" width=\"auto\" height=\"40\">";
        echo "PALMARES";
        echo "<tr><td class=\"helpHed\" bgcolor=\"#01336e\" valign=\"center\" align=\"center\">Date</td><td class=\"helpHed\" valign=\"center\" align=\"center\">Lieu</td><td class=\"helpHed\" valign=\"center\" align=\"center\">Place</td></tr>";
        // Obtain all the list of the results
        $raceResults = searchResult($row['IDRacer']);
        for ($i = 0; $i < mysql_num_rows($raceResults); $i++) {
            // Obtain race by race
            $race = mysql_fetch_array($raceResults);
            echo "<tr><td class=\"resultracer\" valign=\"center\" align=\"center\">" . date('d F Y', strtotime($race['Date'])) . "</td><td valign=\"center\" align=\"center\">" . $race['Place'] . "</td><td valign=\"center\" align=\"center\">" . $race['Position'] . "</td></tr>";
            echo "<tr><td><hr width=\"100%\" size=\"1\"></td><td><hr width=\"100%\" size=\"1\"></td><td><hr width=\"100%\" size=\"1\"></td></tr>";
        }
        echo "</td>";
        echo "</tr>";
    }
}

function quick_search()
{
    global $language;
    //global $getClassInstance;
    global $ow_user;
    global $getFeedback;
    global $BOL_AuthorizationService;
    global $BOL_UserOnlineDao;
    global $USEARCH_BOL_Service;
    global $Userservice;
    global $BOL_SearchService;
    global $USER_LIST_SIZE;
    global $SEARCH_RESULT_ID_VARIABLE;
    //global $getRouter;
    global $ow;
    global $PARAM_OPTION_DEFAULT_VALUE;
    $app = \Slim\Slim::getInstance();
    $app->response->headers->set('Content-Type', 'application/json');
    $app->response->setStatus(200);
    $user_id = $app->request()->params('user_id');
    $location = $app->request()->params('location');
    $match_sex = $app->request()->params('match_sex');
    $sex = $app->request()->params('sex');
    $distance = $app->request()->params('miles_from');
    $online = $app->request()->params('online');
    $age_min = $app->request()->params('age_min');
    $age_max = $app->request()->params('age_max');
    $with_photo = $app->request()->params('with_photo');
    $urlencode_address = urlencode($location);
    $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false');
    $output = json_decode($geocode);
    if (!empty($output->results[0]->geometry->location->lng)) {
        $data_location['address'] = $output->results[0]->formatted_address;
        $data_location['latitude'] = $output->results[0]->geometry->location->lat;
        $data_location['longitude'] = $output->results[0]->geometry->location->lng;
        $data_location['northEastLat'] = $output->results[0]->geometry->viewport->northeast->lat;
        $data_location['northEastLng'] = $output->results[0]->geometry->viewport->northeast->lng;
        $data_location['southWestLat'] = $output->results[0]->geometry->viewport->southwest->lat;
        $data_location['southWestLng'] = $output->results[0]->geometry->viewport->southwest->lng;
        $data_location['json'] = json_encode($output->results[0]);
        $data_location['distance'] = $distance;
        $data = array("form_name" => "QuickSearchForm", "birthdate" => array("from" => $age_min, "to" => $age_max), "googlemap_location" => $data_location, "sex" => $sex, "match_sex" => $match_sex, "online" => $online, "with_photo" => $with_photo);
        //        print_r($data);
        //        die;
        $lang = $language;
        if (!empty($data['match_sex'])) {
            $data['match_sex'] = $data['match_sex'];
            // echo "ca;;";
            OW::getSession()->set(USEARCH_CLASS_QuickSearchForm::FORM_SESSEION_VAR, $data);
        }
        // if ($isValid) {
        //        if (!$ow_user->isAuthorized('base', 'search_users')) {
        //            $status = $BOL_AuthorizationService->getActionStatus('base', 'search_users');
        //            $getFeedback->warning($status['msg']);
        //            exit(json_encode(array('result' => false, 'error' => $status['msg'])//$lang->text('base', 'user_search_authorization_warning'))
        //            ));
        //        }
        $addParams = array('join' => '', 'where' => '');
        if ($data['online']) {
            $addParams['join'] .= " INNER JOIN `" . $BOL_UserOnlineDao->getTableName() . "` `online` ON (`online`.`userId` = `user`.`id`) ";
        }
        //        if ($data['with_photo']) {
        //            $addParams['join'] .= " INNER JOIN `" . $ow . "base_avatar` avatar ON (`avatar`.`userId` = `user`.`id`) ";
        //        }
        $data = $USEARCH_BOL_Service->updateSearchData($data);
        $data = $USEARCH_BOL_Service->updateQuickSearchData($data);
        //        if ($data["accountType"] == "8cc28eaddb382d7c6a94aeea9ec029fb") {
        //            $data["accountType"] = "808aa8ca354f51c5a3868dad5298cd72";
        //        } else {
        //            $data["accountType"] = "8cc28eaddb382d7c6a94aeea9ec029fb";
        //        }
        //$data["accountType"]
        // print_r($data);
        $userIdList = $Userservice->findUserIdListByQuestionValues($data, 0, $USER_LIST_SIZE, false, $addParams);
        //        echo "<pre>";
        //        print_r($userIdList);
        //        exit;
        $listId = 0;
        if (count($userIdList) > 0) {
            $listId = $BOL_SearchService->saveSearchResult($userIdList);
            OW::getSession()->set($SEARCH_RESULT_ID_VARIABLE, $listId);
            OW::getSession()->set('usearch_search_data', $data);
            $BOL_AuthorizationService->trackAction('base', 'search_users');
            $serach_result = searchResult(array('orderType' => array($PARAM_OPTION_DEFAULT_VALUE => 'latest_activity')), $listId);
            $messages = "Searching Successfully";
            $return_data = array("response_status" => '1', "response_message" => $messages, "data" => $serach_result);
            return $app->response->setBody(json_encode($return_data));
        } else {
            $messages = "Sorry!!! No people found.Please try a different search for more results.";
            $return_data = array("response_status" => '0', "response_message" => $messages);
            return $app->response->setBody(json_encode($return_data));
        }
    }
}

                    <li><a href="contacts.php">CONTACTS</a></li>
                </ul>
            </nav>
        </section>

        <section id="content-wrapper">
            <?php 
if (isset($_GET['song'])) {
    getSong($_GET['song']);
    getComments($_GET['song'], 'song');
} else {
    if (isset($_GET['playlist'])) {
        getPlaylist($_GET['playlist']);
        getComments($_GET['playlist'], 'playlist');
    } else {
        searchResult();
    }
}
?>
    </div>
    <div id="playlist-msg">
        <p id="msg"></p>
    </div>

    <script>
        var textarea = document.getElementById("textarea");
        var limit = 200;

        document.getElementById('background').style.height = window.innerHeight;

        textarea.oninput = function() {

<?php

if (!($match = Uri::match('category-(\\d+)\\/?'))) {
    Redirect::to('404page');
    // Alert::make('Page not found');
}
$pageName = 'category';
$pageData = array();
$pageData['content_top'] = Render::content_top($pageName);
$pageData['content_left'] = Render::content_left($pageName);
$pageData['content_right'] = Render::content_right($pageName);
$pageData['content_bottom'] = Render::content_bottom($pageName);
Theme::model('category');
$headData = GlobalCMS::$setting;
$pageData['newPost'] = searchResult($match[1]);
$pageData['listPage'] = listPage();
Theme::view('head', $headData);
Theme::view($pageName, $pageData);
Theme::view('footer');

function advance_search()
{
    global $USEARCH_BOL_Service;
    global $Userservice;
    global $BOL_SearchService;
    global $BOL_UserOnlineDao;
    global $ow;
    global $PARAM_OPTION_DEFAULT_VALUE;
    global $BOL_AuthorizationService;
    global $SEARCH_RESULT_ID_VARIABLE;
    $app = \Slim\Slim::getInstance();
    $app->response->headers->set('Content-Type', 'application/json');
    $app->response->setStatus(200);
    $user_id = $app->request()->params('user_id');
    $location = $app->request()->params('location');
    $match_sex = $app->request()->params('match_sex');
    $sex = $app->request()->params('sex');
    $distance = $app->request()->params('miles_from');
    $online = $app->request()->params('online');
    $age_min = $app->request()->params('age_min');
    $age_max = $app->request()->params('age_max');
    $with_photo = $app->request()->params('with_photo');
    $realname = $app->request()->params('realname');
    $services = $app->request()->params(HAMMU_DB_SERVICES_KEY);
    $serach_services = explode(",", $services);
    //    $required_data = array("location", "match_sex", "sex");
    //    foreach ($required_data as $rdata) {
    //
    //        if (!array_key_exists($rdata, $data) || empty($data[$rdata])) {
    //            $return = array("message" => "Please enter " . $rdata, "status" => "false");
    //            echo json_encode($return);
    //            exit();
    //        }
    //    }
    $urlencode_address = urlencode($location);
    $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false');
    $output = json_decode($geocode);
    if (!empty($output->results[0]->geometry->location->lng)) {
        $data_location['address'] = $output->results[0]->formatted_address;
        $data_location['latitude'] = $output->results[0]->geometry->location->lat;
        $data_location['longitude'] = $output->results[0]->geometry->location->lng;
        $data_location['northEastLat'] = $output->results[0]->geometry->viewport->northeast->lat;
        $data_location['northEastLng'] = $output->results[0]->geometry->viewport->northeast->lng;
        $data_location['southWestLat'] = $output->results[0]->geometry->viewport->southwest->lat;
        $data_location['southWestLng'] = $output->results[0]->geometry->viewport->southwest->lng;
        $data_location['json'] = json_encode($output->results[0]);
        $data_location['distance'] = $distance;
        $data_arr = array("form_name" => "MainSearchForm", "sex" => $sex, "match_sex" => $match_sex, "realname" => $realname, "with_photo" => $with_photo, "online" => $online, "googlemap_location" => $data_location, "birthdate" => array("from" => $age_min, "to" => $age_max), "realname" => $realname, HAMMU_DB_SERVICES_KEY => $serach_services, "MainSearchFormSubmit" => "Search");
        array_filter($data_arr);
        $data = $USEARCH_BOL_Service->updateSearchData($data_arr);
        $addParams = array('join' => '', 'where' => '');
        if (!empty($data['online'])) {
            $addParams['join'] .= " INNER JOIN `" . $BOL_UserOnlineDao->getTableName() . "` `online` ON (`online`.`userId` = `user`.`id`) ";
        }
        if (!empty($data['with_photo'])) {
            $addParams['join'] .= " INNER JOIN `" . OW_DB_PREFIX . "base_avatar` avatar ON (`avatar`.`userId` = `user`.`id`) ";
        }
        // echo "call";
        //        print_r($data);
        //        die;
        $userIdList = $Userservice->findUserIdListByQuestionValues($data, 0, 500, false, $addParams);
        //print_r($userIdList);
        $listId = 0;
        //        if (OW::getUser()->isAuthenticated()) {
        //            foreach ($userIdList as $key => $id) {
        //                if (OW::getUser()->getId() == $id) {
        //                    unset($userIdList[$key]);
        //                }
        //            }
        //        }
        if (count($userIdList) > 0) {
            //$listId = $BOL_SearchService->saveSearchResult($userIdList);
            $listId = $BOL_SearchService->saveSearchResult($userIdList);
            OW::getSession()->set($SEARCH_RESULT_ID_VARIABLE, $listId);
            OW::getSession()->set('usearch_search_data', $data);
            $BOL_AuthorizationService->trackAction('base', 'search_users');
            $serach_result = searchResult(array('orderType' => array($PARAM_OPTION_DEFAULT_VALUE => 'latest_activity')), $listId);
            $messages = "Searching Successfully";
            $return_data = array("response_status" => '1', "response_message" => $messages, "data" => $serach_result);
            return $app->response->setBody(json_encode($return_data));
        } else {
            $messages = "Sorry!!! No people found.Please try a different search for more results..";
            $return_data = array("response_status" => '0', "response_message" => $messages);
            return $app->response->setBody(json_encode($return_data));
        }
    }
}

 /**
  * Render a Search page, using the template as was set in the config.
  *
  * @see $Parser::render
  */
 function renderSearch()
 {
     global $PIVOTX;
     // Execute a hook, if present.
     $PIVOTX['extensions']->executeHook('before_parse', $this->modifier);
     // The type of page we're rendering
     $this->modifier['pagetype'] = 'search';
     $PIVOTX['template']->assign('pagetype', 'search');
     // Get the things we were searching for..
     $content = "\n<div class='pivotx-search-result'>\n";
     $content .= searchResult($searchresults);
     $content .= "<!-- Search took " . timeTaken() . " seconds -->\n";
     $content .= "</div>\n";
     $template = $PIVOTX['weblogs']->get('', 'extra_template');
     // Perhaps override the template, if we're allowed to do so.
     if (!empty($this->modifier['template']) && $PIVOTX['config']->get('allow_template_override') == 1) {
         $template = $this->modifier['template'];
     }
     // If the template isn't set, or doesn't exist..
     if ($template == "" || !file_exists($PIVOTX['paths']['templates_path'] . $template)) {
         // .. we guesstimate a template, and show that..
         $template = templateGuess('search');
     }
     // We know what theme we're in, because of the used template.
     $PIVOTX['template']->assign('themename', dirname($template));
     // Set the 'content' and the array of results in smarty..
     $PIVOTX['template']->assign('content', $content);
     $PIVOTX['template']->assign('searchresults', $searchresults);
     // Render and show the template.
     $this->parseTemplate($template);
 }

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <title>問題10：該当する都道府県を表示する</title>
    </head>
    <body>
        <form action="todofuken.php" method="post">
            <?php 
makeSelect($area);
?>
            <input type="text" size="1" value="<?php 
if (isset($_POST['str'])) {
    echo $_POST['str'];
}
?>
"  name="str">
            <br>
            <input type="submit">
        </form>
        <p><?php 
echo $message;
?>
</p>
        <hr>
        <p><?php 
searchResult($respArea, $readList, $prefList);
?>
</p>
    </body>
</html>