将数据库中的两个值推送到一个数组

Question

On line 6 I am pushing a value from the database to the array called $products. I would now like to give another value from the database ($row->image) to the same array which matches with $row->name.

Maybe it could make sense to use a two dimensional array but I don't know how to do this in this case.

$products = array();
foreach($_POST['selected_checkboxes'] as $value) {
    if($result = $db->query("SELECT * FROM produkte WHERE $value = 1")){
        while($row = $result->fetch_object()) {
            if (!in_array($row->name, $products)) {
                array_push($products, $row->name);
            }
        }
    }
    else {
        array_push($products, 'error');
    }
}

The result should show me the name and the image of both values which belong together.

Answer 1

You could do this, assuming you already have your $row->name and $row->image matching logic sorted:

if (!in_array($row->name, $products)) {
   array_push( $products, array('name'=>$row->name, 'image'=>$row->image) );
}