How to convert an array to a string

Question

What I want is to convert an array to a string so I can display it on my websites. I made a query to select the values id, title, date, auteur. When i use my function I made for this, I get the following error:

Notice: Array to string conversion in /Applications/MAMP/htdocs/beheer/index.php on line 444 Array.

The function is as following:

<?php include ('connect/connect.php'); function getListContentMain() { global $con; $dbname = 'content'; mysqli_select_db($con,$dbname); $q = "SELECT * FROM main LIMIT 5"; $result = mysqli_query($con,$q); $ListContentMainData = array(); while($row = mysqli_fetch_array($result)) { echo $row['id']; echo $row['title']; echo $row['date']; echo $row['auteur']; } $ListContentMainData[] = $row; return $ListContentMainData; } ?>

What line is 444? Also, $ListContentMainData[] = $row; needs to go inside of your loop. — John Conde
– John Conde, Commented Apr 8, 2014 at 15:30
I made a query to select the values id, title, date, auteur... No you didn't. Your query selects every column *, you then display your selection using echo and return the last $row (again, including all columns) wrapped in another array. — Yoshi
– Yoshi, Commented Apr 8, 2014 at 15:35

Community · Accepted Answer · 2023-11-17 19:55:19Z

implode it up

return implode(' ',$ListContentMainData);

You are returning an array but you are trying to print it as a normal string , so in that case you need to implode it (array) and convert it to a string.

Rewrite like..

 $ListContentMainData = array(); while($row = mysqli_fetch_array($result)) { echo $row['id']; echo $row['title']; echo $row['date']; echo $row['auteur']; $ListContentMainData[]=$row['id']; $ListContentMainData[]=$row['title']; $ListContentMainData[]=$row['date']; $ListContentMainData[]=$row['auteur']; } return implode(' ',$ListContentMainData);

Oskar Andersson · Accepted Answer · 2014-04-08 15:37:14Z

This will make an array of strings, one for each row in the table with columns separated by a space (you could change that in the implode statement).

function getListContentMain() { global $con; $dbname = 'content'; mysqli_select_db($con,$dbname); $q = "SELECT * FROM main LIMIT 5"; $result = mysqli_query($con,$q); $ListContentMainData = array(); while($row = mysqli_fetch_array($result)) { echo $row['id']; echo $row['title']; echo $row['date']; echo $row['auteur']; array_push($ListContentMainData, implode(' ', $row)); } return $ListContentMainData; }

Collectives™ on Stack Overflow

How to convert an array to a string

2 Answers 2

Rewrite like..

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Rewrite like..

Comments

Comments

Related