How to convert date to timestamp in PHP inside array?

Question

I have an array just like this:

Array
(
   [0] => Array
       (
           [NO] => 1
           [NO_RINCIAN] => 70
           [TANGGAL_PENARIKAN] => 23-DEC-18
       )
   [1] => Array
       (
           [NO] => 2
           [NO_RINCIAN] => 90
           [TANGGAL_PENARIKAN] => 23-Nov-18
       )
 )

What I want to do is to convert TANGGAL_PENARIKAN from date to timestamp but in a whole array.

My expected array:

Array
(
  [0] => Array
      (
         [NO] => 1
         [NO_RINCIAN] => 70
         [TANGGAL_PENARIKAN] => 1545551313
      )
  [1] => Array
      (
         [NO] => 2
         [NO_RINCIAN] => 90
         [TANGGAL_PENARIKAN] => 1542959313
      )
 )

I've tried converting TANGGAL_PENARIKAN inside the array, but I didn't know how to combine to be an array again after it.

public function getAllData()
{

    $data = $this->model_app->getRincian();
    foreach ($data as $key => $value) {
        for ($i=0; $i <= count($value); $i++) { 
            $key = $value['TANGGAL_PENARIKAN'];
        }
        $key = DateTime::createFromFormat("j-M-y", $key);
        print_r(json_encode($key->getTimestamp()));
    }
}

print_r(json_encode($key->getTimestamp()));

Last code above still return :

15455513131542959313

Any well thought to advise will be appreciated.

Thanks.

Qirel · Accepted Answer · 2019-08-29 08:08:13Z

1

Loop your array by reference, and modify the column in your loop.

public function getAllData()
{
    $data = $this->model_app->getRincian();
    foreach ($data as $key => &$value) {
        $timestamp = DateTime::createFromFormat("j-M-y", $value['TANGGAL_PENARIKAN'])->getTimestamp();
        $value['TANGGAL_PENARIKAN'] = $timestamp;
    }
    return $data;
}

answered Aug 29, 2019 at 8:08

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

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

Comments

BlackXero · Accepted Answer · 2019-08-29 08:02:11Z

1

It will convert the date into unix timestamp I have used pre defined function strtotime(String $date)

public function getAllData()
{
    $data = $this->model_app->getRincian();
    foreach ($data as $key => $value) {
        for ($i=0; $i <= count($value); $i++) { 
            $key = strtotime($value['TANGGAL_PENARIKAN']);
        }
        $key = DateTime::createFromFormat("j-M-y", $key);
        print_r(json_encode($key->getTimestamp()));
    }
}

answered Aug 29, 2019 at 8:02

BlackXero

8904 silver badges18 bronze badges

Comments

failedCoder · Accepted Answer · 2019-08-29 08:08:28Z

1

You can try this, just add & symbol before the value in foreach to modify the original array

$array = [
   [
    'no' => 1,
    'NO_RINCIAN' => 70,
    'TANGGAL_PENARIKAN' => '23-DEC-18',
   ],
   [
    'no' => 2,
    'NO_RINCIAN' => 90,
    'TANGGAL_PENARIKAN' => '23-Nov-18',
   ],
];

// notice the & symbol before $value
foreach ($array as $key => &$value) {
   $date = DateTime::createFromFormat("j-M-y", $value['TANGGAL_PENARIKAN']);
   $value['TANGGAL_PENARIKAN'] = $date->getTimestamp();
}

var_dump($array);

You can learn more about passing value by reference here .

answered Aug 29, 2019 at 8:08

failedCoder

1,4241 gold badge18 silver badges40 bronze badges

Comments

splash58 · Accepted Answer · 2019-08-29 08:25:56Z

1

Format of your dates can be used for strtotime function, something as

$result = array_map(function($x) { 
        $x['TANGGAL_PENARIKAN'] = strtotime($x['TANGGAL_PENARIKAN']); return $x;},
     $arr);

answered Aug 29, 2019 at 8:25

splash58

26.2k3 gold badges25 silver badges35 bronze badges

Comments

Nagaraj Juro · Accepted Answer · 2019-08-29 09:09:16Z

0

Use the following code. It will return perfect timestamp value. It simple and easy..

I think it will help you..

<?php
$array = [
   [
    'no' => 1,
    'NO_RINCIAN' => 70,
    'TANGGAL_PENARIKAN' => '23-DEC-18',
   ],
   [
    'no' => 2,
    'NO_RINCIAN' => 90,
    'TANGGAL_PENARIKAN' => '23-JUL-18',
   ],
];
foreach ($array as $key => &$value) {
   $date_timestamp = strtotime($value['TANGGAL_PENARIKAN']);
   $value['TANGGAL_PENARIKAN'] = $date_timestamp;
}
echo "<pre>";
print_r($array);
?>

answered Aug 29, 2019 at 9:09

Nagaraj Juro

10911 bronze badges

Collectives™ on Stack Overflow

How to convert date to timestamp in PHP inside array?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related