how to return data in array using laravel

Question

good day ; I have custom data base helper in laravel framework I have easy question how to return data in array not in objects. her is my function

public static  function  allData($dbName,$tableName,$condition,$data){

            $stattment=
                DB::connection($dbName)
                    ->table($tableName)
                    ->select(['*'])
                    ->whereRaw($condition, $data)
                    ->get();

            return $stattment;

        }

next function

public static function getDataById($dbName,$tableName,$condition,$data)
        {
            $stattment=
                DB::connection($dbName)
                    ->table($tableName)
                    ->select(['*'])
                    ->whereRaw($condition, $data)
                    ->get();
            return $stattment;
        }

you can use return $stattment->toArray();

Karan
– Karan

2019-06-12 12:35:52 +00:00
Commented Jun 12, 2019 at 12:35 — Karan
– Karan, Commented Jun 12, 2019 at 12:35

sybear · Accepted Answer · 2019-06-12 12:38:29Z

1

The query result is a Collection object has a toArray() method.

https://laravel.com/docs/5.8/collections#method-toarray

answered Jun 12, 2019 at 12:38

sybear

7,7921 gold badge25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zlatan · Accepted Answer · 2019-06-12 13:20:59Z

Laravel has in-built toArray() method

You can use it like this:

public static  function  allData($dbName,$tableName,$condition,$data){

        $stattment=
            DB::connection($dbName)
                ->table($tableName)
                ->select(['*'])
                ->whereRaw($condition, $data)
                ->get();

        return $stattment->toArray();

    }

Same goes for the other function:

public static function getDataById($dbName,$tableName,$condition,$data)
    {
        $stattment=
            DB::connection($dbName)
                ->table($tableName)
                ->select(['*'])
                ->whereRaw($condition, $data)
                ->get();
        return $stattment->toArray();
    }

Now your $statement will be displayed as array.

Collectives™ on Stack Overflow

how to return data in array using laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related