PHP and Manticore Search Development Guide: Building User Preference Search Functions

PHP and Manticore Search Development Guide: Building User Preference Search Function

With the rapid development of the Internet, user preference search function has become an essential feature of many websites and applications. In order to provide more personalized and accurate search results, developers need to choose an appropriate search engine and make reasonable use of its functions and APIs.

In this article, we will introduce the detailed steps to develop user preference search function using PHP and Manticore Search, and provide some code examples.

Step One: Install and Configure Manticore Search
First, we need to download and install Manticore Search. You can download the latest Manticore Search version installation package from the official website (https://manticoresearch.com/). The installation process may vary depending on the operating system, you can follow the official documentation.

After the installation is complete, we need to configure Manticore Search to enable the user preference search function. Open the Manticore Search configuration file and set the following options according to your needs:

searchd
{
    listen = 127.0.0.1:9306
    binlog_path = /var/lib/manticore
    pid_file = /var/run/manticore/searchd.pid
    log = /var/log/manticore/searchd.log
    query_log = /var/log/manticore/query.log

    search_logs = 1

    rt_mem_limit = 512M
}

index my_index
{
    type = rt
    rt_attr_string = name
    rt_attr_uint = age
}

In the above configuration, we defined a real-time index named "my_index" and specified two properties: "name" and "age". You can add more properties according to your needs.

Step 2: Indexing
Before we start building the user preference search function, we need to index the data first. Let's say we have a user table that contains the user's name and age.

First, we need to create a PHP script to connect to Manticore Search and prepare data:

<?php
require_once('vendor/autoload.php');

use FoolzSphinxQLDriversMultiResultSet;
use FoolzSphinxQLDriversPdoConnection;
use FoolzSphinxQLHelper;
use FoolzSphinxQLSphinxQL;

$connection = new Connection();
$connection->setParams(['host' => '127.0.0.1', 'port' => 9306]);

In the above code, we use the third-party library "SphinxQL" to connect to Manticore Search. Please make sure you have installed the library via Composer.

Next, we can use SphinxQL to create the index and add data to the index:

<?php
// continue from previous code ...
$index = 'my_index';
$engine = new SphinxQL($connection);
$engine->setConnection($connection);
$engine->query("TRUNCATE RTINDEX $index")->execute();
$engine->query("REPLACE INTO $index (name, age) VALUES ('Alice', 25), ('Bob', 30), ('Charlie', 35)")->execute();

In the above code, we first clear the index data and then add some to the index Sample data.

Step 3: Build the user preference search function
Now, we have successfully established the index and are ready to start building the user preference search function. Suppose our goal is to filter age based on user preferences.

First, we need to write a function in PHP. This function receives the user's preference parameters and constructs a SphinxQL query statement based on these parameters:

<?php
// continue from previous code ...
function buildUserPreferenceQuery($preferences) {
    $index = 'my_index';
    $engine = new SphinxQL($connection);
    $engine->setConnection($connection);

    $query = $engine->query("SELECT * FROM $index");
    
    foreach($preferences as $key => $value) {
        if($key == 'min_age') {
            $query->where('age', '>=', $value);
        } elseif($key == 'max_age') {
            $query->where('age', '<=', $value);
        }
    }
    
    return $query->execute();
}

In the above code, we iterate through the user's preference parameters and construct a query statement based on each parameter. Here we use the >= and <= operators to perform range queries.

Finally, we can call this function and print out the search results:

<?php
// continue from previous code ...
$preferences = [
    'min_age' => 25,
    'max_age' => 35
];

$result = buildUserPreferenceQuery($preferences);

foreach($result as $row) {
    echo "Name: " . $row['name'] . ", Age: " . $row['age'] . "
";
}

In the above code, we construct a hypothetical user preference that contains the minimum age and maximum age parameters, and print Results matching the search criteria are generated.

Through the above steps, we successfully built the user preference search function using PHP and Manticore Search. You can extend and modify it to suit your needs. Happy development!

The above is the detailed content of PHP and Manticore Search Development Guide: Building User Preference Search Functions. For more information, please follow other related articles on the PHP Chinese website!