$result = $menu->show_twomenu (4);
$col _jobs = Array ();
$i = 0;
while (@ $row =mysqli_fetch_array ($result)) {
$col _jobs[$i] = $row;
$i + +;
}
$col _jobs = Json_encode ($col _jobs);
Echo ' {"coljobs": '. $col _jobs. '} ';
The output is:
{
"Coljobs": [
{
"0": "5",
"1": "Steamed Mandarin fish",
"2": "4",
"3": "Abc.jpeg",
"4": "124",
"5": "100",
"6": "Example",
"7": "80",
"8": "999",
"id": "5",
"Name": "Steamed Mandarin fish",
"ParentID": "4",
"Image": "Abc.jpeg",
"Discount": "124",
"Price": "100",
"Unit": "Example",
"Sale": "80",
"Stock": "999"
}
]
}
Why would there be
"0": "5",
"1": "Steamed Mandarin fish",
"2": "4",
"3": "Abc.jpeg",
"4": "124",
"5": "100",
"6": "Example",
"7": "80",
"8": "999",
What if I don't want it?
Reply to discussion (solution)
Mysqli_fetch_array returns a mixture of subscript array and associative array
You should use MYSQLI_FETCH_ASSOC to return only associative arrays as you want.
