How do I do to display the extra user fields into a Module?

jbananero
Topic Author
Offline
New Member

14 years 10 months ago #3787 by jbananero

How do I do to display the extra user fields into a Module? was created by jbananero

Hello everyone,

Sorry but I am beginner developping in Joomla.

Then I need your help please.

I wanted to know how to display the extra "user fields" into a module.

I have added extra fields into the articles (like "price", "calendar", "time",...) and I would like to display these fields into a module I have placed in the right column (in this case I am using the EventList).

But when I use the following code into the PHP file used by the module: <?php echo $this->fields->price->display; ?> that doesn´t return nothing.

How can I display the fields into the module?

Many thanks in advance for your help.

Please Log in or Create an account to join the conversation.

orchid1
Offline
Elite Member

14 years 10 months ago #3830 by orchid1

Replied by orchid1 on topic How do I do to display the extra user fields into a Module?

are you trying to use FLEXIcontent code inside a module because that isn't possible. Modules are independent creatures they don't directly relate to any components framework, they are literaly extensions. At best they share database access
Can you explain a bit more

“Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.” William A. Foster - USMC

Please Log in or Create an account to join the conversation.

jbananero
Topic Author
Offline
New Member

14 years 10 months ago #3903 by jbananero

Replied by jbananero on topic How do I do to display the extra user fields into a Module?

Thanks orchid1,

I supposed that. At the end I have accessed directly to the Flexicontents tables using SQL statements.

Here I set the function I have created, perhaps it can help to someone.

Variable $field_id is the field ID set by Flexicontent for each extra field.

function _getValues($field_id)
{
$id = JRequest::getVar('id');
$db = & JFactory::getDBO();
$query =
'SELECT t1.value, t2.label '.
'FROM #__flexicontent_fields_item_relations AS t1 '.
'INNER JOIN #__flexicontent_fields AS t2 ON t1.field_id = t2.id ' .
'WHERE t1.item_id = ' . $id . ' AND t1.field_id = ' . $field_id . ' ' .
'ORDER BY t1.value';

$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ($rows as $row)
{
$temp["label"] = $row->label;
$temp["value"] = $row->value;
}
return $temp;
}

Regards.

Please Log in or Create an account to join the conversation.

alessek
Offline
New Member

14 years 6 months ago #7247 by alessek

Replied by alessek on topic How do I do to display the extra user fields into a Module?

Hi,

I lost in flexi sources..

Could you help me with another problem please ?

I need to have extra user fields in Title of items list in category.

Code:

<?php foreach ($this->items as $item) : ?>
  			<tr class="sectiontableentry">

				<!-- BOF item title -->
    			<th scope="row" class="table-titles">
    				<?php if ($this->params->get('link_titles', 0)) : ?>
    				[url=<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($item->slug, $this->category->slug)); ?>]<?php echo $this->escape($item->title); ?>[/url]
    				<?php
    				else :
    				echo $this->escape($item->title);
    				endif;
    				?>
				</th>
				<!-- BOF item title -->

Code:

<?php echo $this->escape($item->title); ?>

I need to put here connected extra fields like this.

my_extra_field1 + my_extra_field2 + my_extra_field3

Is it real to do it?

I´m not so good programmer

Please Log in or Create an account to join the conversation.

yopyop001
Offline
Moderator

14 years 6 months ago #7248 by yopyop001

Replied by yopyop001 on topic How do I do to display the extra user fields into a Module?

Hi,

You can call a field in your template with the code

Code:

<?php echo $this->fields['field_name']->display; ?>

I hope it will help you.

Regards

Please Log in or Create an account to join the conversation.

alessek
Offline
New Member

14 years 6 months ago #7261 by alessek

Replied by alessek on topic How do I do to display the extra user fields into a Module?

I hope it will be good with your help, but it doesn´t work

So I tried some alternatives of your code but unsuccessfully.

Do you have another tip, idea ?

Is it true that escape($item->title) is getting information from table of joomla articles ?

Please Log in or Create an account to join the conversation.