使用PHP将SQL数据转换为字符串

Question

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

Answer 1

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.