How to handle multi criterias search in PHP

I wish this helpful for you In a page HTML, there are several HTML links whose names contains some sub nodes. , The selector you need to use is

//a[./*[contains(text(),"Bar")] and ./*[contains(text(),"Garbo")]]

To fix the issue you can do I am not an expert but I would go for sum since FREETEXTTABLE can return 0 in one table so in this case the multiplication will not reflect reality. I see an analogy in OKAPI BM25 ranking formula where the general rank is computed by ranking individual terms of your query and sum them.

Hope that helps Having a orWhere condition with an empty value passed from input will not throw any MySQL errors, the condition will just be OR WHERE column = "". However, that is not exactly what you might want as a condition, because it will include all entries that has that column empty, in the result set.
Here's how I would approach it in order to keep it clean and only add the conditions needed:

// Define an array with the names of the input parameters for advanced search
$searchParams = ['category', 'teamleader', 'requestidstart', 'requestidend', 'requestdatestart', 'requestdateend', 'requestduedatestart', 'requestduedateend'];

// Create a blank query for your model on which you can add conditions
$query = DataRequest::query();

// Add only the params that have been passed values from the form as conditions
foreach ($searchParams as $param) {
    if (Input::has($param)) {
        $query->orWhere($param, Input::get($param));
    }
}

// Get your paginated results
$requests = $query->paginate(10);

Hope that helps I've been working on a demonstrative application for a shopping web app. I am using Spring + Hibernate to manage things on the back-end server. Now, as I would like the users of the application to be able to search through the products like they search stuff on google, I came to the conclusion that Hibernate Search fits my needs the best. However, I would like administrators of the app to be able to search stuff by providing search filters for multiple attributes. For example the "PRODUCT" table has fields such as id, name, desc, created_date etc, I want to provide the admin a way they could provide different inputs such as partial data for id, name, desc and created_date and could obtain the relevant search results. Hibernate Search allows me to do that by combining queries with clause like "and", "should" etc. But, in order to implement that I would have to annotate all the searchable fields with @Field annotation. , I would suggest to simply annotate all fields you need with @Field

seems to work fine Here is a more generalized approach: add the strings you want to filter to an array, then add the values from data in same order. Then we can compare them in a more generalized way by using the fact that they will have the same indexes.

List<String> filterBy = new List<String>{a, b, c};
for (Data data : datas) {
    Boolean shouldAdd = true;
    List<String> values = new List<String>{data.getA(), data.getB(), data.getC()};
    for (Integer i = 0; i < filterBy.size(); i++) {
        if (filterBy[i] != null && filterBy[i].equals(values[i]) == false) {
            shouldAdd = false;
            break;
        }
    }
    if (shouldAdd) {
        result.add(data);
    }
}