I know the original, but I can"t write it in the laravel way, because there are still pages in the back. It"s too troublesome to write your own pages. Which god would like to talk about it? thank you.
the following is the native sql
select * from (select f.idrecoveryf.useraccounidreu.nicknamedirection f.signrecoveryf.contentPowerf.statusreachf.useraccounipjournal f.setconsumtime from feedback as users as u where f.user_id=u.id order by set_time desc) as t group by t.user_id
field is a little different. Change it yourself
DB::enableQueryLog();
$subQuery = DB::table(DB::raw('`feedback` as f,`users` as u'))
->where('f.user_id', '=', DB::raw('`u`.`id`'))
->orderBy('f.created_at', 'desc')
->select(['f.id', 'f.user_id', 'u.name', 'f.content', 'f.created_at']);
$query = DB::table(DB::raw("({$subQuery->toSql()}) as t"))
->mergeBindings($subQuery)
->groupBy('t.user_id')
->get(['t.*']);
$result = DB::getQueryLog();
print_r($result);printed result:
Array
(
[0] => Array
(
[query] => select `t`.* from (select `f`.`id`, `f`.`user_id`, `u`.`name`, `f`.`content`, `f`.`created_at` from `feedback` as f,`users` as u where `f`.`user_id` = `u`.`id` order by `f`.`created_at` desc) as t group by `t`.`user_id`
[bindings] => Array
(
)
[time] => 112.89
)
)Next: Vue snooping data
post table is the article table, the primary key is id tag table is the tag table, the primary key is id post_tag is the intermediate mapping table, and the field is post_id,tag_id now I want to select tag 1 to find out that all the tags and article...
I judge in the render method of Handler that FatalErrorException returns an array when an exception occurs. there are other error messages on the returned array, but should you only return the array when catching an exception? how to solve this sit...
laravel Package development, how to deal with the many-to-many relationship between Model in a package and Model outside the package? for example: for example, we are going to write an awesome Article Package,. This package mainly provides functions ...
I think belongsTo or hasMany is usually written in model. What s the use of writing this? The following is the code in someone else s Car model. I think when he used it in the controller, he wrote $car = Car::find ($id) . It doesn t seem to be conve...
laravel big data export cannot perform how to optimize ...
suppose: there are two projects, Project An and Project B, and I want Project An and Project B to share the same framework. Is there a way to achieve ...
https: devforgalaxy.github.i. I am here to see the first step alone is off . sudo php -r "readfile( https: getcomposer.org installer );" > composer-setup.php -bash: composer-setup.php: Permission denied ...
what is the difference between the request parameters obtained by Input:all () in the laravel framework and the native $REQUEST acquisition parameters in php? $input = Input:all (); $input = { "P_UserId ": "10 ", "P_OrderId ": "2302722018033018420...
1. Do you need a framework? the framework loads too many files by default, which hinders performance . two The framework comes with interface verification (to prevent arbitrary calls), version management (APP version upgrade is fast), etc., if there is ...
Laravel version5.5, uses php artisan serve to start the metropolis server to confirm that the route has been registered, the result obtained by using php artisan route:list is as follows visit batches and return 200 correctly visit b...
I added withCredentials to my front-end request, even though I deployed the front and back ends separately. assume that the front end is deployed at web.xxx.com and that the back end is deployed at service.xxx.com I define all api as web, so ...
by editing a template file such as file.xls, there is a lot of data that needs to be filled in by php, and then other text or tables may have styles, such as red words, large words, table borders, etc. (I have tried to export csv, but feel that this for...
download : ask the boss to answer it! ...
$validator = Validator::make($request->all(), [ id => required|integer title => required|unique:posts|max:255 , body => required , ]); The requirement is like ...
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...
how do I use a laravel package such as l5-repository ( https: packagist.org package.) when developing a laravel package myself? We can use composer require to come in, but how do we register ServiceProvider in the package? ...
I use js to assemble the data and then ajax to transmit it to the background. $request- > file () always cannot receive the file, and the file field passed by is always converted into a string [object File] how to solve foreground ajax code onAjax(f...
Mini Program post requests that an array of objects is passed in the data. What happened to the [object Object] printed out by the backend? ...
Why do you have to insert a new piece of empty data every time you execute this statement one more empty data at a time. I don t know how to ask for advice ...
the configuration of Redis was not found in official document . How should I configure it? add: configure requirepass in the configuration file of Redis, but this Redis is on Homestead, not locally. Because of my unfamiliarity with Homestead, I don ...