Multiply the number between two characters in PHP string

Question

Please look into EDIT at the end.

I am parsing invalid json data from an external URL and I want modify the values of a specific keys. I want to multiply the values with a constant number for the values of a specific key (cent).

If you look closely, the pattern repeats, it starts with "vk".

How can I multiply the values of "cent" with a constant number (0.887).

The sample data that I'm parsing from external URL looks like as shown below:

The code I tried:

$json = get_content('tld.xyz/json.php?bank=prices'); 
$data = json_decode($json, true); 
foreach ($decoded_json['cent'] as &$value) 
{ if ($value >= 0){ $value = $value * 0.887; $result[]=$value; } } 
$fin = json_encode($data); 
echo $fin;

EDIT: I think it's not json and it can be solved by using regex. I am thinking to find the string between : and , and how to multiply this number with my constant.

Any help is appreciated. I am not a web developer but I have a small project and I'm trying to solve this issue on my own rather than hiring someone.

Thank you.

bestprogrammerintheworld · Accepted Answer

$value) {
    $level_arr = $na[$top_key][$top_key];    
    foreach($level_arr as $key=>$item) {
        if ($na[$top_key][$top_key][$key]['cent']>0) {
            $na[$top_key][$top_key][$key]['cent'] = $data[$top_key][$top_key][$key]['cent'] * 0.087;
        }
    }
}

//JSON
echo json_encode($na);

UPDATE1:

You could remove if ($na[$top_key][$top_key][$key]['cent']>0) { - part.

//Change the copy of array $data with cents
foreach($data as $top_key=>$value) {
    $level_arr = $na[$top_key][$top_key];    
    foreach($level_arr as $key=>$item) {
            $na[$top_key][$top_key][$key]['cent'] = $data[$top_key][$top_key][$key]['cent'] * 0.087; 
    }
}

//JSON
echo json_encode($na);

UPDATE2:

Above require that the levels of the array are:

[0][0][{whatever key}]['cent]
[1][1][{whatever key}]['cent]
[2][2][{whatever key}]['cent]

If you want more flexibility for not being depent that top level key and the second level key are the same ( [0][0], [1][1] etc... )

You could do this: (replace the code given above)

//Change the copy of array $data with cents
foreach($data as $top_key=>$second_level) {
    foreach($second_level as $key2=>$value) {
        $level_arr = $na[$top_key][$key2];    
        foreach($level_arr as $key=>$item) {
                $na[$top_key][$key2][$key]['cent'] = (float)$data[$top_key][$key2][$key]['cent'] * 0.087;
        }
    }
}

UPDATE3:

I missed to change $top_key to $key2 in update2 (Now I corrected that to), but here is almost the same code but with result as two decimals based on the actual data (given from the external API) with cost as key instead of cent. I've also changed the actual contant to 0.877 instead of 0.087.

foreach($data as $top_key=>$second_level) {
    foreach($second_level as $key2=>$level_arr) { 
        foreach($level_arr as $key=>$item) {
            $na[$top_key][$key2][$key]['cost'] = 
            number_format(
            (float)$data[$top_key][$key2][$key]['cost'] * 0.877,2
            );
        }
    }
}

Multiply the number between two characters in PHP string

Answers (1)

Related Questions