Search Box inline on top of page

Through Datassist, I generated and have products_results and _details.php working well. DA also generated a Search box that works fine and generates the desired results at products_results.php, but my company wants a single Search box at the top right of every page like you see in the attached mockup.
So is there a simple way to modify the attached products_search.php code so that it Searches both 'Product_Name' and 'Category' in one small Search box top right of every page and yields results just like you see when you click the 'Search' button at http://outofchaos.net/gsc/www/products_search.php
That's the goal and I'd appreciate any guidance or suggestions. Thank you.

Yes... you can remove one of the two fields and then update the results page to use a keyword search across multiple columns. Then it would just be a matter of adding the form with the single text element to the template or all of the pages where you want it.

If you could help/suggest the specific changes I'd need to make to the Search and Results pages, I created a dedicated products_results-search.php attached that responds to the products_search.php also attached but I'm not sure how to make the modifications you suggest so we'd have a single search box for Product_Name and Category that produces the combined result and fits neatly top right of the site's pages.

update lines 17-19 of the results page to:

$KeyArr1 = array("Product_Name", "category.Category");

  //comparison list additions
  $WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["Product_Name"]))?$_GET["Product_Name"]:"")  ."","WHERE","Includes",",%20","%20","%22","%22",0);

Then just delete the category row from your search page and delete the line that refers to it a couple of rows down on the results page since they aren't needed any more.

Thank you! - the Search is producing the right results with the code you outlined. So the last bit of input/help I'd appreciate: what approach would you suggest to tucking this Search Box/Form into the top right of the page design like you see in the attached design mockup? Should I try and iFrame it or create some kind of Container Div and transplant the Search page code? What would you suggest or how would you yourself approach it? I can modify CSS and change the button - just not sure the best way to physically place it up there.

Definitely no need for an iframe. Just copy the form, input field, and button into a div positioned where you want it.

Can you tell me what lines of the attached products_search.php you mean when you say, "Just copy the form, input field, and button?" Just not sure if the calls to the JS files need to be included in what you suggest. Thanks for your help.

None of the other code is necessary for it to function. Really the only thing the results page depends on is that the form action points to the results page, and the input field and form button names stay the same. Other than that they can be moved anywhere without effecting functionality.

I'm close. Inserted the form code in an <aside> called 'search' and it works. Just could use your help with a couple of format issues - see URL and attached file below:
1> Want to move the search box and button to top right of page just to the right of the phone# and in line with it like the attached mockup
2> Can't see where I can change the style/color of the search button or maybe even use an image
Any suggestions you have here would be much appreciated. Thank you

You can move the search form over by adding css like:

#search {
text-align: right;
margin-right: 60px;
}

You can change the image from <input type="submit" to <input type="image" and then specify an image source.