PHP/MySQL fetch and convert to csv with pipe delimiter

Question

I have a PHP script that is exporting a mysql query to a | delimited file. This working great except for the last "column" is appending a | pipe when I don't need it to.

$values = mysql_query("SELECT ColumnA AS Name, ColumnB AS Address, ColumnC AS Phone FROM Table1");
$row = 0;
while ($rowr = mysql_fetch_assoc($values)) 
{
  if ($row == 0)
  $row++;
  $csv_output .= "id|";
  foreach($rowr as $name => $value)
  {
  $csv_output .= $value."|";
  }   
      $csv_output .= "\n";    
}

The end result looks like

Name|Address|Phone|
Name|Address|Phone|
Name|Address|Phone|

How do I avoid having the ending pipe after the Phone| so it looks like this:

Name|Address|Phone
Name|Address|Phone
Name|Address|Phone

Iqbal Malik · Accepted Answer · 2013-10-02 15:55:43Z

3

Use this one.

while ($rowr = mysql_fetch_assoc($values)) 
{
  if ($row == 0)
  $row++;
  $csv_output .= "id|";
  foreach($rowr as $name => $value)
  {
  $csv_output .= $value."|";
  }   
      $csv_output = substr($csv_output,0,-1);
      $csv_output .= "\n";    
}

answered Oct 2, 2013 at 15:55

Iqbal Malik

6025 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

PHP/MySQL fetch and convert to csv with pipe delimiter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related