Skip to content

Instantly share code, notes, and snippets.

@lauroguedes

lauroguedes/extract_extra_fields_article_joomla.php

Last active May 23, 2018 02:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lauroguedes/bb99b4aa1bb2eafe24fbbd603eddedba to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lauroguedes/bb99b4aa1bb2eafe24fbbd603eddedba to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. lauroguedes revised this gist May 23, 2018. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion extract_extra_fields_article_joomla.php
    View file
    Original file line number Diff line number Diff line change
    @@ -5,6 +5,6 @@
    ->from($db->quoteName('#__content', 'c'))
    ->join('INNER', $db->quoteName('#__fields_values', 'fv') . ' ON (' . $db->quoteName('c.id') . ' = ' . $db->quoteName('fv.item_id') . ')')
    ->join('INNER', $db->quoteName('#__fields', 'f') . ' ON (' . $db->quoteName('fv.field_id') . ' = ' . $db->quoteName('f.id') . ')')
    ->where($db->quoteName('c.id') . '= 12');
    ->where($db->quoteName('c.id') . '= <article id>');
    $db->setQuery($query);
    $data = $db->loadObjectList();
  2. lauroguedes created this gist May 23, 2018.
    10 changes: 10 additions & 0 deletions extract_extra_fields_article_joomla.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    $db = JFactory::getDbo();
    $query = $db->getQuery(true);
    $query
    ->select(array('f.name','fv.value'))
    ->from($db->quoteName('#__content', 'c'))
    ->join('INNER', $db->quoteName('#__fields_values', 'fv') . ' ON (' . $db->quoteName('c.id') . ' = ' . $db->quoteName('fv.item_id') . ')')
    ->join('INNER', $db->quoteName('#__fields', 'f') . ' ON (' . $db->quoteName('fv.field_id') . ' = ' . $db->quoteName('f.id') . ')')
    ->where($db->quoteName('c.id') . '= 12');
    $db->setQuery($query);
    $data = $db->loadObjectList();