PHP - Beginner Help With Php Json Array

Havent posted here in a while, been learning lots but im stuck on trying to unset/replace arrays that contain awkward key values.

[0] => 2021-06-02T19:40:00Z
    [1] => 2021-06-03T02:10:00Z
    [2] => 2021-06-03T01:10:00Z
    [3] => 2021-06-02T23:05:00Z
    [4] => 2021-06-02T23:05:00Z
    [5] => 2021-06-02T23:07:00Z
    [6] => 2021-06-02T23:20:00Z
    [7] => 2021-06-02T18:20:00Z
    [8] => 2021-06-03T00:10:00Z
    [9] => 2021-06-03T00:40:00Z

The json Im using is constantly updated, not sure why tmrw's dates June 3rd are at the top for their API design =[ Not good at regex. preg_replace/etc. Im desperate id use array search manually if I knew how to simple parse out tmrw's dates. I have unlimited API calls so I reckon  it don't matter, here's what Ive been playing with

$oddsdata = 'https://pinnacle.datafeeds.net/api/json/odds/pinnacle/v3/60/baseball/mlb/moneyline?api-key=a71b8fe8e9eb957db549aaa5d99797a4'; 

$readodds = file_get_contents($oddsdata);
$odds = json_decode($readodds, true);
$today = date("Y-m-d");
$tmrw = date('Y-m-d', strtotime( $today . " +1 days"));

foreach($odds['games'] as $key => $val):
$gidRE[$key]["gid"] = $val["gameUID"]; 
$startOdds[$key]["start"] = $val["startDate"]; 
$homeTeams[$key]["hteam"] = $val["homeTeam"]; 
$awayTeams[$key]["ateam"] = $val["awayTeam"]; 
$Price[$key]["betPrice"] = $val["betPrice"]; 
$BookOdds[$key]["book"] = $val["sportsbook"]; 
$BetName[$key]["betName"] = $val["betName"]; 
$Live[$key]["Live"] = $val["isLive"]; 
endforeach;


$endgidd = end(array_keys($gidRE)) + '1';
$endz = end(array_keys($odds['games']));
for ($l = 0; $l < $endz; ++$l) {
$OddsAll[] = array_merge($gidRE[$l], $startOdds[$l], $homeTeams[$l], $awayTeams[$l], $Price[$l], $BetName[$l]);
}

Hello everyone. I'm a self learner that is very new to programming. I'm trying to print out the value of ["mid"]  from a json_decode variable in the code shown below: 

I'm trying to use for each to access the value of "mid'. using foreach function. I know I'm not doing it the right way. please help me or show me an easy was to go around it.

/////the json resopnd form the url is  :

{"terms":"http://www.xe.com/legal/dfs.php","privacy":"http://www.xe.com/privacy.php","from":"USD","amount":1.195,"timestamp":"2021-02-09T16:52:00Z","to":[{"quotecurrency":"NGN","mid":454.6559871014}]}
/////////////////////////////////////////////////

<?php
$auth = base64_encode("username:password");
$context = stream_context_create([
    "http" => [
        "header" => "Authorization: Basic $auth"
    ]
]);
$homepage = file_get_contents("https://xecdapi.xe.com/v1/convert_from?to=NGN&amount=1.195", false, $context );
$json = json_decode($homepage, TRUE);
foreach ($json as $price){
    echo $price['mid'];
};

?>

<?php
ini_set('display_errors', 0);
function escapeArray($array)
{
        foreach ($array as $key => $val)
        {
			if(is_array($val)){
				$array[$key]=escapeArray($val);
			}
			else{
				$array[$key]=addslashes($val);
			}
        }

        return $array;
		
}





$request_type=$_SERVER['REQUEST_METHOD'];
$api_key=$_SERVER['HTTP_X_API_KEY'];
$res=array();
if($api_key!=="643256432"){
	$res['msg']="Failu Invalid API KEY";
	echo json_encode($res);
	die;
}
// Connects to the orcl service (i.e. database) on the "localhost" machine
//$conn = oci_connect('SCOTT', 'admin123', 'localhost/orcl');

$conn = oci_connect('test', 'test', '192.168.10.43/test.test.com');

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$request=file_get_contents("php://input");
$request=escapeArray(json_decode($request,true));

 print_r($request);
