PHP json not showing all related values

Question

Hello I have this php code for printing json

<?php

include('databaseconnect.php');

$sql = "SELECT product_id,product_name FROM products WHERE product_id='1'";
$result = $conn->query($sql);

$sql2 = "SELECT GROUP_CONCAT(ss.Name,':',sv.value_s ) as Specifications FROM specifications ss, specification_value sv WHERE sv.specification_ID = ss.specification_ID AND sv.product_id =  '1'";
$fetch = $conn->query($sql2);

$sql3 = "select GROUP_CONCAT(v.name,':',vv.value) as variants from variant v,variant_value vv where v.variant_id=vv.variant_id and product_id='1'";
$fetch1 = $conn->query($sql3);


$json['products'] = array();

while ($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){

    $json['products'] = $row;

  }

$json['products']['specification'] = array();

while ($row = mysqli_fetch_assoc($fetch)){

    $specification_array  = explode(',', $row["Specifications"]);
    $speci_array = array();
    foreach($specification_array as $spec){
        $spec = explode(':',$spec);
        $speci_array[$spec[0]] = $spec[1];
    }
    $json['products']['specification'] = $speci_array;

    //array_push($json['products'],$row_temp);
   }

$json['products']['specification']['variants'] = array();

while ($row = mysqli_fetch_assoc($fetch1)){

    $variants_array  = explode(',', $row["variants"]);
    $vari_array = array();
    foreach($variants_array as $var){
        $var = explode(':',$var);
        $vari_array[$var[0]] = $var[1];
    }
    $json['products']['specification']['variants'] = $vari_array;

    //array_push($json['products'],$row_temp);
   }


echo Json_encode($json);

?>

and output of this is

{
    "products": {
        "product_id": "1",
        "product_name": "Face Wash",
        "specification": {
            "brand": "Python",
            "product_Description": "very good",
            "variants": {
                "size": "long"
            }
        }
    }
}

but in this i have one more value for variant i.e. "size":"small" and that is not showing up. sorry for bad English please ask me for any clarification before answering

my desired output

{
    "products": {
        "product_id": "1",
        "product_name": "Face Wash",
        "specification": {
            "brand": "Python",
            "product_Description": "very good",
            "variants": {
                "size": "small"
                "size": "long"
            }
        }
    }
}

You can do '$vari_array[$var[0]][] = $var[1];' now the size is multidimensional array. — Domain
– Domain, Commented Jul 22, 2015 at 6:50

syed suleman · Accepted Answer · 2015-07-22 06:47:41Z

2

You can't add same key size twice. The previous key gets overwritten by later.

edited Jul 22, 2015 at 6:47

answered Jul 22, 2015 at 6:41

syed suleman

5422 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vidya Sagar · Accepted Answer · 2015-07-22 06:50:29Z

1

Since you are repeating the key size again the values are being overwritten. Pass all the required values which are belonging to the same Key in an array.

answered Jul 22, 2015 at 6:50

Vidya Sagar

1,7173 gold badges17 silver badges30 bronze badges

Comments

Himanshu Upadhyay · Accepted Answer · 2015-07-22 07:02:06Z

0

yes you cant use same key name .. you can get like

{
    "products": {
        "product_id": "1",
        "product_name": "Face Wash",
        "specification": {
            "brand": "Python",
            "product_Description": "very good",
            "variants": [{"size": "small"},{"size": "long"}]
        }
    }
}

answered Jul 22, 2015 at 7:02

Himanshu Upadhyay

7437 silver badges31 bronze badges

Comments

Wasim Sayyed · Accepted Answer · 2018-10-01 08:27:35Z

0

You can do '$vari_array[$var[0]][] = $var[1];' now the size is multidimensional array. as shown by https://stackoverflow.com/users/1993125/wisdmlabs in comments

answered Oct 1, 2018 at 8:27

Wasim Sayyed

6111 gold badge10 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP json not showing all related values

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related