Simple search engine for database.

[TEC]

I currently have a database full of data, with tags written to them. But just to find something. I need go search down the whole database which contains over 30000 links. So, is there a way to create a simple search engine for my database. And this might sound stupid but my database is just a MySQL file with links arranged like this:

INSERT INTO `searchengine` (`id`, `title`, `description`, `url`, `keywords`) VALUES

My database is connected to my server and I would like to be able to access it using the web. So the searchengine has to be on the web.

[Nuluvius]

Why can't you do this using SQL? From the wording it comes across as if you are manually searching through each record...

[Guest]

FileZilla can do DB Searches, but not the best.

[TEC]

Why can't you do this using SQL? From the wording it comes across as if you are manually searching through each record...

It has to be public. Its a public database. So everyone should be able to go on my website. Search for something and get results from our database.

[Nuluvius]

It has to be public. Its a public database. So everyone should be able to go on my website. Search for something and get results from our database.

 

So the question still stands; why can't you use SQL? Simply abstract the queries away behind some of your web UI that you might build up for the purpose.

[unijab]

write a php page that will allow you to do searches.

[burnttoastnice]

SQL has built in search as mentioned by users above. You don't need any fancy PHP or other web based server code to perform parsing etc, if anything that's probably the most inefficient way to do it.

Just make sure the user can't perform SQL injection as I'm guessing the searches would be passed straight from the user input to the SQL query.

[sparkle128]

Create a simple html form that the user can enter the search criteria and submit the form to a php page. Note: You should create a separate index for each field in the table to get at the results in a timely fashion. 

 

To have each field as a criteria, create a form with input boxes for title,description, url and keywords. Then you can find the results by using a query like this:

select se.id      ,se.title      ,se.description      ,se.url      ,se.keywords  from searchengine se where 1=1   and (se.title like '%$title%' or se.description like '%$description%' or se.url like '%$url%' or se.keywords like '%$keywords%');

Or if you want a single "search" criteria to look at all the fields, create a form with a single input called search and then you can find the results:

select se.id      ,se.title      ,se.description      ,se.url      ,se.keywords  from searchengine se where 1=1   and (se.title like '%$search%' or se.description like '%$search%' or se.url like '%$search%' or se.keywords like '%$search%');

Use the Id field to go to a detail page and pull up the individual record if desired.

select se.id      ,se.title      ,se.description      ,se.url      ,se.keywords  from searchengine se where 1=1   and se.id = $id;

Hope that helps lead you in the right direction.

[nuc]

If all you want is a simple search where you assume people will be writing things correctly, what sparkle128 suggested is the easiest (for now) to integrate, and is your best bet.

 

If you want partial searches (AND|OR), multiple keywords, aggregations, ranking data by specificity to search, or to allow word deviations then you're best off looking at seeding a solution like elasticsearch. When you'd add/update/delete/etc a row to your MySQL db, you'd also update the entry in elasticsearch; elasticsearch isn't a permanent data store RDBMS, it's a NoSQL search. PHP library: https://github.com/elastic/elasticsearch-php