How to convert array to string in laravel

Question

$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();

This return something like array format

[{"DATE":"2021-06-11 00:00:00","point_no":"SRT-358"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-359"},{"DATE":"2021-06-11 00:00:00","point_no":"SRT-360"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-357"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-356"},{"DATE":"2021-06-10 00:00:00","point_no":"SRT-355"},{"DATE":"2021-06-09 00:00:00","point_no":"SRT-348"}]

I want to isolate DATE and point_no. For example

$year=['2015','2016','2017','2018','2019','2020'];

I tried $date['DOCDATE'] to isolate date it's not working. Is there any better way to fix this??

I don't understand how the title goes with your question? Do you actually want a string or do you want another array with modified values? — Brian Thompson
– Brian Thompson, Commented Jun 17, 2021 at 13:54

jagcweb · Accepted Answer · 2021-06-17 13:58:27Z

2

$date = gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get();

$date_array = array();

foreach($date as $dat){
  array_push($date_array, \Carbon\Carbon::parse($dat["DATE"])->format('Y');
}

return $date_array;

answered Jun 17, 2021 at 13:58

jagcweb

3501 silver badge13 bronze badges

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

Comments

Denis Turgenev · Accepted Answer · 2021-06-17 13:49:45Z

1

You can use array_map function.

$extractYear = function($date) {
    return substr($date["DATE"], 0, 4);
};

$years = array_map($extractYear, $date);

answered Jun 17, 2021 at 13:49

Denis Turgenev

1381 silver badge10 bronze badges

Comments

Ramanath · Accepted Answer · 2021-06-17 14:17:38Z

1

try this query -

$years= gc_head::select('DATE','point_no')->orderBy('DOCDATE','desc')->limit(7)->get()->map(function ($q) {
    return [Carbon::parse($q->DATE)->format('Y')];
});

edited Jun 17, 2021 at 14:17

answered Jun 17, 2021 at 13:46

Ramanath

5302 silver badges13 bronze badges

3 Comments

Gopalkrish Over a year ago

Carbon showing error undefined type how to import this

Ramanath Over a year ago

use Carbon\Carbon; -- add this to the top of the controller.

Gopalkrish Over a year ago

its worked But i want showing my table date instead of current date

Collectives™ on Stack Overflow

How to convert array to string in laravel

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related