How to set sub json array in one array PHP

Question

I am new in php, I was trying to fetch data that I get from the following response but I want to set this data in sub array. How to do this? I have two different tables category and Product. How to Show Multiple Products Category wise.

Thanks in Advance!

{
    "data" : [
        {
            "id" : "1",
            "recipe_name" : "Tofu Tikka",
            "ingredients" : "Firm tofu 1 pack (bite sized cube)\r\n",
            "prepration" : "Press tofu with the help of plate to remove moisture 
   and leave for 30-40 minutes, then cut in cubes.\r\n",
            "category_id":"1",
            "category_name":"Today's Menu"
        }
    ]
}

How to set above Response in sub Array like following way

{
    "data":[
        "category_id":"1",
        "category_name":"Today's Menu"
        "recipes::[
            {
                "id":"1",
                "recipe_name":"Tofu Tikka",
                "ingredients":"Firm tofu 1 pack ",
                "prepration":"Press tofu with the help of plate"
            }, {
                "id":"2",
                "recipe_name":"Tikka Paneer",
                "ingredients":"Firm tofu 1 pack ",
                "prepration":"Press tofu with the help of plate"
            },
        ]
    ]
}

Below is my PHP File

<?php
    // required headers
    header("Access-Control-Allow-Origin: *");
    header("Content-Type: application/json; charset=UTF-8");

    // include database and object files
    include_once '../config/database.php';
    include_once '../objects/product.php';

    // instantiate database and product object
    $database = new Database();
    $db = $database->getConnection();

    // initialize object
    $product = new Product($db);

    // query products
    $stmt = $product->read();
    $num = $stmt->rowCount();

    // check if more than 0 record found
    if ($num>0) {

        // products array
        $products_arr=array();
        $products_arr["data"]=array();

        // retrieve our table contents
        // fetch() is faster than fetchAll()
        // http://stackoverflow.com/questions/2770630/pdofetchall-vs-pdofetch-in-a-loop
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            // extract row
            // this will make $row['name'] to
            // just $name only
            extract($row);

            $product_item=array(
                "id" => $id,
                "recipe_name" => $recipe_name,
                "ingredients" => html_entity_decode($ingredients),
                "prepration" => $prepration,
                "category_id" => $category_id,
                "category_name" => $category_name
            );

            array_push($products_arr["data"], $product_item);
        }

        echo json_encode($products_arr);

    } else {
        echo json_encode(
        array("message" => "No products found.")
        );
    }
?>

score 2 · Answer 1 · answered Dec 27 '17 at 08:31

In your while loop, you can group the recipes first via category_id instead of pushing the whole row array. Then re-index using array_values().

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // extract row
    // this will make $row['name'] to
    // just $name only
    extract($row);

    // Check if category_id is already set
    if (!array_key_exists($category_id, $products_arr["data"])) {
        $products_arr["data"][$category_id] = array(
            "category_id" => $category_id,
            "category_name" => $category_name,
            "recipes" => []
            );
    }
    // Push the recipe details
    $products_arr["data"][$category_id]["recipes"][] = array(
        "id" => $id,
        "recipe_name" => $recipe_name,
        "ingredients" => html_entity_decode($ingredients),
        "prepration" => $prepration
    );

    $products_arr["data"] = array_values($products_arr["data"]);
}

echo json_encode($products_arr);

Note: The output is a little bit different from your expected result. Because the output's data key has arrays based on categories instead of having category_id. Preventing more than one category from overwriting if you use category_id as key inside data

Thanks! for your guidence :) – Chitra Nandpal Dec 27 '17 at 08:41 — Chitra Nandpal, Dec 27 '17 at 08:41
what shoud i do to don't repeat my categoty_id ?? – Chitra Nandpal Jan 10 '18 at 05:49 — Chitra Nandpal, Jan 10 '18 at 05:49

score 1 · Accepted Answer · answered Dec 27 '17 at 09:25

I will suggest you to use JOIN while getting records of category and its related products. It will need single query and single loop to generate array you want. Here is the sample query which you can use. It will get category name with each product record and do not show those categories who do not have products in it.

SELECT * FROM categories AS c LEFT JOIN offers AS p ON c.category_id=p.category_id WHERE p.offer_id IS NOT NULL

Note: - Do not use asterisk (*) in your search query, use table field names instead.

<?php

// initialize empty category array
$categoryArr = [];
// $row has product info with category id and name in it.
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){

    /* First key of categoryArr variable is category id. It will automatically create array key for each category.
    *   If an array key already exists, it will add prodcts in it.
    */
    $categoryArr[$row['category_id']]['category_id'] = $row['category_id'];
    $categoryArr[$row['category_id']]['category_name'] = $row['category_name'];
    $categoryArr[$row['category_id']]['products'][] = $row;
}
/* Once loop done with its work. Need to reset array keys with the help of below function. */
$result = array_values($categoryArr);

echo json_encode($result); ?>

I have not tested it, its just to give you an idea. I hope you will improve it.

it Works actually! Thanks a lot :) – Chitra Nandpal Jan 10 '18 at 06:40 — Chitra Nandpal, Jan 10 '18 at 06:40

score 0 · Answer 3 · answered Dec 27 '17 at 07:15

// I hope it's useful ..

$returnArr = array('category_id' => $category_id,'category_name' => $category_name,$products_arr["data"]); // in last "$products_arr["data"]" set your dynamic code ..

$arr = array('recipes' => $returnArr); 

echo json_encode($arr['recipes']); // print json ..

How to set sub json array in one array PHP

3 Answers3