0

I'm really new to Joomla and I have some basic experience with HTML/PHP and mySQL

I have a seperate DB in mySQL which has only 1 table & 3 fields to be populated, this part I've already setup and filled with information. What I can't figure out is how to get a searchbox to appear on the homepage of my joomla site that is only for searching this DB and not the whole website (which I don't require)

If anyone is able to give me some guidance that would be really appreciated.

The idea is a user would search for a code which is populated in my "SearchCode" column of the table and then I need the response to come back with everything from the 3 columns for the row that contains that code (I appreciate that's probably pretty obvious but I want to be clear)

I don't need anything fancy, I can figure a lot of myself once I know the basics of how to get the search box into the main page.

  • You can output the form via a Joomla custom module (youtube.com/watch?v=a1vsC3ss1Q4), not a problem. But you need to post the form to some backend. I'd develop an ajax endpont (Joomla module Ajax would fit you) which should perform the DB request and return data to your frontend. – AHeavyObject Aug 1 at 12:45
  • docs.joomla.org/Using_Joomla_Ajax_Interface I've forgotten to point to this link – AHeavyObject Aug 1 at 13:09
  • Thank you, I'll look into those, I did have a look at Ajax briefly so that definatly seems like the best option. – Shotts Tech Aug 1 at 13:37
  • @AHe thank you for offering your support, however you are providing potentially resolving advice as a comment and this does not comply with this site's Q&A format. Although you have already earned your informed badge, you may like to revisit the tour page. Since you are not seeking question clarification, please transfer your comments to a new answer. – mickmackusa Aug 1 at 23:58
  • @Sho Welcome to JSE. Please take our tour. – mickmackusa Aug 2 at 0:00
0

As per @mickmackusa note copy my comment here

You can output the form via a Joomla custom module (youtube.com/watch?v=a1vsC3ss1Q4), not a problem. But you need to post the form to some backend. I'd develop an ajax endpont docs.joomla.org/Using_Joomla_Ajax_Interface (Joomla module Ajax would fit you) which should perform the DB request and return data to your frontend

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.