Suoritettu

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.

Taidot: MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Tietoa työnantajasta:
( 12 arvostelua ) Eppelheim, Germany

Projektin tunnus: #18004341

Myönnetty käyttäjälle:

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 4 päivässä
(0 Arvostelua)
0.0

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

junaidart

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

€34 EUR 0 päivässä
(116 arvostelua)
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 Lisää

€70 EUR 3 päivässä
(54 arvostelua)
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 Lisää

€34 EUR 0 päivässä
(37 arvostelua)
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 Lisää

€30 EUR 1 päivässä
(155 arvostelua)
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 Lisää

€55 EUR 0 päivässä
(13 arvostelua)
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 Lisää

€66 EUR 1 päivässä
(10 arvostelua)
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 1 päivässä
(2 arvostelua)
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 Lisää

€12 EUR 1 päivässä
(2 arvostelua)
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 1 päivässä
(5 arvostelua)
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 1 päivässä
(1 arvostelu)
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 Lisää

€14 EUR 1 päivässä
(3 arvostelua)
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 Lisää

€50 EUR 2 päivässä
(1 arvostelu)
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 Lisää

€23 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€32 EUR 7 päivässä
(0 arvostelua)
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 Lisää

€23 EUR 1 päivässä
(0 arvostelua)
0.0