Change my php/mysql-code - Optimize search-function


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.

Skills: MySQL, PHP, Software Architecture

See more: change php mysql port, php mysql code bid, create appointment using php mysql code, code access search function, php mysql code multiple choice questions answers, php mysql code mobile verification sent sms, php mysql multiple word search, read data ticker php mysql code, gift certificate php mysql code, add php zip code radius search, complete php mysql code, load specific web page php mysql code, php mysql doesnt view search query, check availability bookings php mysql code, php mysql grid extjs search, php zip code radius search engine, php mysql multiple field search

About the Employer:
( 15 reviews ) Eppelheim, Germany

Project ID: #18004341

Awarded to:


I made loads of dynamical searches for various platforms, I can certainly help you with this. And you'll get it on time and budget!

€29 EUR in 4 days
(5 Reviews)

15 freelancers are bidding on average €35 for this job


Hi there Are you running your code in WordPress? or is this script outside of WordPress? Regards Junaid ....

€34 EUR in 0 days
(116 Reviews)

hello i can improve your code so you can search for mor than one word and optimise it for large database i have over 13 years of experience working on xamp technologies. i providz a clean code and total satisfaction w More

€70 EUR in 3 days
(62 Reviews)

Hi, I have had look at your php file having function for fetching records and following observations. 1- Security i. very 1st thing you must do user filter_var as the input is submitted by user and then validate the More

€34 EUR in 0 days
(37 Reviews)

Hi there. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional php developer, I ensure for a perfect ongoing project. You will n More

€55 EUR in 0 days
(26 Reviews)

Hello. I am freelance programmer with over 14 years of experience developing corporate PHP & MySQL ,Bootsrap, customized Wordpress, HTML applications with CSS and JavaScript abilities and vast coding abilities. I als More

€30 EUR in 1 day
(155 Reviews)

Hi, I will change PHP/ MYSQL code.I am PHP expert with more than 10 years of experience in PHP, MYSQL, MVC like CI, CAKEPHP, XSS and CSRF attacks, database optimization, Webservices like SOAP, REST, JSON and Javas More

€66 EUR in 1 day
(12 Reviews)

Hello, i'll help you in your task. I will do it as per your guidance. Please initiate a chat session so we can discuss more about it. thank you.

€29 EUR in 1 day
(3 Reviews)

I have read your job description in detail. I am sure I can do it well. I have rich experiences in PHP please chat with me

€29 EUR in 1 day
(7 Reviews)

Hello sir, I would like to take and complete your job, I will be working in PHP , mySQL and HTML/CSS/Bootstrap. 1) Easy job 2) Yeah this is easy aswell by using the LIKE query statment. 3) Okay this can be done 4 More

€12 EUR in 1 day
(2 Reviews)

Guten tag. By the table structure (X_posts, post_title, post_content) it looks like you're using WordPress. Irrespective, I can do the following with your current code and database (MySQL): - Sanitize the search More

€50 EUR in 2 days
(4 Reviews)

Hi sir, I have read your job description according your requirement i am fit for this job. I will help you to create website. Please share the whole requirement of project. I would describe myself as a very de More

€14 EUR in 1 day
(4 Reviews)

Respected Recruiter, I read with interest your posting for Change my php/mysql-code. I believe I possess the necessary skills and experience you are seeking and would make a valuable addition to your company. As More

€32 EUR in 7 days
(1 Review)

Hi, Please accept my application. I desperately looking for job and I am ready to work in cheap price. I have more than 8 years of experience in PHP/MySQL/HTML/CSS/Jquery, CMS like Wordpress and framework like C More

€23 EUR in 1 day
(0 Reviews)

hallo :) ich bin maryam i think this sql code handel your work SELECT * FROM nbaplayermaster WHERE "{$search_text}" LIKE Concat(Concat('%',firstname),'%') OR "{$search_text}" LIKE Concat(Concat('%',lastn More

€23 EUR in 1 day
(0 Reviews)