Msqli server behavior with multiple keywords search.
Hi Team, I am trying to make a search box with keywords. When I build the recordset with mysql operator like, it doesn't accept it. When I put the %, it doesnt work too. Please assist. Thanks.
Hi Team, I am trying to make a search box with keywords. When I build the recordset with mysql operator like, it doesn't accept it. When I put the %, it doesnt work too. Please assist. Thanks.
Use the Parameter type: "includes". For an advanced search like this it is much easier and better to get DataBridge which includes a full search Server behavior with much more advanced options.
Hello Ray,
What do you mean by includes ? Is it to make a separate php file that do the search and return the results ? Please advise.
Thank you.
I meant "contains text" not "includes"... Just look at the screen shot I attached.
Hello Ray,
I have tried but it doesn't work. Please can you take a look on my screenshot and advise please? Many thanks.
You still have Type="text" it needs to be Type="contains text"
The SQL statement should still have LIKE not CONTAINS
It works now. Thank you very much Ray and have a wonderful weekend.
Hello Ray, sorry to disturb you again.
With the solution provided, I can search only by one keyword. When I type 2 or more keywords, it doesn't work. Please do you have any suggestion to enable the multiple keyword search base on the last screenshot sent ?
Many thanks for your precious assistance.
You would have to purchase DataBridge for the advanced search features. It allows advanced querybuilding based on multiple keywords. The only other solution would be to hand code something that would work for you. Perhaps splitting the keyword string by the space character and then building the SQL statement dynamically based on the returned array.
There are hundreds of lines associated with recordset filtering included in the rsobj.php file that DataBridge includes UI's to access. I'd suggest upgrading to DataBridge in order to easily take advantage of them. Either that or I could help in a 1 hour premier support ticket if you would rather go that route and hand code it for you.
Hello Ray,
I have some eCommerce projects and I plan to go for the Databridge. For the moment, I am working on that small application where I need multiple keyword search.
I have one textfield called "keywords" and in my sql query I have concatenated multiple table field separated by a space (see screenshot attached). Now I would like, when the user types multiple keywords, the search to be performed correctly instead showing 0 records as records.
Please assist. Thank you again.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.