How does the title submitted by a user form extract the same part of multiple headings?

the object of complaint in the picture is submitted by the user in the form. How to use php to extract keywords (company abbreviation) and store them in mysql database. When checking the data, you can get grouped data through this abbreviation. The picture is the data queried in groups. I would like to know how this function is realized?

Php
Mar.23,2021

your question is a bit contradictory, you say how to use php to extract keywords (company acronym) . In this sentence, how does php know which of your strings is the keyword (without keyword library )?

feels like your problem should be php how to extract the most frequently occurring substring , which feels like this.
after we have this idea, let's take a closer look at it. I have an idea:

  1. gather all the title submitted by users within a certain period of time into a string, and then extract the substrings that appear most frequently
  2. list the frequency of substrings from high to low. Artificial Filter, which are the required keywords to form a keyword library
  3. the next time you submit title , match it with keyword library . If there is no match, in addition to inserting a separate title into the original complaint library, insert a separate title into a temporary table at the end of the day, regularly carry out an algorithm for keyword extraction (repeat 1), and then manually come to Filter
  4. the next day.

above.


if you don't use an open source search engine, it doesn't make much sense to do this on your own. it involves keyword extraction algorithms, which is more complex, so you have to query through these keywords directly

.
  

first needs word segmentation, that is, when the user submits the form, give the title to the word segmentation, then store it in the database, and then perform full-text indexing according to the extracted word segmentation

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-7b7782-1ed7a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-7b7782-1ed7a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?