// die;
if($request_type=="POST"){//for creation of invoice


echo	$CONTACT_ID=isset($request['CONTACT_ID'])?$request['CONTACT_ID']:"";
	$INV_SERIAL_NO=isset($request['INV_SERIAL_NO'])?$request['INV_SERIAL_NO']:"";
	$NAME=isset($request['NAME'])?$request['NAME']:"";
	$INV_DATE=isset($request['INV_DATE'])?$request['INV_DATE']:"";
	$DUE_DATE=isset($request['DUE_DATE'])?$request['DUE_DATE']:"";
	$CURRENCY=isset($request['CURRENCY'])?$request['CURRENCY']:"";
	$SUBTOTAL=isset($request['SUBTOTAL'])?$request['SUBTOTAL']:"";
	$TAX_TOTAL=isset($request['TAX_TOTAL'])?$request['TAX_TOTAL']:"";

echo $SHIP_SERIAL_NO=isset($request['SHIP_SERIAL_NO'])?$request['SHIP_SERIAL_NO']:"";
	$MASTER_NO=isset($request['MASTER_NO'])?$request['MASTER_NO']:"";
	$HOUSE_NO=isset($request['HOUSE_NO'])?$request['HOUSE_NO']:"";
	$shipment_data=isset($request['shipment_data'])?$request['shipment_data']:"";

	if($CONTACT_ID==""){
		$res['msg']="CONTACT_ID is required";
	}
	else if($INV_SERIAL_NO==""){
		$res['msg']="INV_SERIAL_NO is required";
	}
	else if($NAME==""){
		$res['msg']="NAME is required";
	}
	else if($INV_DATE==""){
		$res['msg']="INV_DATE is required";
	}
	else if($DUE_DATE==""){
		$res['msg']="DUE_DATE is required";
	}
	else if($CURRENCY==""){
		$res['msg']="CURRENCY is required";
	}
	else if($SUBTOTAL==""){
		$res['msg']="SUBTOTAL is required";
	}
	else if($TAX_TOTAL==""){
		$res['msg']="TAX_TOTAL is required";
	}

	
	else if($MASTER_NO==""){
		$res['msg']="MASTER_NO is required";
	}
	else if($HOUSE_NO==""){
		$res['msg']="HOUSE_NO is required";
	}
	else if($SHIP_SERIAL_NO==""){
		$res['msg']="SHIP_SERIAL_NO is required";
	}



	

	else{
		$stid = oci_parse($conn, "Select * from FL_HDR_INVOICE where CONTACT_ID='$CONTACT_ID'");
		(oci_execute($stid));
		oci_fetch_all($stid, $out);
		
		

		if(count($out['CONTACT_ID'])==0){

			$stid = oci_parse($conn, "Insert into FL_HDR_INVOICE (CONTACT_ID,INV_SERIAL_NO,NAME,INV_DATE,DUE_DATE,CURRENCY,SUBTOTAL,TAX_TOTAL) Values ('$CONTACT_ID','$INV_SERIAL_NO','$NAME',TO_DATE('$INV_DATE','YYYY-MM-DD'),TO_DATE('$DUE_DATE','YYYY-MM-DD'),'$CURRENCY','$SUBTOTAL','$TAX_TOTAL')");
			oci_execute($stid);

			$stid_2 = oci_parse($conn, "Insert into FL_SHIPMENT_DATA (CONTACT_ID,INV_SERIAL_NO,SHIP_SERIAL_NO,MASTER_NO,HOUSE_NO) Values ('$CONTACT_ID','$INV_SERIAL_NO','$SHIP_SERIAL_NO','$MASTER_NO','$HOUSE_NO')");
			oci_execute($stid_2);



			if(oci_num_rows($stid)>0){
				$res['msg']="Invoice created successfully against this contact_id:".$CONTACT_ID;
			}
			else{
				$res['msg']="Something going wrong please try again later";
				
			}
		}
		else{
			$res['msg']="contact_id must be unique";
		}
	}
	echo json_encode($res);
	die;
}

I need to read json data inside an array. Please help correct my code.. i am trying to do an API.

Hello,

Having a bit of a tough time understanding what is going on in my brain! 

