Đã hoàn thành

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.

Kĩ năng: MySQL, PHP, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 15 nhận xét ) Eppelheim, Germany

ID dự án: #18004341

Được trao cho:

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 trong 4 ngày
(5 Đánh Giá)
3.2

15 freelancer đang chào giá trung bình €35 cho công việc này

junaidart

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

€34 EUR trong 0 ngày
(116 Nhận xét)
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 Thêm

€70 EUR trong 3 ngày
(62 Nhận xét)
6.8
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 Thêm

€34 EUR trong 0 ngày
(37 Nhận xét)
6.4
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 Thêm

€55 EUR trong 0 ngày
(26 Nhận xét)
6.0
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 Thêm

€30 EUR trong 1 ngày
(155 Nhận xét)
6.2
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 Thêm

€66 EUR trong 1 ngày
(12 Nhận xét)
5.0
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 trong 1 ngày
(3 Nhận xét)
2.9
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 trong 1 ngày
(7 Nhận xét)
2.1
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 Thêm

€12 EUR trong 1 ngày
(2 Nhận xét)
2.1
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 Thêm

€50 EUR trong 2 ngày
(4 Nhận xét)
1.9
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 Thêm

€14 EUR trong 1 ngày
(4 Nhận xét)
0.9
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 Thêm

€32 EUR trong 7 ngày
(1 Nhận xét)
0.3
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 Thêm

€23 EUR trong 1 ngày
(0 Nhận xét)
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 Thêm

€23 EUR trong 1 ngày
(0 Nhận xét)
0.0