Rendering custom fields in module latest news

[danismar2018]

Dear,

I've created some custom fields to integrate into a certain category of articles. These articles are displayed in a customized module of latest news. I would like to display these custom fields in the module, but I can not. Could someone help me in this matter

Thank you!

[effrit]

hi
you must make database request.
you can do it by php or using Joomla classes but it's still DB request...

for single article with id = $id

Code: Select all

$db = JFactory::getDbo();
$query = 'select * from #__fields_values where item_id = "'.$id.'"';
$db->setQuery($query);
$fields = $db->loadObjectList();

by framework

Code: Select all

        $item->jcfields = FieldsHelper::getFields('com_content.article', $item, true);
        $fields = [];
        foreach($item->jcfields as $jcfield)
        {
            $fields[$jcfield->name] = $jcfield;
        }

        var_dump ($fields);

[sanji]

hi
you must make database request.
you can do it by php or using Joomla classes but it's still DB request...

for single article with id = $id

Code: Select all

$db = JFactory::getDbo();
$query = 'select * from #__fields_values where item_id = "'.$id.'"';
$db->setQuery($query);
$fields = $db->loadObjectList();

by framework

Code: Select all

        $item->jcfields = FieldsHelper::getFields('com_content.article', $item, true);
        $fields = [];
        foreach($item->jcfields as $jcfield)
        {
            $fields[$jcfield->name] = $jcfield;
        }

        var_dump ($fields);

Ok, but how do we do it? Do we need to create a module?

[effrit]

the topic is about "Rendering custom fields in module latest news" so you must create new template for this module (or override in template for it)and paste first or second example code it it in loop there items are shown

[danismar2018]

hi
you must make database request.
you can do it by php or using Joomla classes but it's still DB request...

for single article with id = $id

Code: Select all

$db = JFactory::getDbo();
$query = 'select * from #__fields_values where item_id = "'.$id.'"';
$db->setQuery($query);
$fields = $db->loadObjectList();

by framework

Code: Select all

        $item->jcfields = FieldsHelper::getFields('com_content.article', $item, true);
        $fields = [];
        foreach($item->jcfields as $jcfield)
        {
            $fields[$jcfield->name] = $jcfield;
        }

        var_dump ($fields);

OK! More then I have the following situation: Each article will have a different custom field value. How to redenricionar the respective field in the module?

Code: Select all

	<ul class="latestnews<?php echo $moduleclass_sfx; ?>">
<?php foreach ($list as $item) : ?>
	<li itemscope itemtype="https://schema.org/Article">
		<a href="<?php echo $item->link; ?>" itemprop="url">
			<span itemprop="name">
				<?php echo $item->title; ?>
			</span>
		</a>
	</li>
<?php endforeach; ?>

</ul>

[effrit]

paste in any place inside foreach.
after <li itemscope itemtype="https://schema.org/Article">, for example.

Code: Select all

<?php
		$id=$item->id;
		$db = JFactory::getDbo();
		$query = 'select * from #__fields_values where item_id = "'.$id.'"';
		$db->setQuery($query);
		$fields = $db->loadObjectList();

		foreach ($fields as $field) {
			if ($field->field_id == 2) { // 2 - id of your custom field
			echo $field->value;
			}
		}
		?>

[diinekis]

Hi,

Above code renders the CF value, how can I show also the custom field label?

Thank you.