Question 17664 in Laravel Question posted in
The official Laravel Documentation can be found here.

Looping multyple DB connections in Laravel

I am summing the columns from different tables each in a different database. Created the models for each of the 8 connections and added them to the controller.

use AppModelsobjectMapping1;
use AppModelsobjectMapping2;
use AppModelsobjectMapping3;
use AppModelsobjectMapping4;
use AppModelsobjectMapping5;
use AppModelsobjectMapping6;
use AppModelsobjectMapping7;
use AppModelsobjectMapping8;

My code works but I am not satisfied with it:

    $multyconnections1 = objectMapping1::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections2 = objectMapping2::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections3 = objectMapping3::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections4 = objectMapping4::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections5 = objectMapping5::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections6 = objectMapping6::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections7 = objectMapping7::where('userFK', '!=', 1)->where('del', 'no')->count();
    $multyconnections8 = objectMapping8::where('userFK', '!=', 1)->where('del', 'no')->count();
    
    $count = $multyconnections1 + $multyconnections2 + $multyconnections3 + $multyconnections4 + $multyconnections5 + $multyconnections6 + $multyconnections7 + $multyconnections8;
    print_r($count);

Now I’m trying to create a loop for the job, but I don’t know how to specify the models in the array… that’s what I’ve got so far.

$count = 0;
    $arrs = array('objectMapping1','objectMapping2', 'objectMapping3', 'objectMapping4', 'objectMapping5', 'objectMapping6', 'objectMapping7', 'objectMapping8' );
    foreach($arrs as $arr){
    $total = $arr::where('userFK', '!=', 1)->where('del', 'no')->count();
    
     $count+=$total;   
     print_r($count);
    }

I am given the error "Class "objectMapping1" not found"

Tried searching for different solutions but found none…any ideas?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
     function multyTable(){
        $count = 0;
        $arrs = array((new objectMapping1), (new objectMapping2),
         (new objectMapping3), (new objectMapping4), (new objectMapping5),
         (new objectMapping6), (new objectMapping7), (new objectMapping8()) );
        dump($arrs);

        foreach($arrs as $arr){
            $total = $arr::where('userFK', '!=', 1)->where('del', 'no')->join()->count();
        
            $count+=$total;   
        
        }
        print_r($count);

    It works like that + formatting


  2. 0

    Try creating array of objects like this

    $arrs = array(new objectMapping1, new objectMapping2, new objectMapping3, new objectMapping4, new objectMapping5, new objectMapping6, new objectMapping7, new objectMapping8);

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search