search engine php mysql with autocomplete-text help suggestion

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