I've got a PHP-code (see attached file).
It is a script for searching my mysql-database. It orders by relevance (title *4 and content *1)
$search_text is from a search-form.
I need the following changes:
1) make the code secure against injections and other danger things
2) make the code work for more than one search-word. right now it works only for one-word-searches (for example "tree"). I need it to work also for more words ("my red tree").
So check the results for "my", for "red" and "tree" and sort by relevance.
3) make the code work for all german letters
ä (= ae)
ö (= oe)
ü (= ue)
ß (= ss)
4) optimize the code for performance. The table has more than 50.000 entries.