//
class essay extends Model
{
public function comment()
{
return $this->hasMany("App\comment")
}
}
//
class comment extends Model
{
public function essay()
{
return $this->belongsTo("App\essay")
}
}
how to get the first 10 comments in each article
// 10
essay::with(["comment" => function($query) {
$query->take(10)
}])
ask all the bosses to help
with means eager loading. It means to "crave out" the associated information when you need it. So if you want to get the top 10 comments in each article, you have to find all the articles and then load the comments for each article.
essay::get()->comment()->take(10);
from: https://codeshelper.com/a/11. there are two ways to do this. You have tested it yourself, but you should pay attention to the following.
/ / the first method, the third method written by the author.
$sub = Comment::whereIn('post_id',$postIds)->select(DB::raw('*,@post := NULL ,@rank := 0'))->orderBy('id');
to
$sub = Comment::whereIn('post_id',$postIds)->select(DB::raw('*,@post := NULL ,@rank := 0'))->orderBy('post_id');
/ / the second method is the first netizen (Night Shadow) under the URL comment
I am trying to read java and want to fix in String coding values, but the updating Console. Read complete about Buy Essay and String (" Enter a real value of string: ") does not actually work.
just started to use the laravel framework development, or rookies ~ a lot of do not quite understand, at present to do a function, customized a form verification class file ~ ~ for example, I am now a member module, my member controller can have many way...
1.bootstrap-treeview onNodeExpanded gets the current height, but each time it gets the height before deployment. I want to get the current height after deployment 2. 3.console.log (event) sees that the clientHeight inside is 1049; but console.log...
$res = DB::connection( mysql_business )->table( t_activity ) ->select( SELECT app_id,title ,created_at,id FROM t_activity WHERE created_at > ? ORDER BY created_at DESC , [ 2018-04-01 20:11:12 ...
demand: collation 7 7 Table structure: Company Table: id, name (Company name) user Table: user_id, company_id (company association ID), last_login (last login time) ...
can the 1.spatie laravel-backup backup database specify which tables are backed up, which tables do not need to be backed up, and how to configure them? 2. 3. At present, it specifies the database type, and I don t think these are specified in the ...
has such an idea: the front-end and back-end codes of the project are deployed in a CVM of your own. your own CVM stores basic database data; users choose my server to store data or the server they buy to store data. I don t know if there is ...
there is a user ranking table, which needs to be sorted by score and output. If there is a duplicate user, take the highest score of that user now I write DB::select("SELECT nickname, id, fraction, FIND_IN_SET( fraction, ( ...
the demand is like this. After the seller publishes the product, the buyer buys it, and the buyer confirms it after completion. do you want to create two data tables for buyers and sellers to store order data? because once the buyer deletes the orde...
check the execution log during the test, but the log is not displayed in real time. is there any software that displays the log in real time? ...
I used this update statement in three scenarios the first two scenarios that I commented out are updated without a problem when the third scenario is updated, update-time has been updated, but status has not been updated I don t quite understand wh...
I remember that there is a platform that provides interfaces to add, delete, modify and check data. but forget which website it is. If you know, please let me know. write a simple small project, do not want to build php+mysql Thank you! ...
found occasional data loss in mysql. This time I lost a record in the order table. I used laravel framework . generate order retention user submit order-> Table 1 generate order-> user payment-> payment callback-> Table 1 status modification, insert...