Completed

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

Hi,

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:
( 12 reviews ) Eppelheim, Germany

Project ID: #18004341

Awarded to:

tcube

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
(0 Reviews)
0.0

16 freelancers are bidding on average €35 for this job

junaidart

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)
7.2
vw1387659vw

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
(54 Reviews)
6.7
itmentorspk

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)
6.4
cris

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)
6.2
limillion819

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
(13 Reviews)
4.4
shailsolanki

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
(10 Reviews)
4.5
glisadeveloper

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
(2 Reviews)
2.5
SherifShahawy

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)
2.1
EasternStar930

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
(5 Reviews)
1.7
shsina

Hi bro, I am experienced PHP developer I can fix your script, please message me if you are interested you won't be disappointed.

€30 EUR in 1 day
(1 Review)
1.8
sunrised01

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
(3 Reviews)
0.9
chevyinasia

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
(1 Review)
1.0
nayan4uonline

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)
0.0
mdjafferali

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
(0 Reviews)
0.0
Maryambeh

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)
0.0