Introducing the usage of Laravel subquery statements
Jan 28, 2021 pm 04:59 PMThe following tutorial column will introduce you to the usage of Laravel subquery statements. I hope it will be helpful to friends who need it!
class UserController extends Controller{ public function index() { $columns = ['id', 'name', 'email', 'created_at']; $users = User::addSelect([ 'last_post_title' => Post::select(['title']) ->whereColumn('user_id', 'users.id') ->where('status', Post::STATUS_NORMAL) ->orderByDesc('created_at') ->limit(1) ])->orderByDesc('id')->paginate(20, $columns); return view('user.index', ['users' => $users]); }}
The above is the detailed content of Introducing the usage of Laravel subquery statements. For more information, please follow other related articles on the PHP Chinese website!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP vs. Flutter: The best choice for mobile development

Analysis of the advantages and disadvantages of PHP unit testing tools

How to use object-relational mapping (ORM) in PHP to simplify database operations?

Comparison of the latest versions of Laravel and CodeIgniter

PHP distributed system architecture and practice

How do the data processing capabilities in Laravel and CodeIgniter compare?

PHP code unit testing and integration testing
