Rymercyble

it depends query to query - eloquent builds query in some way but in terms of efficiency sometimes is join better sometimes is subquery better and maybe they found that their queries built by eloquent would have opposite one what i think they didn't maybe they just thinks thats the case this is up to you to ask them

but i have to say eloquent is completely fine unless their db got higher millions of rows

for future readers - in config\database.php define connection for each schema and then use proper connection in model

Anybody knows about using eloquent with postgresql db ? documentation says laravel supports postgresql but i can't find any examples of usage especialy with multiple schemas

first of all this will cause dom error of duplicate id

if you for some reason need to get all 3 values then do as name action[]

can you also show AccountData file ?

are you sure about syntax inside ->with() method ? there should be names of relation definitions inside your model

which method got this problem ?

well that was so easy i would never think it will be

hello, i'm trying to get data from db and order them by two columns group and position with

->orderBy('group')
->orderBy('position')

it returns order 1-1, 2-1, 1-2, 2-2 etc but i need 1-1, 1-2, 2-1, 2-2 is there a way how to do this ?

c_id is null because you are missing value of your country select

<option value ="">

also naming is wrong your option menu got name country and state what is key to access data passed from this input but you are trying to access it via s_name

hello, i have got tables articles, files and uploads

my current query

ArticleNew::where('article_id', 2931)
            ->with([
                'files' => function($query){
                    $query->select('url', 'filename', 'mimetype', 'db_files_new.file_id')
                        ->orderBy('file_id');
                },
                'uploads' => function($query){
                    $query->where('thumbnail_id', '!=', 0)
                        ->select('db_uploads_new.file_id', 'thumbnail_id');
                },
                'category',
                'relations',
            ])->select('article_id', 'lang_id', 'url', 'author_id', 'created_on', 'title', 'description', 'content')
            ->get();

it returns article itself and related files (images/videos) but if it is video then it got thumbnail paired via uploads table but this returns only thumbnail_id from uploads table and i also need to get data from files table for that thumbnail_id