Create php key and value array [duplicate]

Question

I am trying to create a key and value array from database record, but the array just getting the final record! Here is a snippet of my code:

$cateogiresArr = array();
while ($row = mysqli_fetch_row($result))
{
  $cateogiresArr["categoryname"] = $row[1];
  $cateogiresArr["description"] = $row[2];
}
header("Content-type:application/json");
$json_categories = json_encode($cateogiresArr);

u_mulder · Accepted Answer · 2019-04-06 11:42:35Z

4

On each iteration add new array with required data to $cateogiresArr:

while ($row=mysqli_fetch_row($result))
{
    $cateogiresArr[] = [
        "cateogryname" => $row[1],
        "description" => $row[2],
    ];
}

answered Apr 6, 2019 at 11:42

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

1 Comment

BritishWerewolf Over a year ago

@PhillipMark Please mark this answer as accepted by clicking the green tick on the left. Also, some spelling corrections: categoryname, and categoriesArr.

Collectives™ on Stack Overflow

Create php key and value array [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related