Geek Answers Handbook

How to get data from union relationships in yii

I start at Yii, so I ask this question.

I have three tables.

First table

First table language(id, language_name)

// id is the primary key.

Second table

Second table verse(id, topic_id, surah_id, verse_text)

// id is the primary key,

Third table

Third table verse_translations(id, verse_id, language_id, translations_text)

// id - primary key, language_id - links to foreign keys with a language table,

// verse_id - links to foreign keys with a verse table.

Now my question.

I want to get a list of languages ​​for available translations with specific verse_id.? To do this, I want to make a relationship in the verse model file that will return the languages ​​that are available to me, so how do I get the result in the view.? and what will be the changes in the poetic model, presentation and controller if any changes occur.

I wrote a MySQL query, which is below.

SELECT language.language_name from language 
Inner Join verse_translations ON  verse_translations.language_id = language.id
Where verse_translations.verse_id = 1

Yii.

gii.

.

public function relations()
{
 return array(
    'sorah' => array(self::BELONGS_TO, 'Sorah', 'sorah_id'),
    'topic' => array(self::BELONGS_TO, 'Topic', 'topic_id'),
    'verseFeedbacks' => array(self::HAS_MANY, 'VerseFeedback', 'verse_id'),
    'verseImages' => array(self::HAS_MANY, 'VerseImages', 'verse_id'),
    'verseLinks' => array(self::HAS_MANY, 'VerseLinks', 'verse_id'),
    'verseTafseers' => array(self::HAS_MANY, 'VerseTafseer', 'verse_id'),
    'verseTranslations' => array(self::HAS_MANY, 'VerseTranslations', 'verse_id'),
    'language_name' => array(self::HAS_MANY, 'Language', 'id'),
 );
}
+4
2

.

.

'verseTranslations' => array(self::HAS_MANY, 'VerseTranslations', 'verse_id'),

, 10 10 verse_id 1, . , verse_translation language_id.

, language_id.

, language_id verseTranslations, .

'verse_lang' => array(self::HAS_MANY, 'Language', array('language_id'=>'id'), 'through'=>'verseTranslations'),

Sql Query, .

'verseTranslations' => array(self::HAS_MANY, 'VerseTranslations', 'verse_id'),
'verse_lang' => array(self::HAS_MANY, 'Language', array('language_id'=>'id'), 'through'=>'verseTranslations'),

var_dump($data->verse_lang)

.

. .

http://www.yiiframework.com/doc/guide/1.1/en/database.arr#relational-query-with-through

, .

, .

.

+1

sql,

$result = Yii::app()->db->createCommand()
->select('l.language_name')
->from('language l')
->join('verse_translations vt' , 'l.id = vt.language_id ')
->join('verse v' , 'vt.id = v.id')
->where('v.id = :var' , array(':var'=>1))
->queryAll();

btw , sql: D

UPDATE: mysql , , . , :

$vers = Ver::model()->findByPk(1);
$allLangs = $vers->language_name; // this will give you an array of Language Model back

,

+1

More articles:


All Articles