php 配列の文字列から数字を取り出して利用したい

$dataに下記が入っています。

array ( 0 => '[{"Key":"14","Value":"0.00"},{"Key":"106","Value":"2.50"},{"Key":"116","Value":"0.00"},{"Key":"118","Value":"0.00"},{"Key":"205","Value":"0.00"},{"Key":"302","Value":"8.00"},{"Key":"401","Value":"5.00"},{"Key":"404","Value":"0.00"},{"Key":"502","Value":"0.00"},{"Key":"551","Value":"1.64"},{"Key":"552","Value":"2.00"},{"Key":"553","Value":"2.00"}]', 1 => '[{"Key":11,"Value":0.8},{"Key":102,"Value":0.63},{"Key":106,"Value":2.5},{"Key":118,"Value":0},{"Key":201,"Value":0.62},{"Key":202,"Value":0},{"Key":204,"Value":0},{"Key":208,"Value":0},{"Key":301,"Value":0.6},{"Key":302,"Value":8},{"Key":401,"Value":5},{"Key":404,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', 2 => '[{"Key":14,"Value":0},{"Key":106,"Value":2.5},{"Key":118,"Value":0},{"Key":201,"Value":0},{"Key":205,"Value":0},{"Key":208,"Value":0},{"Key":302,"Value":8},{"Key":401,"Value":5},{"Key":404,"Value":0},{"Key":501,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', 3 => '[{"Key":14,"Value":0},{"Key":102,"Value":0},{"Key":106,"Value":2.5},{"Key":116,"Value":0},{"Key":118,"Value":0},{"Key":201,"Value":0},{"Key":202,"Value":0},{"Key":304,"Value":0},{"Key":404,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', )

やりたいこと
初めのKeyの14は$key1[]に入れてValueの0.00は$Value1[]に入れる。次のKeyの106は$key2[]に入れてValueの2.50は$Value2[]に入れる
といった形で別の変数に入れていき次の配列　1 =>　にいったらKeyの11は$key1[]に入れてValueの0.8は$Value1[]に入れる。
を繰り返し行いたい。

やってること
まずは数字だけとりだそうと

foreach($data as $val){
                    $a = preg_replace('/[^0-9]/', '', $val);
                }

で数字はとれているのですが連なっている為カンマ区切りでとれたりできますでしょうか？
またそもそももっと簡単なやり方があればご教授頂ければ幸いです。

yambejp

2022/11/10 01:30 編集

「1 =>　にいったらKeyの11は$key1に入れて」 $key1が上書きされるだけですが大丈夫なのですか？そもそも配列で処理しているのをユニークな変数に受け直す意味がよくわかりません

ykkk

2022/11/10 01:39

失礼致しました。$key1[]で配列にしようとしています。そしてそれを別のところで利用します。

行動規範の内容に同意します

回答1件

ベストアンサー

PHP
1<?PHP
2$a=array ( 0 => '[{"Key":"14","Value":"0.00"},{"Key":"106","Value":"2.50"},{"Key":"116","Value":"0.00"},{"Key":"118","Value":"0.00"},{"Key":"205","Value":"0.00"},{"Key":"302","Value":"8.00"},{"Key":"401","Value":"5.00"},{"Key":"404","Value":"0.00"},{"Key":"502","Value":"0.00"},{"Key":"551","Value":"1.64"},{"Key":"552","Value":"2.00"},{"Key":"553","Value":"2.00"}]', 1 => '[{"Key":11,"Value":0.8},{"Key":102,"Value":0.63},{"Key":106,"Value":2.5},{"Key":118,"Value":0},{"Key":201,"Value":0.62},{"Key":202,"Value":0},{"Key":204,"Value":0},{"Key":208,"Value":0},{"Key":301,"Value":0.6},{"Key":302,"Value":8},{"Key":401,"Value":5},{"Key":404,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', 2 => '[{"Key":14,"Value":0},{"Key":106,"Value":2.5},{"Key":118,"Value":0},{"Key":201,"Value":0},{"Key":205,"Value":0},{"Key":208,"Value":0},{"Key":302,"Value":8},{"Key":401,"Value":5},{"Key":404,"Value":0},{"Key":501,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', 3 => '[{"Key":14,"Value":0},{"Key":102,"Value":0},{"Key":106,"Value":2.5},{"Key":116,"Value":0},{"Key":118,"Value":0},{"Key":201,"Value":0},{"Key":202,"Value":0},{"Key":304,"Value":0},{"Key":404,"Value":0},{"Key":502,"Value":0},{"Key":551,"Value":1.64},{"Key":552,"Value":2},{"Key":553,"Value":2}]', );
3foreach($a as $b){
4foreach(json_decode($b,JSON_OBJECT_AS_ARRAY) as $key=>$c){
5  ${"key".($key+1)}[]=$c["Key"];
6  ${"value".($key+1)}[]=$c["Value"];
7}
8}
9print_r($key1);
10print_r($value1);

投稿2022/11/10 01:53

yambejp

総合スコア114777

ykkk

2022/11/10 02:28

ご教授ありがとうございます。実行させて頂いたところ。 $key1の結果がarray(4002)になってしまいます。想定は array(4) { [0]=> string(1) "14" [1]=> string(1) "11" [2]=> string(1) "14" [3]=> string(1) "14" } になります。