Add another data to json array with PHP

Question

I'm trying to create a JSON array with loop, I stored languages name in database and retrieving from query, after that I need to convert it into this format

$arrayName = array('lang-1' => null , 'lang-2' => null, ..... ,'lang-n' => null );

how can I achieve that

PHP code is like this

include_once "inc/init.php";
header('Content-Type: application/json');
$arrayName = array();
$query = $db->query("SELECT * FROM `medium`");
while ($data = mysqli_fetch_assoc($query)) {
array_push($arrayName, $data['medium']);
}
echo json_encode($arrayName);

im getting in this format

[
 "Kannada",
 "Telugu",
 "Tamil",
 "Urdu",
 "Spanish",
 "Arabian"
]

im trying pushing value but im not getting in that format, please help me

Thank you

And what format do you get? How does your table structure looks like? — Lkopo
– Lkopo, Commented Mar 18, 2017 at 18:21
I need to see your table structure to write you an answer for your issue. — Lkopo
– Lkopo, Commented Mar 18, 2017 at 18:29
database table? it is having only 2 columns. id and language columns — rakcode
– rakcode, Commented Mar 18, 2017 at 18:30

Lkopo · Accepted Answer · 2017-03-18 18:36:19Z

2

Based on your comments I'm asuming that $data['language'] represents a name of your language. Then you can achieve your goal by the following code:

include_once "inc/init.php";
header('Content-Type: application/json');
$arrayName = array();
$query = $db->query("SELECT * FROM `medium`");

while ($data = mysqli_fetch_assoc($query)) {
    $arrayName[$data['language']] = null; // $array[$key] = $value
}

echo json_encode($arrayName);

answered Mar 18, 2017 at 18:36

Lkopo

4,8538 gold badges37 silver badges60 bronze badges

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

1 Comment

rakcode Over a year ago

yes, thank you, in this format only i wanted that array,

Avinash Raut · Accepted Answer · 2017-03-18 19:25:38Z

1

using array_push you will get the same result

include_once "inc/init.php";
header('Content-Type: application/json');
$arrayName = array();
$query = $conn->query("SELECT * FROM `medium`");
while ($data = mysqli_fetch_assoc($query)) {
array_push($arrayName,$data['language ']);

}
$arrayName=array_fill_keys($arrayName, 'null'); 
echo json_encode($arrayName);

edited Mar 18, 2017 at 19:25

answered Mar 18, 2017 at 18:50

Avinash Raut

2,1311 gold badge21 silver badges30 bronze badges

5 Comments

rakcode Over a year ago

in this case i'll get all languages in different array object, like [{lang-1}, {lang-2}....{lang-n}] this

rakcode Over a year ago

above answer is solved my question, anyway thank you for replay

Avinash Raut Over a year ago

@Rak_code right! please see now it will work for you

rakcode Over a year ago

Yeah. It is also working fine. :) tq tq for your answer

Avinash Raut Over a year ago

it's my pleasure!

Collectives™ on Stack Overflow

Add another data to json array with PHP

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related