Trying to print out the values of an Associative Array - Error: Array to string conversion

Question

I'm trying to echo the values of an associative array that contains all the rows in a table using foreach in a table.

Here is the code:

<?php 
    $result = doSql("SELECT * FROM carts WHERE userID =".$userID);
     if($result && mysqli_num_rows($result)>0) {
        $cartRows = mysqli_fetch_all($result); 

             foreach($cartRows as $key => $value) {

                echo "<tr>
                    <td scope='col'>" .$value['cartID']. "</td>
                    <td scope='col'>" .$value["productToCartQty"]. "</td>
                    <td scope='col' colspan='2'>".$value['invoiced']."</td>
                    <td scope='col' colspan='2'>" .$value['customization']."</td>
                   </tr>";
                }
            } 
 ?>

The error: Array to string conversion

I don't understand why I'm getting this error as I am only echoing out the value inside of the array $value i.e. echo $value['cartID']?

Here is the screenshot of the error: https://gyazo.com/cdc8dde8c2e09e91b5209c2b50bcb72c

Any ideas?

Do print_r($cartRows) before foreach and see if its really an array — Muhammad Bilal
– Muhammad Bilal, Commented Nov 19, 2015 at 4:23

Muhammad Bilal · Accepted Answer · 2015-11-19 04:26:39Z

1

You need to change:

$cartRows = mysqli_fetch_all($result);

to:

$cartRows = mysqli_fetch_all($result,MYSQLI_ASSOC);

answered Nov 19, 2015 at 4:26

Muhammad Bilal

2,1341 gold badge15 silver badges24 bronze badges

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

1 Comment

user3289740 Over a year ago

Omg! It worked. The reason why I left out the second parameter is because it was optional (I researched). Can please explain why I was getting the error: String to Array conversion if I don't have that parameter?

Collectives™ on Stack Overflow

Trying to print out the values of an Associative Array - Error: Array to string conversion

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related