wordpress plugin base to show search form, query mysql and show result on a page


I need a simple plugin base code that:

- shows a search form (simple text input + submit button) on a page
- when submitted queries mysql db & does some stuff with retrieved data (Hello world text would be ok for the sample - I can manage the rest)
- shows the answer/results on the same page below the search form

It would be perfect if there would be a *shortcode* that can be inserted on pages - and where it is inserted the above search form / results would show

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

What's wrong with the multitude of plugins that already exist or the built in search?
If you want a custom plugin then you would be better off hiring someone to do it for you.
We are here to answer questions.
netsltAuthor Commented:
I dont want to do a classical search for wordpress content.

I want to search a custom database and display the results.

I know how to do this in php, but would like to know how to integrate it into wordpress.

Just need a basic framework as described in my question to start from there.

So yes - it is a question: how do i integrate this into a wordpress page.

And yes, I know I can hire someone for this if I want  - but as I say I just need the basics to get me started quickly - the complex thing is the query & display of the results, already got that finished, just need to integrate it into a wordpress page.

GaryC123 thanks for your response, but it is not very helpful....
netsltAuthor Commented:
Maybe I missunderstood you: "multitude of plugins that already exist" - maybe you know a plugin that does something similar to what I want?

Then please name it... I could start from there.
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

No because you omitted you were using a completely separate db.
What have you tried?
In WP you can use its own wpdb class to connect to the db
Your basic framework is not basic at all
netsltAuthor Commented:
I wrote "I want to search a custom database and display the results."

so custom database does not sound like the wordpress db.

also to query the db is not the problem.

The question is on how to show the search form, where to put the processing code & how show the results after processing.
Why don't you just take something like this

And amend the db connection and queries

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason C. LevineNo oneCommented:
Technically, you don't even need to use a plugin for this.  Just create a new custom page template, add your form, search, and display code and then call that template as a new WordPress page.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.