Translation::GetTranslations PHP Method

GetTranslations() public static method

Return an array of phrases indexed by language ID.
public static GetTranslations ( integer $p_phraseId, array $p_sqlOptions = null ) : array
$p_phraseId integer
$p_sqlOptions array
return array
    public static function GetTranslations($p_phraseId, $p_sqlOptions = null)
    {
        global $g_ado_db;
        $phrases = array();
        if (!is_numeric($p_phraseId)) {
            return $phrases;
        }
        $sql = "SELECT fk_language_id, translation_text FROM Translations WHERE phrase_id = {$p_phraseId}";
        $rows = $g_ado_db->GetAll($sql);
        if (is_array($rows)) {
            foreach ($rows as $row) {
                $phrases[$row['fk_language_id']] = $row['translation_text'];
            }
        }
        return $phrases;
    }

Usage Example

Example #1
0
 /**
  * Parses m_metadata for phrase_ids and returns an array of language_id => translation_text
  *
  * @return array
  */
 public function getTranslations()
 {
     return Translation::GetTranslations($this->getPhraseId());
 }