php result to json object

Question

I am having a database table named "updates" which contains fields "id" and "post" which are of type 'int' and 'text' respectively. Now I am retrieving all posts as follows:

$result = mysqli_query($con,"SELECT post FROM updates");
while($row=mysqli_fetch_row($result)){
$postsarray[] = $row;
}

Now I want to convert this array into JSON array as follows:

{
    "posts":[{
            "post1",
            "post2",
            ..
            }]
}

I have tried many ways but could not get that. Can anyone help me doing that?

I am not sure the result you want (the one you show in your question) is Json. — user3849602
– user3849602, Commented Mar 10, 2015 at 10:38

IS4 · Accepted Answer · 2015-03-10 10:40:38Z

2

$result = mysqli_query($con,"SELECT post FROM updates");
while($row=mysqli_fetch_row($result)){
    $postsarray[] = $row[0];
}
$arr = array();
$arr['posts'] = $postsarray;
$json = json_encode($arr);

mysqli_fetch_row itself returns an array (the row), so you have to get the first element when adding into the $postsarray.

answered Mar 10, 2015 at 10:40

IS4

13.5k2 gold badges60 silver badges94 bronze badges

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

Comments

munsifali · Accepted Answer · 2015-03-10 10:50:14Z

0

The PHP json_encode function translates the data passed to it to a JSON string which can then be output to a JavaScript variable. We demonstrate on this page with single level arrays. Other pages demonstrate using json_encode with multi-dimensional arrays and scalar values.

The PHP json_encode function returns a string containing the JSON equivalent of the value passed to it as we demonstrate here with a numerically indexed array:

<?php
$ar = array('apple', 'orange', 'banana', 'strawberry');
echo json_encode($ar); // ["apple","orange","banana","strawberry"]
?>

answered Mar 10, 2015 at 10:50

munsifali

1,7432 gold badges24 silver badges44 bronze badges

Collectives™ on Stack Overflow

php result to json object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related