I want to get some idea how to go about adding asearch bar in my website?
Please note I don't want to create a google api or google search engine. When user search inside my search bar than only results from my website should show up. and not from random websites.
I was thinking:
I was planning on creating a table called "SearchTable". This table will have 3 cols. I can add all links of my website in "Links" cols. and search using the keywords.
Table: SearchTable(ID, Links, keywords)
and I can search by using the following query
SELECT * FROM SearchTable WHERE keywords LIKE '%searchWord%'"
are there any other ways of doing this?