I'm basically pulling some data from an API using CuRL, which is working fine. The structure of the data is:

[data][tickets] - tickets being an array of support tickets in the system, which then contains ticketNumber, title, content. I want to display these values in a list, I have this code currently:

  if ($err) {
    echo "cURL Error #:" . $err;
  } else {
    $return = json_decode($response, true);
    foreach($return as $key) {
      echo $key["tickets"][1]['ticketNumber']." - ";
      echo $key["tickets"][1]['title']." - ";
      echo $key["tickets"][1]['content'];
    }
  }

Which obviously returns the ticketNumber, title & content of the first support ticket in the array, but I want to loop through and display that information for each ticket! 

Can anyone advise as to where I am going wrong? I think I need to utilise the ["tickets"][x] but not sure how!

Thanks in advance!

Steve

An affiliate marketer refers some products which are stored in a simple array.
My website creates a JSON variable of all products sold.

$all_items_sold = '{"7777":{"item":"hammer","price":"4.99"},"8888":{"item":"nail","price":"1.99"},"9999":{"item":"apple","price":"2.00"}}';
$referred_by_Affiliate = array('1234','8888','7777');

So, out of all the 3 items that sold, only 2 of them were referred by the affiliate marketer.
DESIRED EFFECT: insert this product 8888: $1.99 and insert this product 7777: $4.99 into mysql.

Currently I do this:
1.) foreach loop,
2.) use strpos to see if it's in the raw JSON variable.
3.) If there, I use preg_match to find the price.
4.) Do a mySQL insert while still in the foreach loop.

Is there a "best practices" way to accomplish this?
I'm guessing there is a "one liner" so I don't have to do a foreach loop and using strpos.
And I'm guessing there is a way to do multiple mySQL inserts all at once with just one line of code, instead of from inside a foreach loop.
This probably can all be accomplished with just one line of code total, error trapping included 😁

Thank you.
 

