How to add Search and Filter Bar in Yii2

[Raafat]

I am developing a database application using Yii Framework. I am reading tables from MySQL database and displaying them to the user. I need the user to be able to filter the fields in the table or search for a certain value.

For example, I have a table named "supermarkets":

CREATE TABLE IF NOT EXISTS `supermarkets` (
`name` varchar(71) NOT NULL,
`location` varchar(191) DEFAULT NULL,
`telephone` varchar(68) DEFAULT NULL,
`fax` varchar(29) DEFAULT NULL,
`website` varchar(24) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

.../model/supermarkets:

<?php

namespace app\models;

use yii\db\ActiveRecord;

class Supermarkets extends ActiveRecord
{



}

.../views/supermarkets/index.php:

<?php
use yii\helpers\Html;
use yii\widgets\LinkPager;
?>
<h1>Supermarkets</h1>
<ul>
<?php
$array = (array) $supermarkets;

function build_table($array){

// start table

$html = '<table class="altrowstable" id="alternatecolor">';

// header row

$html .= '<tr>';

foreach($array[0] as $key=>$value){

$html .= '<th>' . $key . '</th>';

}

$html .= '</tr>';

// data rows

foreach( $array as $key=>$value){

$html .= '<tr>';

foreach($value as $key2=>$value2){

$html .= '<td>' . $value2 . '</td>';

}

$html .= '</tr>';

}

// finish table and return it

$html .= '</table>';

return $html;

}



echo build_table($array);

?>

....Controllers/SupermarketsController:

<?php

namespace app\controllers;

use yii\web\Controller;

use yii\data\Pagination;
use app\models\Supermarkets;
class SupermarketsController extends Controller
{
public function actionIndex()
{
$query = supermarkets::find();

$pagination = new Pagination([
'defaultPageSize' => 20,
'totalCount' => $query->count(),
]);

$supermarkets = $query->orderBy('Name')
->offset($pagination->offset)
->limit($pagination->limit)
->all();

return $this->render('index', [
'supermarkets' => $supermarkets,
'pagination' => $pagination,
]);
}
}

I need the user to be able to filter the table or search its fields by one or more attribute. I'm using Yii2, so CDbcriteria doesn't work. How can I do this?

[mac_gyver]

the yii framework has it's own dedicated community/help forum, where you are more likely to get specific help with your questions, rather than on the multiple general php help forums you have been posting.

 

also, please use the forum's

bbcode tags (the edit form's <> button) around code you post.