$smarty->register_function(“getProfileChatEligiable”, “getProfileChatEligiable”);
function getProfileChatEligiable($params,$smarty){
$db = getDBHandler();
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$memberStatus = $params['memberStatus'];
$query = “SELECT a.scheme_id FROM en_task_master t, en_access_master a WHERE t.task LIKE ‘%initiate chat%’ AND t.task_id = a.task_id AND a.scheme_id = “.$memberStatus;
$res =& $db->getAll($query);
$arrcnt = sizeof($res);
return $smarty->assign($params["assign"],$arrcnt);
}
// In smart file
memberStatus need to assing a value ,
assing parameter will given return result from the function
{getProfileChatEligiable memberStatus =1 assign=”chatEligable”}
function getProfileChatEligiable($params,$smarty){
$db = getDBHandler();
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$memberStatus = $params['memberStatus'];
$query = “SELECT a.scheme_id FROM en_task_master t, en_access_master a WHERE t.task LIKE ‘%initiate chat%’ AND t.task_id = a.task_id AND a.scheme_id = “.$memberStatus;
$res =& $db->getAll($query);
$arrcnt = sizeof($res);
return $smarty->assign($params["assign"],$arrcnt);
}
// In smart file
memberStatus need to assing a value ,
assing parameter will given return result from the function
{getProfileChatEligiable memberStatus =1 assign=”chatEligable”}
No comments:
Post a Comment