从表数据库获取数据的格式数组

Question

i have this code

$Query = mysql_query("Select*from mbulan");
while ($row = mysql_fetch_array($Query, MYSQL_ASSOC)) {
$items = array($row['id']=>$row['bulan']);
foreach ($items as $key=>$value) {
        echo json_encode(array("$value"));}
}

and the output something like this :

["January"]["Fabruary"]["Maret"]["April"]["Mei"]["Juni"]

but i wan change the output like :

["January","February","Maret","April","Mei","Juni"]

what should i do for the code and where is the code must be change it ?

Answer 1

You can use the following code ..

$Query = mysql_query("SELECT * FROM mbulan");
$item = array();
while ($row = mysql_fetch_array($Query, MYSQL_ASSOC)) {
    $items[] = $row['bulan'];
}

echo json_encode($items);

Feel free to ask any questions.