XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Feature Request 
  4.  / Excluding HTML in search?
Register
1
frankblack
Excluding HTML in search?

  • 2008/6/25 12:31

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


I don't know how to solve this problem. Text in the database formatted with markup like

what<b>ever</b>


will not be found when whatever is entered as search word. Could this be done with REGEXP in the SELECT?
2
hervet
Re: Excluding HTML in search?

  • 2008/7/5 8:01

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Hello Frank,

I had the smae problem and never found a MySQL function which could remove the html tagd while searching. My conclusion was to create two text fields, one for the search and one for the display ...
Not really nice but better than nothing.

Bye,
Hervé
3
hervet
Re: Excluding HTML in search?

  • 2008/7/5 8:07

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Hello Frank,

I had the smae problem and never found a MySQL function which could remove the html tagd while searching. My conclusion was to create two text fields, one for the search and one for the display ...
Not really nice but better than nothing.

Bye,
Hervé
4
phppp
Re: Excluding HTML in search?

  • 2008/7/6 5:33

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Using regexp match in MySQL might be a solution but I am afraid too expensive.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

156 user(s) are online (115 user(s) are browsing Support Forums)

Members: 0

Guests: 156

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits