Easy Profile - Joomla Extension

Support

Support is currently Offline

Support Offline

It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!

Official support hours:

Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 10:54 pm

Add a reply View Replies (1)

Resolved how to display custom sql-data in the profile

mightyskeet
Support
Tuesday, June 16 2015, 10:58 AM

Hello. Is there a way to display certain fields in the profile based on the value in the custom rows of sql table? I have some manually-added data in sql table and I need to display it in the profile. Can you advice how to do this? Thank you.

Accepted Answer

admin Accepted Answer

Admin

Hi,
the best way is to edit profile template and add manually SQL code to output.

You can use Joomla Template Override feature to do this:
- Copy /components/com_jsn/views/profile/tmpl/default_fields.php into /templates/your-template-folder/html/com_jsn/profile/default_fields.php
- Add a field of type HTML delimiter (example with alias "get_sql"

- in new file /templates/your-template-folder/html/com_jsn/profile/default_fields.php between lines 49 and 50 add something like this:

// LINE 49

if($field->fieldname=='get_sql'){

    $db=JFactory::getDbo();

    $query="SELECT value FROM #__your_table WHERE user_id=".(int) $this->data->id;

    $db->setQuery($query);

    echo $db->loadResult();

}

else

// LINE 50

With this the output of HTML delimiter will be replaced with your SQL value.

NOTE: This code is not supported and not tested.

more than a month ago
Support
# Permalink

Responses (1)

mightyskeet Accepted Answer

Thank you for response. I will try it )

more than a month ago
Support
# 1

Page :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Ask a Question

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.