php and event switcher does not work properly

sa

samir1903 23 Feb, 2019

this new version bugs bugs and bugs

php16

$app =& JFactory::getApplication();
$db =& JFactory::getDBO();
$query = "
    SELECT COUNT(*)
        FROM `os5pk_chronoforms_data_xxxx`
        WHERE `no_DI` = '{$this->data['no_DI']}' or `correo` = '{$this->data['correo']}';
";
$db->setQuery($query);
$count = $db->loadResult();
if ( $count > 0 ) {
return 'registered_ID';
} else {
return 'look_codigo';
}

event swither data provider
{var:php16}
switches

registered_ID and look_codigo

this php return in debug always look codigo

i wanted to upload images here but i think there is a bug in forum as well i couldnt upload 🤣

Max_admin 23 Feb, 2019

Hi samir,

Please test with the new update ?

Also you can modify your code to do a quick test, use this:

pr($count);

to check the count value directly!

Best regards

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

sa

samir1903 23 Feb, 2019

Answer

right new version looks better
before ,it returned 0 therefore event switcher worked correct

however problem was in php

it appearded "and parameter" instead of "or parameter", even i am sure i put "or", this where i copied and pasted to the forum.

now changed and to or, it returned 1

so bug is gone
thanks

Forums

php and event switcher does not work properly