Array to string conversion, what to do?

Question

I'm having problems with the Array to string conversion error. It's occurring here:

 <div id="pagename">
       <?php echo ['SELECT name FROM hjemmesider']; ?>  
   </div>

I'm trying to fetch a row from my db and display it, but i can't make it work... I have tried tons of things to try and sort it out, and of course researched it a great bit on the internet.

You need to add far more detail to your question! Do you have some example data from your db? Examples of what you've tried? — scottevans93, Jul 19 '16 at 13:09
This is PHP/MySQL 101 and there are [thousands of tutorials online](https://www.google.com/search?q=how+to+get+data+from+mysql+in+php). — Jay Blanchard, Jul 19 '16 at 13:11

score -1 · Answer 1 · answered Jul 19 '16 at 13:11

in your foreach or while use echo $row['your_field_name'];

You are not doin it right.. try like this:

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

score -2 · Answer 2 · answered Jul 19 '16 at 13:10

-2

It most probably means that you are trying to echo an Array. Use print_r function on your result and things will get clearer.

answered Jul 19 '16 at 13:10

Tiberiu Petcu

822
7
10

1

This is a comment, not an answer. – Jay Blanchard Jul 19 '16 at 13:10
when i wrote the 'comment' the text of the question was a different one – Tiberiu Petcu Jul 19 '16 at 13:14

Array to string conversion, what to do?

2 Answers2