close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Msqli server behavior with multiple keywords search.

Thread began 3/14/2020 8:14 am by nd.lamine430647 | Last modified 3/20/2020 10:15 am by Ray Borduin | 308 views | 35 replies |

nd.lamine430647

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

nd.lamine430647

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.

Sign in to reply to this post

Ray BorduinWebAssist

I meant "contains text" not "includes"... Just look at the screen shot I attached.

Sign in to reply to this post
Did this help? Tips are appreciated...

nd.lamine430647

Hello Ray,

I have tried but it doesn't work. Please can you take a look on my screenshot and advise please? Many thanks.

Sign in to reply to this post

Ray BorduinWebAssist

You still have Type="text" it needs to be Type="contains text"

The SQL statement should still have LIKE not CONTAINS

Sign in to reply to this post
Did this help? Tips are appreciated...

nd.lamine430647

It works now. Thank you very much Ray and have a wonderful weekend.

Sign in to reply to this post

nd.lamine430647

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

nd.lamine430647

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...