SELECT t.*,u.`name`
FROM template t
INNER JOIN `user` u
ON u.id = t.user_id
WHERE t.is_delete = 1
AND ( t.title LIKE "%abc%" or u.`name` LIKE "%abc%" )above are the sql statements I want to implement, and the model model relationships are all correct
.what if it is paged on this basis
Template::join('user', 'template.user_id', '=', 'user.id')
->where('is_delete', 1)
->where(function ($query) {
$query->where('title', 'like', '%abc%')
->orWhere('user.name', 'like', '%abc%');
})->skip(*(-1))->take()
->get();you can try, it's written like this
paginate () or array_slice () handle it yourself
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 ...
1. Query the user list and initially change the associated order table, but there are too many users, which causes the mysql placeholder to pass and a mysql error is reported. 2, User::with ( order )-> get () error: General error: 1390 Prepared st...
as shown in the picture, the red box area is supposed to be Powered by Alter Way, but my display is also the same with garbled reinstallation ...
the problem encountered when installing valet, wrote export PATH= "$PATH:$HOME .composer vendor bin " in .bashrc and executed source .bashrc , but it is still not mentioned in the documentation in the system path. what should I do this is .bashrc ...
ajaxjsonjsonjson500 laravel: I ve been messing around all day. Ask for advice. ...
for example, http: localhost -sharp list 2230, or get the ID after list. Thank you. ...
attachment (Attachment) can be used as either a picture of the comment details (CommentDetail) or an avatar of the user s (User). Their data structures are as follows: CommentDetail id - integer cid - integer content - text User id - i...
now there is a requirement for the project to obtain order data from ebay and import it into the database. At first, the order data is obtained through the interface, and then the data is placed in the queue and inserted into the database. Now I want to...
Where is the elegance of laravel? ...
$arr = array( "a" => "1" "b" => "2" "c" => "3" "d" => "4" "e" => "5" "f" => "6" ); $str = array( ...
Asynchronous sorting class TagController extends CommonController{ ...
Front end: VUE back end: Laravel my requirement is that the verification code generated at the backend is stored in the session, and then the verification code in the session is compared with the verification code sent from the front end when the fro...
$this->validate($request,{ id => required|integer }); how to validate the field integer or array when validating the same field ...
there is an access to the php file under the server folder, but the ip nginx shows that no static html file can be accessed. Google Baidu modified php-fpm and folder permissions is still wrong. I have no problem building the same configuration under the...
there is an old laravel project with the user s password field. Now the data of this project needs to be migrated to other languages (go). but the password field cannot reverse hash out of the original value, . how should I handle this situa...
1. Now there are two controllers under two folders. A _ method 2. Because in the business, according to the conditions, the methods of different controllers are called, for example: $temp; if(true){ requre_once($temp."Controller.php"); ...
I want some template variables to be available globally, such as some system setup information and website title classes, and different modules may need to call the same variables. how can such variables be used globally? now I ve done a simple test ...
deployed in the local laravel project, 500 error, but there are no details on the page, as follows, do not know how to solve this error? ...
from DB::statement ( "START TRANSACTION "); I probably think one of his statements is a session link, so I can t get insertID. how do you write it in native language? DB::getPdo ()-> lastInsertId (); always feels unstable ...
PCNTL has been opened successfully, but laravel executes composer require laravel horizon and still reports the above error ...