Trim An json Array via PHP

Question

How Can I Trim This Array? I Want to echo First Object of My Array,That is id, I Mean 3 Row of id

 <?php
    $con=mysqli_connect("localhost","root","","arrayy");
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }
 $sql="SELECT `survey_answers` FROM `user_survey_start`";

if ($result=mysqli_query($con,$sql)){

 while ($row = mysqli_fetch_row($result)){

    $json = $row[0];
    $jason_array  = json_decode($json,true);
    foreach ($jason_array as $data){
        $id[] = $data['id'];
        //$answer[] = $data['answer'];
      // $type[] = $data['type'];

        // here code to insert/update values to db column
    }

    echo implode(',',$id)."</br>";
   // echo implode(',',$answer);
  //  echo implode (',',$type);
  }

}
mysqli_close($con);
?>

And Please Take a Look to Output in This Photo

Incorrect, it give me Array ( [0] => 26 [1] => 30 [2] => 31 [3] => 32 [4] => 33 ) Array ( [0] => 26 [1] => 30 [2] => 31 [3] => 32 [4] => 33 [5] => 40 [6] => 30 [7] => 31 [8] => 32 [9] => 33 ) Array ( [0] => 26 [1] => 30 [2] => 31 [3] => 32 [4] => 33 [5] => 40 [6] => 30 [7] => 31 [8] => 32 [9] => 33 [10] => 100 [11] => 200 [12] => 300 [13] => 400 ) — Saeed Heidarizarei
– Saeed Heidarizarei, Commented Feb 16, 2017 at 8:26

Naga · Accepted Answer · 2017-02-16 08:25:23Z

2

You need to re initialize the $id array. Try this

<?php
    $con=mysqli_connect("localhost","root","","arrayy");
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }
 $sql="SELECT `survey_answers` FROM `user_survey_start`";

if ($result=mysqli_query($con,$sql)){

 while ($row = mysqli_fetch_row($result)){

    $json = $row[0];
    $jason_array  = json_decode($json,true);
    $id = array();
    foreach ($jason_array as $data){
        $id[] = $data['id'];
        //$answer[] = $data['answer'];
      // $type[] = $data['type'];

        // here code to insert/update values to db column
    }

    echo implode(',',$id)."</br>";
   // echo implode(',',$answer);
  //  echo implode (',',$type);
  }

}
mysqli_close($con);
?>

answered Feb 16, 2017 at 8:25

Naga

2,1683 gold badges18 silver badges21 bronze badges

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

2 Comments

Death-is-the-real-truth Over a year ago

what is changed here?

Saeed Heidarizarei Over a year ago

Yesssssssss, Appriciate It.

Collectives™ on Stack Overflow

Trim An json Array via PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related