HomeNews listOBJECTIVE PRESSWhat php library do you recommend for SQL Product DB Search?

What php library do you recommend for SQL Product DB Search?

  • July 21, 2023
  • Posted by: AliensFaith
  • Category: OBJECTIVE PRESS
No Comments

I have a SQL product database with about 2,000 products. Fields are

  • Product Title
  • Description (which can be 1 sentence – 2 paragraphs long)
  • Department
  • Type
  • SubType

Currently, products are online in a catalog that is navigable via Department/Type/SubType. I am looking to implement a search bar feature.

I have tried just using “LIKE” in my SQL for the search phrase, but that requires an exact match. I have also tried a SQL FULL TEXT search, but that seems to provide too many incorrect results.

Is there a php library that can use to process the search phrase against data?

Thanks in advance!

submitted by /u/RepresentativeWord58
[link] [comments]      



Author: AliensFaith
HighTech FinTech researcher, university lecturer & Scholar. He is studying his second doctoral degree at the Hague International University. Studying different fields of Sciences gave him a broad understanding of various aspects of life. His recent researches covered AI, Machine-learning & Automation concepts. The Information Technology Skills & Knowledge gave his company a higher position over other regional high-tech consultancy services. The other qualities and activities which can describe him are a Hobbyist Programmer, Achiever, Strategic Thinker, Futuristic person, and Frequent Traveler.

Discover more from Maheri Network

Subscribe now to keep reading and get access to the full archive.

Continue reading

Exit mobile version