For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
$myData = 10;
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->select('COUNT(element_1) AS mycount')->from('table_1')->where('element_1 != "0"')->where('element_2 = ' . $myDb->quote($myData));
$myDb->setQuery($myQuery);
return $myDb->loadResult();
$myQuery->select('COUNT(element_1) AS mycount')->from('table_1')->where('element_1 != "0"')->where('element_2 = ' . $myDb->quote($myData));
$cours_id = '{admin3_cours___id}';
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery
->select('COUNT('scolarite_id')')
->from('admin3_cours_planning')
->where('admin3_cours_planning.cours_id = '.$cours_id);
$myDb->setQuery($myQuery);
$nbeleve = $myDb->loadResult();
return $nbeleves;
I gess I'm fired ?$nbeleve = $myDb->loadResult();
return $nbeleves;
$cours_id = '{admin3_cours___id}';
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('COUNT(*)');
$query->from($db->quoteName('admin3_cours_planning'));
$query->where($db->quoteName('admin3_cours_planning.cours_id')." = ".$db->quote($cours_id));
$db->setQuery($query);
$nbeleve = $db->loadResult();
return $nbeleve;