I Need to create search engine based in php/mysqli
1- i have many section in this site so i have tow cases if user select a specific section to search in so script will get the result from this section only else the search engine will get all result from all db
2- Mysql protection from injection and etc....
3- Creating Autocomplete or Search Suggestion Functionality with PHP and MySQLi that loaded from my DB that make search easy
4- Pagination in Search Engine result
5- active submit with both from enter in keyboard and search icon from search form
6- database will have tone of thousand from record so the wild '%$search_each%' will not the best will make search go slow and slow Database is provided here after we get our deal