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

1

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);

edited Nov 17, 2023 at 19:55

CommunityBot

11 silver badge

answered Apr 8, 2014 at 15:30

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

Comments

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

1

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;
}

answered Apr 8, 2014 at 15:37

Oskar Andersson

618 bronze badges

Collectives™ on Stack Overflow

How to convert an array to a string

2 Answers 2

Rewrite like..

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Rewrite like..

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related