Array
(
    [0] => Array
        (
            [isoid] => 0
            [omschrijving] => - leeg -
        )

    [1] => Array
        (
            [isoid] => 64
            [omschrijving] => ArchLinux 2013.5
        )

    [2] => Array
        (
            [isoid] => 75
            [omschrijving] => AsteriskNOW 3.0.0 64b
        )

    [3] => Array
        (
            [isoid] => 67
            [omschrijving] => CentOS 5.9 32b
        )

    [4] => Array
        (
            [isoid] => 2
            [omschrijving] => CentOS 6.3 64b
        )

    [5] => Array
        (
            [isoid] => 96
            [omschrijving] => CentOS 7.0 64b
        )

    [6] => Array
        (
            [isoid] => 4
            [omschrijving] => Clear OS 5.2 64b
        )

    [7] => Array
        (
            [isoid] => 93
            [omschrijving] => CloudLinux 6.4
        )

    [8] => Array
        (
            [isoid] => 1
            [omschrijving] => Debian GNU/Linux 6.0 / Squeeze 64b
        )

    [9] => Array
        (
            [isoid] => 79
            [omschrijving] => Debian GNU/Linux 7.0 / Wheezy 32b
        )

    [10] => Array
        (
            [isoid] => 71
            [omschrijving] => Debian GNU/Linux 7.0 / Wheezy 64b
        )

    [11] => Array
        (
            [isoid] => 63
            [omschrijving] => Fedora 18 64b
        )

    [12] => Array
        (
            [isoid] => 82
            [omschrijving] => FreeBSD 10 64b
        )

    [13] => Array
        (
            [isoid] => 77
            [omschrijving] => FreeBSD 9.2 64b
        )

    [14] => Array
        (
            [isoid] => 10
            [omschrijving] => FreePBX 5.211.65-12
        )

    [15] => Array
        (
            [isoid] => 76
            [omschrijving] => GParted Live CD
        )

    [16] => Array
        (
            [isoid] => 3
            [omschrijving] => KVM Virtio drivers voor Windows
        )

    [17] => Array
        (
            [isoid] => 66
            [omschrijving] => MailCleaner 2012v6 64b
        )

    [18] => Array
        (
            [isoid] => 68
            [omschrijving] => Manjaro KDE 0.8.6 64b
        )

    [19] => Array
        (
            [isoid] => 78
            [omschrijving] => Microsoft Windows 7 Pro 64b
        )

    [20] => Array
        (
            [isoid] => 69
            [omschrijving] => Microsoft Windows Server 2003 EN
        )

    [21] => Array
        (
            [isoid] => 8
            [omschrijving] => Microsoft Windows Server 2008R2 EN
        )

    [22] => Array
        (
            [isoid] => 7
            [omschrijving] => Microsoft Windows Server 2008R2 NL
        )

    [23] => Array
        (
            [isoid] => 70
            [omschrijving] => Microsoft Windows Server 2012 NL 64b
        )

    [24] => Array
        (
            [isoid] => 84
            [omschrijving] => Microsoft Windows Server 2012R2 NL
        )

    [25] => Array
        (
            [isoid] => 83
            [omschrijving] => NOC PS 1.0r11
        )

    [26] => Array
        (
            [isoid] => 11
            [omschrijving] => OpenBSD 5.2
        )

    [27] => Array
        (
            [isoid] => 80
            [omschrijving] => OpenBSD 5.4
        )

    [28] => Array
        (
            [isoid] => 94
            [omschrijving] => OpenBSD 5.5 64b
        )

    [29] => Array
        (
            [isoid] => 72
            [omschrijving] => OpenSUSE 12.3 64b
        )

    [30] => Array
        (
            [isoid] => 95
            [omschrijving] => Slackware 13.37
        )

    [31] => Array
        (
            [isoid] => 12
            [omschrijving] => System Rescue CD
        )

    [32] => Array
        (
            [isoid] => 18
            [omschrijving] => Turnkey Appflower
        )

    [33] => Array
        (
            [isoid] => 19
            [omschrijving] => Turnkey ASP.net/Apache
        )

    [34] => Array
        (
            [isoid] => 20
            [omschrijving] => Turnkey Bugzilla
        )

    [35] => Array
        (
            [isoid] => 21
            [omschrijving] => Turnkey CodeIgniter
        )

    [36] => Array
        (
            [isoid] => 22
            [omschrijving] => Turnkey Django
        )

    [37] => Array
        (
            [isoid] => 23
            [omschrijving] => Turnkey Dokuwiki
        )

    [38] => Array
        (
            [isoid] => 24
            [omschrijving] => Turnkey DomainControler
        )

    [39] => Array
        (
            [isoid] => 25
            [omschrijving] => Turnkey Drupal7
        )

    [40] => Array
        (
            [isoid] => 26
            [omschrijving] => Turnkey Fileserver
        )

    [41] => Array
        (
            [isoid] => 27
            [omschrijving] => Turnkey Gallery
        )

    [42] => Array
        (
            [isoid] => 28
            [omschrijving] => Turnkey Gitlab
        )

    [43] => Array
        (
            [isoid] => 15
            [omschrijving] => Turnkey Google AppEngine Go
        )

    [44] => Array
        (
            [isoid] => 16
            [omschrijving] => Turnkey Google AppEngine Java
        )

    [45] => Array
        (
            [isoid] => 17
            [omschrijving] => Turnkey Google AppEngine Python
        )

    [46] => Array
        (
            [isoid] => 29
            [omschrijving] => Turnkey IceScrum
        )

    [47] => Array
        (
            [isoid] => 30
            [omschrijving] => Turnkey Joomla2.5
        )

    [48] => Array
        (
            [isoid] => 31
            [omschrijving] => Turnkey LAMP
        )

    [49] => Array
        (
            [isoid] => 32
            [omschrijving] => Turnkey Lighttpd/PHP/FastCGI
        )

    [50] => Array
        (
            [isoid] => 33
            [omschrijving] => Turnkey Magento
        )

    [51] => Array
        (
            [isoid] => 34
            [omschrijving] => Turnkey Mediawiki
        )

    [52] => Array
        (
            [isoid] => 35
            [omschrijving] => Turnkey MongoDB
        )

    [53] => Array
        (
            [isoid] => 36
            [omschrijving] => Turnkey MySQL
        )

    [54] => Array
        (
            [isoid] => 37
            [omschrijving] => Turnkey NGINX/PHP/FastCGI
        )

    [55] => Array
        (
            [isoid] => 38
            [omschrijving] => Turnkey OpenLDAP
        )

    [56] => Array
        (
            [isoid] => 39
            [omschrijving] => Turnkey OpenPhoto
        )

    [57] => Array
        (
            [isoid] => 40
            [omschrijving] => Turnkey OSCommerce
        )

    [58] => Array
        (
            [isoid] => 41
            [omschrijving] => Turnkey OTRS
        )

    [59] => Array
        (
            [isoid] => 42
            [omschrijving] => Turnkey Owncloud
        )

    [60] => Array
        (
            [isoid] => 43
            [omschrijving] => Turnkey PHPBB
        )

    [61] => Array
        (
            [isoid] => 44
            [omschrijving] => Turnkey PHPList
        )

    [62] => Array
        (
            [isoid] => 45
            [omschrijving] => Turnkey PHPNuke
        )

    [63] => Array
        (
            [isoid] => 46
            [omschrijving] => Turnkey Postgresql
        )

    [64] => Array
        (
            [isoid] => 47
            [omschrijving] => Turnkey Prestashop
        )

    [65] => Array
        (
            [isoid] => 48
            [omschrijving] => Turnkey Rails
        )

    [66] => Array
        (
            [isoid] => 49
            [omschrijving] => Turnkey Redmine
        )

    [67] => Array
        (
            [isoid] => 50
            [omschrijving] => Turnkey SiTracker
        )

    [68] => Array
        (
            [isoid] => 51
            [omschrijving] => Turnkey StatusNET
        )

    [69] => Array
        (
            [isoid] => 52
            [omschrijving] => Turnkey SugarCRM
        )

    [70] => Array
        (
            [isoid] => 53
            [omschrijving] => Turnkey Symfony
        )

    [71] => Array
        (
            [isoid] => 54
            [omschrijving] => Turnkey Tomcat
        )

    [72] => Array
        (
            [isoid] => 55
            [omschrijving] => Turnkey Tomcat/Apache
        )

    [73] => Array
        (
            [isoid] => 56
            [omschrijving] => Turnkey TRAC
        )

    [74] => Array
        (
            [isoid] => 57
            [omschrijving] => Turnkey TWiki
        )

    [75] => Array
        (
            [isoid] => 58
            [omschrijving] => Turnkey Typo3
        )

    [76] => Array
        (
            [isoid] => 59
            [omschrijving] => Turnkey Wordpress
        )

    [77] => Array
        (
            [isoid] => 60
            [omschrijving] => Turnkey Zencart
        )

    [78] => Array
        (
            [isoid] => 13
            [omschrijving] => Ubuntu 10.04 32b
        )

    [79] => Array
        (
            [isoid] => 6
            [omschrijving] => Ubuntu 10.04 64b
        )

    [80] => Array
        (
            [isoid] => 14
            [omschrijving] => Ubuntu 12.04 32b
        )

    [81] => Array
        (
            [isoid] => 61
            [omschrijving] => Ubuntu 12.04 64b
        )

    [82] => Array
        (
            [isoid] => 62
            [omschrijving] => Ubuntu 12.10 64b	
        )

    [83] => Array
        (
            [isoid] => 89
            [omschrijving] => Ubuntu 14.04 LTS 64b
        )

    [84] => Array
        (
            [isoid] => 5
            [omschrijving] => Windows Password Reset
        )

    [85] => Array
        (
            [isoid] => 81
            [omschrijving] => Zen Loadbalancer 3.03
        )

    [86] => Array
        (
            [isoid] => 74
            [omschrijving] => Zentyal 3.2
        )

)

