$query = $db->getQuery(true);
$user = JFactory::getUser();
$query
->select($db->quoteName('state'))
->from($db->quoteName('#__privacy_consents'))
->where($db->quoteName('user_id') . ' = ' . (int) $user->id);
$db->setQuery($query);
$state = $db->loadResult();
if ($state == 1) {
$state = 1;
} else {
$state = 0;
}
return $state;
$db->setQuery($query);
return ($db->loadResult() == 1);
$query = $db->getQuery(true)
->select($db->quoteName('state'))
->from($db->quoteName('#__privacy_consents'))
->where($db->quoteName('user_id') . ' = ' . (int) $user->id);
$db->setQuery($query);
$state = $db->loadResult();
return $state == 1;
$query = $db->getQuery(true)
->select($db->quoteName('state'))
->from($db->quoteName('#__privacy_consents'))
->where($db->quoteName('user_id') . ' = ' . (int) $user->id);
$db->setQuery($query);
$state = $db->loadResult();
echo "\n\n<pre>==========================\n";
print_r($user->id);
echo "\n--------------------------\n";
print_r($state);
echo "\n==========================</pre>\n\n";
return $state == 1;
SELECT `state`
FROM `m2db5_privacy_consents`
WHERE `user_id` = 12345 //(myid)
22 JDatabaseDriver->loadResult() /home/tmp/regularlabs/custom_php/2937_xxxxxx:19
$query = $db->getQuery(true)
->select($db->quoteName('state'))
->from($db->quoteName('#__privacy_consents'))
->where($db->quoteName('user_id') . ' = ' . (int) $user->id);
$db->setQuery($query);
$state = $db->loadResult();
echo "\n\n<pre>==========================\n";
print_r($user->id);
echo "\n--------------------------\n";
print_r($state);
echo "\n==========================</pre>\n\n";
exit;
->order($db->quoteName('created') . ' DESC');
->where($db->quoteName('state') . ' = 1')
$query = $db->getQuery(true)
->select($db->quoteName('state'))
->from($db->quoteName('#__privacy_consents'))
->where($db->quoteName('user_id') . ' = ' . (int) $user->id . ' AND' . $db->quoteName('state') . ' = 1')
->order($db->quoteName('created') . ' DESC');