工作中遇到 需要自定义排序的情况,步骤如下:文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
1.首先引入Expression类文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
use think\db\Expression;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
2.排序时准备工作文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
// 自定义排序文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
$ids="1,3,2,5,7,9";文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
$exp=new Expression("field(id,$ids)");文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
// 查询时文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
$res=Db::table('table')->whereIn('id',$ids)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
->order($exp)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
->select();文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html
这样便可自定义排序文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/30495.html