2
I have a system that I use, but I wanted to have a system to leave more filtered the search for related posts, currently using the REGEXP of SQL to do, I have already used the LIKE and the results did not please me, someone has some new idea of how to do?
1
Most likely you will have to do the system that will suit you.
There are CMS’s (Drupal, Wordpress), but you would have to make a migration from your system q
depending on the situation can be much more complicated.
1
In my opinion, the best way to create a system of related posts would be to use the concept of tags. Just like CMS’s do, for example, Wordpress.
For each post you list it with tags, keywords related to it, if I create a post about a car, for example a Camaro, I would put tags such as: car, Chevrolet, automobile, gasoline and so on.
To do this, you would need to create some tables in your database to make the relationship.
In a quick search, you can find publications that can help you.
Good luck and good studies ;)
0
The best way is to create a list type field, where you can manually specify related posts, many plugins work exactly like this.
Sometimes posts related by auto search return posts with little cohesion and/or different meanings that make use of similar keywords. Unless you develop an algorithm there Google to relate posts.
No one better than the editor to know what is really related to the post in question.
You may also end up having the need to relate a specific post, and this solution will also suit you perfectly.
You can create an ajax search engine to search for posts that are similar, and help you search for the ideal post, as happens when you create a question here at Stackoverflow but leave the final decision always with the editor.
It is a quick and easy to implement solution and clearly well functional.
What about the LIKE, I invite you to see this video of the great Fábio Akita.
Browser other questions tagged php sql quest
You are not signed in. Login or sign up in order to post.
Be patient to manually place each related post...
– Henrique Barcelos
@Henriquebarcelos I sincerely believe that it is not a little work. To write a good post, the editor will have to seek information and sources, delve into the subject, write the entire text, review and correct it to the end and then publish. That’s a lot of work :)
– Ricardo