Check for JSON value with PHP

Question

I have a variable that returns a certain number that is correct.

Example:

$cc = "52532005536430673";

My question is: how do I verify that this number is present in a JSON? As below:

{
    "testadas": {
        "52532005536430673|04|2023|869": {
            "cc": "52532005536430673",
            "dados": "\ud83c\udde7\ud83c\uddf7",
            "status": "Reprovada",
            "data_hora": "02-09-2018 20:45:13",
            "retestada": false
        }
    }
}

In this case it is present in the "CC" and always want to check if the number is present in the "CC".

Answer 1

Basically, you can convert this json to an object or array, and then go through all the items that are in the "tested" by making a check if the cc field is not empty.

In the example below, I converted json to array, using json_decode, and passed as first parameter the json and second value 1, which signals that I want to convert to array and not object.

$json = '{
"testadas": {
    "52532005536430673|04|2023|869": {
        "cc": "52532005536430673",
        "dados": "\ud83c\udde7\ud83c\uddf7",
        "status": "Reprovada",
        "data_hora": "02-09-2018 20:45:13",
        "retestada": false
    }
  }
}';

$resultado_json = json_decode($json,1);
$cartao = "52532005536430673";
foreach($resultado_json["testadas"] as $item){
  if($item["cc"] == $cartao){
    print "Numero presente no campo cc";
  }
}

Answer 2

Here is the code working, it takes the cc of the JSON and then compares it to the value of the variable. To get from an external file, it is necessary to use file_get_contents() to get the JSON link:

PHP file:

<?php
$cc = "52532005536430673";
$file = "ccs.json";

$json_file = file_get_contents($file);
$json_result = json_decode($json_file);

foreach($json_result->testadas as $item){
    if($item->cc == $cc){
        print "Esse número está presente em cc";
    }
    else{
        print "Esse número não está presente em cc";
    }
}
?>

ccs.json

{
    "testadas": {
        "52532005536430673|04|2023|869": {
            "cc": "52532005536430673",
            "dados": "\ud83c\udde7\ud83c\uddf7",
            "status": "Reprovada",
            "data_hora": "02-09-2018 20:45:13",
            "retestada": false
        }
    }
}