marozen
Member
$db = FabrikWorker::getDbo();
$query = $db->getQuery(true);
$query->select('sum('.$db->quoteName('completed').')')->from('plantspecies_botany')
->where('userid ='. (int) '{my_profile___userid_raw}' );
$db->setQuery($query);
$results = $db->loadResult();
return $results;
I got an error because $db = the database of your Joomla website. I wanted to ask for help, but I found out the answer at /components/com_fabrik/fabrik/fabrik/Helpers/Worker.php: Just add code at the first line. Your $cnnId you can find at Components > Fabrik > Connections.
$db = FabrikWorker::getDbo($loadJoomlaDb = false, $cnnId = 3);
$query = $db->getQuery(true);
$query->select('sum('.$db->quoteName('completed').')')->from('plantspecies_botany')
->where('userid ='. (int) '{my_profile___userid_raw}' );
$db->setQuery($query);
$results = $db->loadResult();
return $results;
$query = $db->getQuery(true);
$query->select('sum('.$db->quoteName('completed').')')->from('plantspecies_botany')
->where('userid ='. (int) '{my_profile___userid_raw}' );
$db->setQuery($query);
$results = $db->loadResult();
return $results;
I got an error because $db = the database of your Joomla website. I wanted to ask for help, but I found out the answer at /components/com_fabrik/fabrik/fabrik/Helpers/Worker.php: Just add code at the first line. Your $cnnId you can find at Components > Fabrik > Connections.
$db = FabrikWorker::getDbo($loadJoomlaDb = false, $cnnId = 3);
$query = $db->getQuery(true);
$query->select('sum('.$db->quoteName('completed').')')->from('plantspecies_botany')
->where('userid ='. (int) '{my_profile___userid_raw}' );
$db->setQuery($query);
$results = $db->loadResult();
return $results;