Wordpress page - incorporating PHP form which returns results of a MySQL query

I have written a PHP web page with a form that runs a search query on a custom MySQL database and returns the results as a table.

Is there a way that I can incorporate this PHP form within Wordpress so that it follows the same theme layout and will still be able to return the results of the search while again, displaying the results with the same theme layout?
LVL 17
Chris MillardAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Jason C. LevineDon't talk to me.Commented:
Yes, just make a custom page template by copying your theme's page.php file:

https://developer.wordpress.org/themes/template-files-section/page-template-files/page-templates/#creating-a-custom-page-template-for-one-specific-page

and in that specific template, add your own PHP scripts and returns as desired.
Chris MillardAuthor Commented:
I have done this, but the MySQL query isn't returning any results, even though the same PHP script works when in a standalone file.

I know that the parameters being passed back to the page are getting through OK, as I am echoing the query to the page and the query is correct.

I also don't get any MySQL connection errors either.
Chris MillardAuthor Commented:
It turns out that I had to use the WP_Query class even though it's a different database.

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
Chris MillardAuthor Commented:
Got my answer from the Wordpress support site. I needed to use the WP_Query class to communicate with my database
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
WordPress

From novice to tech pro — start learning today.