Hello me code is the next.
I know that it is wrong but i need help for show result of one query of search.
Sorry me english is bad
Method that in the SiteController
public function actionAbout()
{
$form= new formBusqueda;
$search = null;
if($form->load(Yii::$app->request->get()))
{
if ($form->validate())
{
$search = Html::encode($form->q);
$query = new Query;
$query ->select(['t_complejos.id_complejos'])
->from('t_complejos')
->join( 'INNER JOIN',
't_canchas',
't_canchas.id_cancha = t_complejos.id_complejos'
);
$model = $query->createCommand();
$model = $command->queryAll();
}
else
{
$form->getErrors();
}
}
return $this->render("about", ["model"=>$model, "form"=>$form, "search"=>$search]);
}
View
<?= $f->field($form, "q")->input("search") ?>
<?= Html::submitButton("buscar", ["class" => "btn btn-primary"]) ?>
</div>
<?php $f->end() ?>
Model
<?php
namespace app\models;
use Yii;
use yii\db\ActiveRecord;
class t_complejos extends ActiveRecord {
public static function getDb()
{
return Yii::$app->db;
}
public static function tableName()
{
return 't_complejos';
}
}
<?php
namespace app\models;
use Yii;
use yii\db\ActiveRecord;
class T_canchas extends ActiveRecord {
public static function getDb()
{
return Yii::$app->db;
}
public static function tableName()
{
return 't_canchas';
}
}