Need help with optimisation of PHP and mysql query.

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

PLEASE READ CAREFULLY BEFORE BIDDING!

We are trying to search through a wordpress database to return an intelligent search that gives us lessons from an lms that relate to a query that the user types in (in an app - not wordpress)

We need to be able to return the results as json

We are having issues with the results being very slow to return and it may be that our query is wrong (we believe the issue is in the loop of the php.

The search results should be intelligent in the sense that for example if the course title is

Modifying User Permissions

and the user searches for modify permissions the results should come back ordered by relevance.

The results should be structured similar to this

Results Required

Course (Name, postid)

Section1

Section2

Lesson1

Lesson2

Meta

We are using learnpress as the plugin - but we are NOT using wordpress for this - it needs to run outside wordpress - pure php/json/mysql

should be straightforward for php/mysql expert

JavaScript MySQL PHP Software Architecture WordPress

Project ID: #17058676

About the project

11 proposals Remote project Active 5 years ago

11 freelancers are bidding on average $39 for this job

waleedhassan081

Hi I hope you have an amazing day, I am very much interested in your work. Should i work your attached file and send it to you. I have experience with wordpress database First I will complete this task. If you ar More

$30 USD in 0 days
(23 Reviews)
3.7
shivagtm

Hi, I am and individual developer and i am confident that i can do this job. Lets have a discussion for better understanding of the requirements. Hope to hear from you.

$25 USD in 1 day
(8 Reviews)
3.5
keshurai

Hi There! I have read and understood your requirement. We are a great team of Web Developers and we will be glad to work on your project. Lets discuss more about it in chat. See you there. Thanks

$30 USD in 1 day
(2 Reviews)
3.3
b2ecoder

I've carefully read your project description. I am very interested in doing this project of yours. If you want i will be starting doing this work right now. I am a PHP, Laravel, Codeigniter, Magento,JavaScript,JQu More

$111 USD in 3 days
(6 Reviews)
3.3
tanu17093

Hi I am an experienced PHP-MySql Developer and can sort out your problem right now. Hope to have your reply soon. Regards.

$15 USD in 1 day
(0 Reviews)
0.0