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.

Improve this question
5
  • 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
    Commented Aug 1, 2020 at 12:45
  • docs.joomla.org/Using_Joomla_Ajax_Interface I've forgotten to point to this link
    – AHeavyObject
    Commented Aug 1, 2020 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
    Commented Aug 1, 2020 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
    Commented Aug 1, 2020 at 23:58
  • @Sho Welcome to JSE. Please take our tour.
    – mickmackusa
    Commented Aug 2, 2020 at 0:00

1 Answer 1

Reset to default
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 and acknowledge you have read our privacy policy.

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