function filterNotEqualCountryInfo($getID) { $this->getID = $getID; $tableName = 'HS_HR_COUNTRY'; $arrFieldList[0] = 'COU_CODE'; $arrFieldList[1] = 'COU_NAME'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sqlQString = $sql_builder->filterNotEqualRecordSet($this->getID); //echo $sqlQString; $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function $i = 0; while ($line = mysql_fetch_array($message2, MYSQL_NUM)) { $arrayDispList[$i][0] = $line[0]; // Province Code $arrayDispList[$i][1] = $line[1]; // Provicne Name $i++; } if (isset($arrayDispList)) { return $arrayDispList; } else { $arrayDispList = ''; return $arrayDispList; } }
function filterNotEqualEducation($getID) { $this->getID = $getID; $tableName = 'HS_HR_EDUCATION'; $arrFieldList[0] = 'EDU_CODE'; $arrFieldList[1] = 'EDU_UNI'; $arrFieldList[2] = 'EDU_DEG'; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_select = 'true'; $sql_builder->arr_select = $arrFieldList; $sqlQString = $sql_builder->filterNotEqualRecordSet($this->getID); //echo $sqlQString; $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); //Calling the addData() function $i = 0; while ($line = mysql_fetch_array($message2, MYSQL_NUM)) { $arrayDispList[$i][0] = $line[0]; $arrayDispList[$i][1] = $line[1]; $arrayDispList[$i][2] = $line[2]; $i++; } if (isset($arrayDispList)) { return $arrayDispList; } else { $arrayDispList = ''; return $arrayDispList; } }