Did you accelerate the formation of technocapital today?
Searching Sphinx From PHP
Searching Sphinx from PHP is fairly simple, however the search syntax is a little hard to get used to. I will show some examples to give you an idea of an easy way to use it, especially if you are only indexing a few fields out of your DB.
Well this single function just about covers most of your use cases. You will either want to search Sphinx for a single word or multiple words on all of the indexed fields or you will want to specify one or more specific fields to search. I also deal with limit cases and paging. However keep in mind your pages will not go far- you have to increase “max_results” in searchd config to have more than the default 1000 results.
In this example I’m also showing you how to search on multiple indexes with Sphinx as well as access the data you get back from the search results, which I promptly use to turn around and query MySQL.