I have a column of data from an SQL database which I am calling through PHP. I wish to convert these results in to a consecutive string. So, it's a case of converting the result (consisting of a series of strings from the columns) in to a string.
How would I go about this?
At the moment, when I print the data using
while($row = mysqli_fetch_array($result))
{
echo $row['title'];
echo "<br>";
}
it returns each item, but I wish to place these items into a string.
Thanks
You can do that using the implode-function:
$titles = array();
while($row = mysqli_fetch_array($result))
{
$titles[] = $row['title'];
}
$titlestring = implode(",", $titles);
An other option would be to concatenate the strings yourself like this:
$titlestring = "";
while($row = mysqli_fetch_array($result))
{
$titles .= $row['title'] . ", ";
}
$titlestring = substr($titlestring, 0, -2);
The first option is better though in my opinion.
while($row = mysqli_fetch_array($result))
{
$myString .= $row['title'] . " ";
}
+.
echo "a" + "b";. It will result in 0. echo "a" . "b"; will result in ab. What is the + at the end of the line doing there?MySQL can handle this much better..
Give a index on the title column and run a query like this.
SET SESSION group_concat_max_len = @@max_allowed_packet;
SELECT GROUP_CONCAT(title) FROM database.table GROUP BY title ASC
example returned data title1,title2,title3
