Hi all,
I am still a newbie and am stuck on searching on a model using a dynamic variable.
I have 2 models MdGeneral(md_id,…) and MdTerm(md_id,term_code,…)
Model [color="#FF0000"]MdGeneral[/color] looks like this, which works!
public function search()
{
$term = "2005-2010";
$criteria=new CDbCriteria;
$criteria->condition = "(
MPID IN(SELECT MdID FROM [color="#FF0000"]md_term[/color] WHERE term_code ='".$term."')
)";
return new CActiveDataProvider(get_class($this), array(
'criteria'=>$criteria,
));
}
BUT I want to be able to dynamically specify $term from a textfield in my mpGeneral view, _search form.
section of _search form looks like this:
<div class="row">
<?php echo $form->label($model,'md_id'); ?>
<?php echo $form->textField($model,'md_id',array('size'=>20,'maxlength'=>50)); ?>
</div>
<div class="row">
<?php echo $form->label($mdTerm,'term_code'); ?>
<?php echo $form->textField($mdTerm,'term_code',array('size'=>20,'maxlength'=>50)); ?>
</div>
I can’t seem to $_GET [color="#FF0000"]$mdTerm->term_code [/color]from the [color="#FF0000"]mdGeneral controller[/color],
My controller looks like this,
public function actionAdmin()
{
$model=new MdGeneral('search');
$mdTerm=new MdTerm('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['MdGeneral']))
$model->attributes=$_GET['MdGeneral'];
$term = $_GET['MdTerm'];
$this->render('admin',array(
'model'=>$model,
'mdTerm'=>$mdTerm,
));
}
Any help will be much appreciated. Thanks in advance.