Need extra help with your Joomla site? Consider paid Joomla support by the developer of Chameleon and MetaMod.
- Index
- » MetaMod
- » MetaMod General Support
- » Metamod w/ Jbusinesslisting
Metamod w/ Jbusinesslisting
Metamod w/ Jbusinesslisting
Greetings,
I'm using Joomla 3.3 w/ a modified Shape5 template and trying to see if it's possible to dynamically show a module based on the category selected from a database search (jbusinesslisting extension)?
If so, I'm trying to get the PHP syntax to query the database, then depending on the category selected activate a module.
Thoughts?
Thanks in advance!
Re: Metamod w/ Jbusinesslisting
Hi Piranha,
Yes it should be possible to do this. The basic syntax for doing a database call is pretty simple, but the tricky bit is knowing how jbusinesslisting structures its database entries.
In fact there are 2 things you need to be able to work out:
1 - info from the URL about what item and/or category you are viewing. You almost certainly need to be able to extract a category id or item id from this. To help with this, try turning on MetaMod's Advanced Debug mode which gives you some example PHP code which is likely to help.
2 - the database tables used by jbusinesslisting
If you know a bit about databases already, would it be possible for you to take a look at the database tables used for jdatabaselisting's items and categories, and give some information about what the tables are called, and any relevant columns? You'll likely need at least these:
1 - name of category table
2 - name of item table
3 - names of columns for the ids on both tables (perhaps category_id and item_id or something similar, but you need to find the exact name)
4 - name of column in the item table that refers to the category table (e.g. category_id)
Together with the info from advanced debug mode (make a note of the output when you are viewing a category page and when you are viewing an item page) that may be enough to write some code for you.
Thanks,
Stephen
- Index
- » MetaMod
- » MetaMod General Support
- » Metamod w/ Jbusinesslisting
Board Info
- Board Stats:
- Total Topics:
- 1689
- Total Polls:
- 6
- Total Posts:
- 5942
- Posts this week:
- 2
- User Info:
- Total Users:
- 7627
- Newest User:
- rudys68879
- Members Online:
- 1
- Guests Online:
- 156
- Online:
- rudys68879
Forum Legend:
Topic
New
Locked
Sticky
Active
New/Active
New/Locked
New Sticky
Locked/Active
Active/Sticky
Sticky/Locked
Sticky/Active/Locked