<option value='74'>Zentyal 3.2</option>

I have this array of items in my php file.

$items = array(
    array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
    array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
    array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
    array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
    array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
    array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
    array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
    array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
    array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
    array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
    array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"), 
);

Using the above array I am trying to generate a JSON file that will have the following structu

{
  "category":[
    {
      "categoryName":"level1",
      "category":[
        {
          "categoryName":"powders",
          "products":[
            {
              "id":"100",
              "path":"level1/powders",
              "prodname":"Mens powder"
            },
            {
              "id":"1000",
              "path":"level1/powders",
              "prodname":"Womens powder"
            }
          ]
        },
        {
          "categoryName":"oils",
          "category":[
            {
              "categoryName":"sunflower",
              "products":[
                  {
                    "id":"200",
                    "path":"level1/oils/sunflower",
                    "prodname":"XYZ oil"
                  },
                  {
                    "id":"400",
                    "path":"level1/oils/sunflower",
                    "prodname":"ABC oil"
                  }

              ]
            },
            {
              "categoryName":"groundnut",
              "products":[
                  {
                    "id":"1100",
                    "path":"level1/oils/groundnut",
                    "prodname":"GN oil"
                  }
              ]
            }
          ]
        },
        {
          "categoryName":"eatable",
          "category":[
            {
              "categoryName":"vegetables",
              "products":[
                {
                  "id":"300",
                  "path":"level1/eatable/vegetables",
                  "prodname":"carrot"
                },
                {
                  "id":"600",
                  "path":"level1/eatable/vegetables",
                  "prodname":"spinach"
                }
              ]
           },
           {
              "categoryName":"fruits",
              "products":[
                {
                  "id":"500",
                  "path":"level1/eatable/fruits",
                  "prodname":"mango"
                }
                  
              ]
            }
            
          ]
        }
        
    },
    {
      "categoryName":"level2",
      "category":[
        {
          "categoryName":"baby items",
          "category":[
            {
              "categoryName":"toys",
              "products":[
                {
                  "id":"700",
                  "path":"level2/baby items/toys",
                  "prodname":"puzzle blocks"
                },
                {
                  "id":"800",
                  "path":"level2/baby items/toys",
                  "prodname":"trucks and cars"
                }
              ]
            },
            {
              "categoryName":"clothes",
              "products":[
                {
                  "id":"900",
                  "path":"level2/baby items/clothes",
                  "prodname":"shirts"
                }
              ]
            }
          ]
        }

      ]
    }

Not being an expert in php, I have somehow managed to reach thus far in my code, but can not quite arrive at the correct logic. Having trouble with handling associative arrays and objects in php. (Javascripting is much easier I feel) So far I have managed to fix all the errors/warning in my code.

Here is my full php code:

$items = array(
    array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
    array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
    array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
    array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
    array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
    array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
    array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
    array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
    array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
    array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
    array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"), 
);

$jsonStruct = array();

function jsonCreateStruct(){
    GLOBAL $items;
    for($c=0; $c<count($items); $c++){
        $categ = $items[$c]["categorypath"];
        insertJson($categ, $items[$c]);
        
    }
}

function insertJson($catg, $itm){
    GLOBAL $jsonStruct;
    $exp = explode("/",$catg);
    print_r("\n\n\n $catg \n");
    if(count($exp) == 1){
        print_r("Level 1 \n");
        if(!isset($jsonStruct[0])){
            $jsonStruct[0]["categoryName"] = $exp[0];
            $jsonStruct[0]["products"] = array($itm);
            print_r("\nCreated:: $exp[0]");
        }else{
           $notFound = true;
           for($j=0; $j<count($jsonStruct); $j++){
                $catgName = $jsonStruct[$j]["categoryName"];
                print_r("\nFound: $catgName");
                if($catgName == $exp[0]){
                    $notFound = false;
                    if($jsonStruct[$j]["products"]){
                        array_push($jsonStruct[$j]["products"],array($itm));
                    }else{
                        $jsonStruct[$j]["products"] = array();
                        array_push($jsonStruct[$j]["products"],array($itm));
                    }
                }
            }
            if($notFound){
                print_r("\nNotFound\n");
                array_push($jsonStruct,array("categoryName"=> $exp[0], "products" => array($itm)));
            }
            
        }
        
    }
    if(count($exp) == 2){
        print_r("Level 2 \n");
        if(!isset($jsonStruct[0])){
            $jsonStruct[0]["categoryName"] = $exp[0];
            $jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "products" => array($itm));
            print_r("\nCreated:: $exp[0] / $exp[1]");
        }else{
            $notFound1 = true;
            $notFound2 = true;
            $indexLevel = null;
           for($j=0; $j<count($jsonStruct); $j++){
               $catgName1 = $jsonStruct[$j]["categoryName"];
                print_r("\nFound: $catgName1");
                if($catgName1 == $exp[0]){
                   $notFound1 = false;
                   $indexLevel = $j;
                   if(isset($jsonStruct[$j]["categorypath"])){
                       $level1 = $jsonStruct[$j]["categorypath"];
                       for($m=0; $m<count($level1); $m++){
                           if(isset($level1[$m]["categoryName"])){
                              $catgName2 = $level1[$m]["categoryName"];
                               print_r("\nFound: $catgName2");
                               if($catgName2 == $exp[1]){
                                   $notFound2 = false;
                                   if($level1[$m]["products"]){
                                       array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
                                   }else{
                                       $jsonStruct[$j]["categorypath"][$m]["products"] = array();
                                       array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
                                   }
                                   
                               } 
                           }
                       }
                   } 
                }
           }
           if($notFound1){
               print_r("\nNotFound1\n");
               array_push($jsonStruct,array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
           }else if($notFound2){
               print_r("\nNotFound2\n");
              // $jsonStruct[$indexLevel]["categorypath"] = array("categoryName"=> $exp[1], "products" => array($itm));
               $jsonStruct[$indexLevel]["categorypath"] = array();
               array_push($jsonStruct[$indexLevel]["categorypath"], array("categoryName"=> $exp[1], "products" => array($itm)));
           }
        } 
    }
    if(count($exp) == 3){
        print_r("Level 3 \n");
        if(!isset($jsonStruct[0])){
            $jsonStruct[0]["categoryName"] = $exp[0];
            $jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm)));
            print_r("\nCreated:: $exp[0] / $exp[1] / $exp[2]");
        }else{
            $notFound1 = true;
            $notFound2 = true;
            $notFound3 = true;
            $indexLevel1 = null;
            $indexLevel2 = null;
           for($j=0; $j<count($jsonStruct); $j++){
               $catgName1 = $jsonStruct[$j]["categoryName"];
                print_r("\nFound: $catgName1");
                if($catgName1 == $exp[0]){
                   $notFound1 = false;
                   $indexLevel1 = $j;
                   if(isset($jsonStruct[$j]["categorypath"])){
                       $level2 = $jsonStruct[$j]["categorypath"];
                       for($m=0; $m<count($level2); $m++){
                           if(isset($level2[$m]["categoryName"])){
                              $catgName2 = $level2[$m]["categoryName"];
                               print_r("\nFound: $catgName2");
                               if($catgName2 == $exp[1]){
                                   $notFound2 = false;
                                   $indexLevel2 = $m;
                                   if(isset($level2[$m]["categorypath"])){
                                      $level3 = $level2[$m]["categorypath"];
                                      for($n=0; $n<count($level3); $n++){
                                          //print_r($level3["categoryName"]);
                                          if(isset($level3["categoryName"])){
                                             $catgName3 = $level3["categoryName"];
                                             print_r("\ncatgName3: ". $catgName3);
                                              if($catgName3 == $exp[2]){
                                                  $notFound3 = false;
                                                  if($level3["products"]){
                                                      print_r("\npushing into array\n");
                                                      array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
                                                  }else{
                                                      print_r("\ncreate new and pushing into array\n");
                                                      $jsonStruct[$j]["categorypath"][$m]["categorypath"][$n]["products"] = array();
                                                      array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
                                                  }
                                                  
                                              } 
                                          }
                                          
                                      }
                                   }
                               } 
                           }
                           
                       }
                   } 
                }
           }
           if($notFound1){
               print_r("\nNotFound1\n");
               array_push($jsonStruct, array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
           }else if($notFound2){
               print_r("\nNotFound2\n");
               if(!$jsonStruct[$indexLevel1]["categorypath"]){
                   $jsonStruct[$indexLevel1]["categorypath"] = array();
               }
               array_push($jsonStruct[$indexLevel1]["categorypath"], array("categoryName"=> $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm))));
           }else if($notFound3){
               print_r("\nNotFound3\n");
               //$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array("categoryName"=> $exp[2], "products" => array($itm));
              if(!$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"]){
                  $jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array();
              }
               array_push($jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"], array("categoryName"=> $exp[2], "products" => array($itm)));
           }
        } 
    }
}


jsonCreateStruct();
print_r("----------------------------------------");
print_r($jsonStruct); 
// echo json_encode($jsonStruct);

I have now reached a point where I desperately need help from experts.