Laravel insert data array to database

Question

I have this line of codes at my Controller to get data from google analytics

$analyticsData = Analytics::performQuery(Period::days(30),
    'ga:',
    [
        'metrics' => 'ga:users,ga:newUsers,ga:sessions,ga:sessionsPerUser,ga:pageviews,ga:pageviewsPerSession,ga:avgSessionDuration,ga:bounceRate',
        'start-date' => '2018-08-01',
        'end-date' => '2018-09-02',
        'dimensions' => 'ga:pageTitle',
    ]);

When I dd($analyticsData); This is what I got.

This is my migration query.

    Schema::create('analytics', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('site_id');
        $table->string('site_url');
        $table->integer('report_id');
        $table->integer('analytics_view_id'); 
        $table->date('reportGenerated');
        $table->integer('gaUsers');
        $table->integer('gaNewUsers');
        $table->integer('gaSessions');
        $table->integer('gaSessionsPerUser');
        $table->integer('gaPageviews');
        $table->integer('gaPageviewsPerSession');
        $table->integer('gaAvgSession');
        $table->integer('gaBounceRate');

    });

Now my problem is how can I able to stores those array data to my database? Thank you.

Marcin Nabiałek · Accepted Answer · 2018-09-25 16:11:37Z

1

It would be something like:

$model = Analytics::create([
   'gaUsers' => $analyticsData['ga:users'],
   'gaNewUsers' => $analyticsData['ga:newUsers'],
   // ... and so on...
]);

Just in case make sure you have those fields in $fillable attribute of your Analytics model.

edited Sep 25, 2018 at 16:11

answered Sep 25, 2018 at 15:27

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

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

1 Comment

Christian Gallarmin Over a year ago

Thanks now I will make my model as well.

Madhur Bhaiya · Accepted Answer · 2018-09-25 15:58:53Z

1

Try:

$analytic = new Analytics();

$analytic->gaUsers = $analyticsData['ga:users'];
$analytic->gaNewUsers = $analyticsData['ga:newUsers'];
...
$analytic->save();

edited Sep 25, 2018 at 15:58

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

answered Sep 25, 2018 at 15:31

Gihan Lakshan

4035 silver badges12 bronze badges

8 Comments

Marcin Nabiałek Over a year ago

Sorry, it won't work. $analyticsData is array, and object properties cannot have colon

Marcin Nabiałek Over a year ago

It would be fine now.

Christian Gallarmin Over a year ago

@MarcinNabiałek I had some data that needs to pull from other tables. and save it to my analytics table as well is it okay if I use this line of commands? Like for example I need to pull my site_url from sites table.

Christian Gallarmin Over a year ago

@GihanLakshan how do you think?

Gihan Lakshan Over a year ago

simply use $analytic->site_url = $url;

|

Collectives™ on Stack Overflow

Laravel insert data array to database

2 Answers 2

1 Comment

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related