By Andy on Friday, 01 August 2014
Replies 8
Likes 0
Views 1.9K
Votes 0
I have a DB table with a User ID # field and lots of other fields (just basic text / number data)

I want an EasySocial App such that if on a User Profile page, it'll check that DB table and return the specified fields from the table relating just to that particular User ID #. (So not all the fields, just the ones I can hopefully specify in the back-end App settings)

My guess is that's nothing too advanced (although beyond me) - Is this kind of thing already produced and available anywhere... or if not, anyone know who could put one together?

Thanks!
Hello Andy,

We don't actually have such an app unfortunately You will need to write an app that extracts these data from your custom tables.
·
Friday, 01 August 2014 15:46
·
0 Likes
·
0 Votes
·
0 Comments
·
OK thanks. Anyone else able to help with this? Presumably it's fairly basic to do if you know what you're doing with some PHP.

I would have thought this would have been a very versatile 'app' with many many many uses for people. I'd certainly use it over and over again to bring up user-specific data on the profile page.

Hope someone is listening (reading!)
·
Monday, 04 August 2014 09:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Andy,

I do think this requires quite a bit of programming skills to retrieve the user's information from your custom tables. Not sure if this could be done by everyone though.
·
Monday, 04 August 2014 12:19
·
0 Likes
·
0 Votes
·
0 Comments
·
OK yes I suppose it's a custom build request if anyone's able, another way of explaining it is...

1. App config (for super admin) let's you 'connect' to a DB table with a known field with User ID's in it.
2. App config then let's you pick the other fields from that DB table which get displayed on the User's EasySocial Profile page.
·
Monday, 04 August 2014 12:26
·
0 Likes
·
0 Votes
·
0 Comments
·
You want to
1) pull information from custom profile fields from the database
2) display this information to visitors on each users profile.
Do I understand correctly?
If this is correct, all the code we need already exists, it is just a case of turning it into a module.
·
Monday, 04 August 2014 15:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah not quite... the data I want to retrieve isn't in EasySocial custom profile fields.... its in another non-EasySocial database table (same Joomla installation though).
·
Monday, 04 August 2014 19:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Andy it's not that complicated (would be more if you use the standard MVC structure) if you find the .php file of where you want to display the information.
Instead of using a Table class, just make the SQL review with this url:
http://docs.joomla.org/Selecting_data_using_JDatabase
It gives you an idea to retrive your information.
Filter with a proper WHERE like:
$user = JFactory::getUser();
... WHERE id = " . $user-­>id;

and make a loop with a foreach to display the fetching rows.
you bypass the traditionnal structure but you can still make it work like that by hacking the code.

Jthm could also be correct if you have a loadmodule type of script like the one of moduleanywhere at nonumber.

Alex
·
Monday, 04 August 2014 21:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for sharing Alex
·
Monday, 04 August 2014 23:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post