yii两表联查分页

来源：互联网发布：excel表删除重复数据编辑：程序博客网时间：2024/06/03 13:20

model

<?phpnamespace frontend\models;use Yii;use yii\db\ActiveRecord;class Stud extends  ActiveRecord{    /**     * 定义表名     *     * @author YING     * @param void     * @return void     */    public static  function tableName()    {        return '{{%stud_class}}';    }}

controller

use frontend\models\Stud;use yii\data\Pagination;

/** * 实验两表联查 * * @author YING * @param void * @return void */public function actionTwoSearch(){    //实例化模型    $stud=new Stud();    //查询    $data=$stud->find()->select('*')->innerJoin('stud_class_exist','stud_class.class_id=stud_class_exist.class_id')->where(['stud_id'=>2]);    //实例化分页类    $pagination=new Pagination(['totalCount' => $data->count()]);    //每页条数    $pagination->setPageSize(3);    //执行分页    $userInfo= $data->offset($pagination->offset)->limit($pagination->limit)->asArray()->all();    //返回值    return $this->render('twoSearch',['userInfo'=>$userInfo,'pages'=>$pagination]);}

views

<?phpuse yii\widgets\ActiveForm;use yii\helpers\Html;use yii\helpers\Url;use yii\widgets\LinkPager;?><table class="table">    <?php foreach($userInfo as $v):?>        <tr>            <td><?= $v['class_id']?></td>            <td><?= $v['class_name']?></td>        </tr>    <?php endforeach; ?></table><?phpecho LinkPager::widget([    'pagination' => $pages,]);?>

0 0