PHP SphinxClient::EscapeString方法代码示例

 /**
  *
  * @param string $query
  * @return array of integers - taskIds
  */
 public static function searchTasks($query)
 {
     $fieldWeights = array('description' => 10, 'note' => 6);
     $indexName = 'plancake_tasks';
     $client = new SphinxClient();
     // $client->SetServer (sfConfig::get('app_sphinx_host'), sfConfig::get('app_sphinx_port'));
     $client->SetFilter("author_id", array(PcUserPeer::getLoggedInUser()->getId()));
     $client->SetConnectTimeout(1);
     $client->SetMatchMode(SPH_MATCH_ANY);
     $client->SetSortMode(SPH_SORT_RELEVANCE);
     $client->SetRankingMode(SPH_RANK_PROXIMITY_BM25);
     $client->SetArrayResult(true);
     $client->SetFieldWeights($fieldWeights);
     $client->setLimits(0, 100);
     $results = $client->query($client->EscapeString($query), $indexName);
     if ($results === false) {
         $error = "Sphinx Error - " . $client->GetLastError();
         sfErrorNotifier::alert($error);
     }
     $ids = array();
     if (isset($results['matches']) && count($results['matches'])) {
         foreach ($results['matches'] as $match) {
             $ids[] = $match['id'];
         }
     }
     return PcTaskPeer::retrieveByPKs($ids);
 }

 public function escape($string)
 {
     return $this->sphinxClient->EscapeString((string) $string);
 }

 public function index()
 {
     // Init variables
     $data = array();
     $breadcrumbs = array();
     $filter_data = array('order' => 'DESC');
     $title = tt('Products');
     $meta_title = '';
     $breadcrumbs[] = array('name' => tt('Home'), 'href' => $this->url->link('common/home'), 'active' => false);
     $breadcrumbs[] = array('name' => tt('Search'), 'href' => $this->url->link('catalog/search'), 'active' => true);
     // Filter by user
     if (isset($this->request->get['user_id']) && ($user_info = $this->model_account_user->getUser((int) $this->request->get['user_id']))) {
         $title .= sprintf(' ' . tt('by %s'), $user_info->username);
         $meta_title .= sprintf(' ' . tt('by %s'), $user_info->username);
         $filter_data['user_id'] = (int) $this->request->get['user_id'];
     }
     // Filter by search term
     if (isset($this->request->get['q']) && !empty($this->request->get['q']) && ValidatorProduct::titleValid($this->request->get['q'])) {
         $title .= sprintf(' ' . tt('containing %s'), ucfirst($this->request->get['q']));
         $meta_title .= sprintf(' ' . tt('Buy %s Thematic with Bitcoin | %s Thematic Store'), ucfirst($this->request->get['q']), ucfirst($this->request->get['q']));
         // Sphinx search begin
         $sphinx = new SphinxClient();
         $search = $sphinx->EscapeString($this->request->get['q']);
         $result = $sphinx->Query("({$search} | *{$search})*");
         // If something found
         if ($result !== false && !empty($result['matches'])) {
             foreach ($result['matches'] as $product_id => $info) {
                 $filter_data['filter_product_ids'][] = (int) $product_id;
             }
             // If products not found
         } else {
             $filter_data['filter_product_ids'][] = 0;
         }
     }
     // Filter by favorites
     if (isset($this->request->get['favorites'])) {
         $title .= ' ' . tt('favorites');
         $meta_title .= $title;
         $filter_data['favorites'] = true;
     }
     // Filter by purchased
     if (isset($this->request->get['purchased'])) {
         $title .= ' ' . tt('purchased');
         $meta_title .= $title;
         $filter_data['purchased'] = true;
     }
     // Load products
     $data['products'] = array();
     $products_total = 0;
     foreach ($this->model_catalog_product->getProducts($filter_data, $this->language->getId(), $this->auth->getId(), ORDER_APPROVED_STATUS_ID) as $product_info) {
         $products_total++;
         // Prepare special counter
         if ($product_info->special_date_end) {
             $special_left_seconds = strtotime($product_info->special_date_end) - time();
             $special_left_minutes = floor($special_left_seconds / 60);
             $special_left_hours = floor($special_left_minutes / 60);
             $special_left_days = floor($special_left_hours / 24);
             if ($special_left_minutes < 60) {
                 $special_expires = sprintf(tt('%s %s left'), $special_left_minutes, plural($special_left_minutes, array(tt('minute'), tt('minutes'), tt('minutes '))));
             } else {
                 if ($special_left_hours < 24) {
                     $special_expires = sprintf(tt('%s %s left'), $special_left_hours, plural($special_left_hours, array(tt('hour'), tt('hours'), tt('hours '))));
                 } else {
                     $special_expires = sprintf(tt('%s %s left'), $special_left_days, plural($special_left_days, array(tt('day'), tt('days'), tt('days '))));
                 }
             }
         } else {
             $special_expires = false;
         }
         switch ($product_info->order_status_id) {
             case ORDER_APPROVED_STATUS_ID:
                 $product_order_status = 'approved';
                 break;
             case ORDER_PROCESSED_STATUS_ID:
                 $product_order_status = 'processed';
                 break;
             default:
                 $product_order_status = $product_info->user_id == $this->auth->getId() ? 'approved' : false;
         }
         // Generate products
         $data['products'][] = array('product_order_status' => $product_order_status, 'favorite' => $product_info->favorite, 'demo' => $product_info->main_product_demo_id ? true : false, 'product_id' => $product_info->product_id, 'title' => $product_info->title, 'favorites' => $product_info->favorites ? $product_info->favorites : false, 'status' => $product_info->status, 'src' => $this->cache->image($product_info->main_product_image_id, $product_info->user_id, 144, 144), 'href_view' => $this->url->link('catalog/product', 'product_id=' . $product_info->product_id), 'href_download' => $this->url->link('catalog/product/download', 'product_id=' . $product_info->product_id), 'href_demo' => $this->url->link('catalog/product/demo', 'product_demo_id=' . $product_info->main_product_demo_id), 'special_expires' => $special_expires, 'special_regular_price' => $product_info->special_regular_price > 0 ? $this->currency->format($product_info->special_regular_price, $product_info->currency_id) : 0, 'special_exclusive_price' => $product_info->special_exclusive_price > 0 ? $this->currency->format($product_info->special_exclusive_price, $product_info->currency_id) : 0, 'regular_price' => $this->currency->format($product_info->regular_price, $product_info->currency_id), 'exclusive_price' => $this->currency->format($product_info->exclusive_price, $product_info->currency_id), 'has_regular_price' => $product_info->regular_price > 0 ? true : false, 'has_exclusive_price' => $product_info->exclusive_price > 0 ? true : false, 'has_special_regular_price' => $product_info->special_regular_price > 0 ? true : false, 'has_special_exclusive_price' => $product_info->special_exclusive_price > 0 ? true : false);
     }
     // Log search request
     if (isset($this->request->get['q']) && !empty($this->request->get['q']) && ValidatorProduct::titleValid($this->request->get['q'])) {
         $this->model_common_log->createLogSearch($this->auth->getId(), $this->request->get['q'], $products_total);
     }
     // Load layout
     $this->document->setTitle($meta_title);
     $data['title'] = $title;
     $data['footer'] = $this->load->controller('common/footer');
     $data['header'] = $this->load->controller('common/header');
     $data['module_breadcrumbs'] = $this->load->controller('module/breadcrumbs', $breadcrumbs);
     $data['module_search'] = $this->load->controller('module/search');
     $data['user_is_logged'] = $this->auth->isLogged();
     // Renter the template
     $this->response->setOutput($this->load->view('catalog/list.tpl', $data));
 }

 /**
  * Clean up a search word/phrase/term for Sphinx.
  *
  * @param string $sphinx_term
  * @param SphinxClient $sphinx_client
  */
 private function _cleanWordSphinx($sphinx_term, $sphinx_client)
 {
     // Multiple quotation marks in a row can cause fatal errors, so handle them
     $sphinx_term = preg_replace('/""+/', '"', $sphinx_term);
     // Unmatched (i.e. odd number of) quotation marks also cause fatal errors, so handle them
     if (substr_count($sphinx_term, '"') % 2) {
         // Using preg_replace since it supports limiting the number of replacements
         $sphinx_term = preg_replace('/"/', '', $sphinx_term, 1);
     }
     // Use the Sphinx API's built-in EscapeString function to escape special characters
     $sphinx_term = $sphinx_client->EscapeString($sphinx_term);
     // Since it escapes quotation marks and we don't want that, unescape them
     $sphinx_term = str_replace('\\"', '"', $sphinx_term);
     return $sphinx_term;
 }

 /**
  * @{inheritDoc}
  */
 public function clean_string($string)
 {
     return $this->client->EscapeString($string);
 }

 /**
  * 转义特殊字符
  *
  * @param string $string The string to be escaped.
  *
  * @return string The escaped string.
  */
 function escapeString($string)
 {
     return $this->sphinx->EscapeString($string);
 }

$category_id = $simpla->request->get('category', 'integer');
$limit_get = $simpla->request->get('limit', 'integer');
if (!empty($limit_get)) {
    $limit = $limit_get;
}
$q = $keyword . '*';
$Sphinx = new SphinxClient();
$Sphinx->SetServer('127.0.0.1', 9312);
$Sphinx->SetConnectTimeout(1);
$Sphinx->SetArrayResult(true);
$Sphinx->SetSortMode(SPH_SORT_EXTENDED, 'rank ASC, date_created DESC');
$Sphinx->SetLimits(0, $limit);
$ids = array();
$total = 0;
$indexName = 'moda_product';
$q = $Sphinx->EscapeString($q);
$search = $Sphinx->Query($q, $indexName);
$count = $search['total'];
if ($search !== FALSE) {
    if (!empty($search['matches'])) {
        foreach ($search['matches'] as $match) {
            $ids[] = (int) $match['id'];
        }
        $total = $search['total'];
    }
}
$category_id_filter = '';
$group_by = '';
if ($category_id > 0) {
    $category = $simpla->categories->get_category($category_id);
    $category_ids = !empty($category->children) ? $category->children : array();