Array inside a json object and object inside a json object using php

Question

I am trying to produce the following JSON from MySQL database using PHP. How do I go about doing it in PHP lets say using the explode function for getting the array into the JSON object. I don't know about getting the JSON object inside an object. I just need to separate PHP files to achieve the following.

<?php
include 'database.php';
$pdo = Database::connect();
$sql = 'SELECT * FROM users';
$q = $pdo->prepare($sql);
$q->execute(array($sql));
$array = array();
 while ($row = $q->fetch(PDO::FETCH_ASSOC)){
     array_push($array, $row);
 }
$json = json_encode($array);
echo $json;
Database::disconnect();?>

Array inside a JSON object:

[
{
  "firstName":"John", 
  "lastName":"Doe",
  "images": ['image1','image2','image3']
}, 
{
  "firstName":"Anna",   
  "lastName":"Smith",
  "images": ['image1','image2','image3']
},
{
 "firstName":"Peter", 
 "lastName":"Jones",
 "images": ['image1','image2','image3']
 }
]

JSON object inside an object:

[
{
  "firstName":"John", 
  "lastName":"Doe",
  "cover": {
            "cover_id": "0858699703",
            "source": "www.myimages.co.zw/images/photo",
            "offset_y": "0"
          }
}, 
{
  "firstName":"Anna",   
  "lastName":"Smith"
  "cover": {
            "cover_id": "0858699703",
            "source": "www.myimages.co.zw/images/photo",
            "offset_y": "0"
          }
},
{
 "firstName":"Peter", 
 "lastName":"Jones"
 "cover": {
            "cover_id": "0858699703",
            "source": "www.myimages.co.zw/images/photo",
            "offset_y": "0"
          }
 }
]

<?php include 'database.php'; $pdo = Database::connect(); $sql = 'SELECT * FROM user'; $q = $pdo->prepare($sql); $q->execute(array($sql)); $array = array(); while ($row = $q->fetch(PDO::FETCH_ASSOC)){ array_push($array, $row); } $json = json_encode($array); echo $json; Database::disconnect(); ?> — Hopewell Mutanda
– Hopewell Mutanda, Commented Dec 6, 2014 at 19:57

Hopewell Mutanda · Accepted Answer · 2014-12-06 20:38:31Z

1

 <?php
include 'database.php';
$pdo = Database::connect();
$sql = 'SELECT * FROM test';
$q = $pdo->prepare($sql);
$q->execute(array($sql));
$array = array();
 while ($row = $q->fetch(PDO::FETCH_ASSOC)){

     $row_array['name'] = $row['name'];
     $row_array['surname'] = $row['surname'];
     $row_array['images'] =  explode(" ", $row['images']);

     array_push($array, $row_array);
 }
$json = json_encode($array);
echo $json;
Database::disconnect();
?>

answered Dec 6, 2014 at 20:38

Hopewell Mutanda

1,0853 gold badges11 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Array inside a json object and object inside a json object using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related