I am developing news site using php codeigniter.It is in different languages. When a user search for any news by entering keyword, It should find news related to searched keyword.
How can I do that?
Shall I use indexing ?
-
2What is your research on this?DeshDeep Singh– DeshDeep Singh2015-08-07 09:48:47 +00:00Commented Aug 7, 2015 at 9:48
-
I found out google custom search but it is not working for my sitehrishi– hrishi2015-08-08 10:58:24 +00:00Commented Aug 8, 2015 at 10:58
Add a comment
|
1 Answer
You can use Full Text Search for searching keywords in SQL database
Check this...
Sure, You must use Indexing, Indexing will help to fetch results fast. You can also use Inner Join, left join etc to get structured result, but I have tried this kind of search by making an SQL view.
See this is how you can make SQL view
It helps me to search related results fast
2 Comments
hrishi
Thank you. where I can find information about indexing. It is very new concept for me.
Marmik Bhatt
Check these....www.youtube.com/watch?v=rreKY6K3S_A, interspire.com/content/2006/02/15/…