PHP - Line Breaks On Mysql Generated Text

I am constructing an XML file with PHP. I read information from a template XML file and then add elements and save it.

The line breaks from the template are preserved in the saved file, but all the new elements are on one line. Is there a way to break them up so it is easier to read the file?

Here is the original template:
Code: [Select]
<InternationalShippingServiceOption>
  <ShippingService> token </ShippingService>
  <ShippingServiceAdditionalCost currencyID="CurrencyCodeType"> AmountType (double) </ShippingServiceAdditionalCost>
  <ShippingServiceCost currencyID="CurrencyCodeType"> AmountType (double) </ShippingServiceCost>
  <ShippingServicePriority> int </ShippingServicePriority>
</InternationalShippingServiceOption>
Here is the saved information (all the ShipToLocation elements on one line):
Code: [Select]
<InternationalShippingServiceOption>
  <ShippingService>StandardInternational</ShippingService>
  <ShippingServiceAdditionalCost currencyID="CurrencyCodeType">26.994</ShippingServiceAdditionalCost>
  <ShippingServiceCost currencyID="CurrencyCodeType">44.99</ShippingServiceCost>
  <ShippingServicePriority>2</ShippingServicePriority>
<ShipToLocation>BE</ShipToLocation><ShipToLocation>FR</ShipToLocation><ShipToLocation>IE</ShipToLocation><ShipToLocation>LU</ShipToLocation><ShipToLocation>MC</ShipToLocation><ShipToLocation>NL</ShipToLocation><ShipToLocation>GB</ShipToLocation><ShipToLocation>DE</ShipToLocation><ShipToLocation>IT</ShipToLocation></InternationalShippingServiceOption>
I am using the $doc->formatOutput = true; option.

I have a form which has a textarea in it.  When the form is submitted the contents are submitted to a MySQL database and the contents or the textarea are stored in a text variable.  What is the best was to preserve line breaks in the textarea?  At the moment if the user enters to separate paragraphs into the textarea they will be merged into one.  Thanks for any help. 

Hi All,

I am exporting data to excel, but run into a problem if the text contains a line break.  When it gets to the line break, it cuts off the rest of the text.

Here is my printer code:

Code: [Select]
$file = 'Notes_Export';
$csv_output = array();


$tmp = array();
$tmp[] = 'Created On';
$tmp[] = 'Created By';
$tmp[] = 'Note';

$csv_output[] = '"' . implode('","', $tmp) . '"';

$sql  = "SELECT pn.created_on, CONCAT( u.firstname,' ', u.lastname) AS created_by, pn.note FROM prop_notes pn LEFT JOIN users u ON pn.created_by = u.user_id ";
$sql .= "WHERE pn.deleted_by IS NULL AND pn.archive = '0' AND pn.property_id = '".$_GET['pid']."'";
      $result = mysqli_query($connect, $sql);

         while($rowr = mysqli_fetch_row($result))
         {
$tmp = array();
for ($j=0; $j<3; $j++) {$tmp[] = $rowr[$j];}
$csv_output[] = '"' . implode('","', $tmp) . '"';
         }


$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
// header( "Content-disposition: filename=".$filename.".csv");
header("Content-disposition: attachment; filename=".$filename.".csv");
print implode("\n",$csv_output) . "\n";
exit;

Hi all,

I'm currently rewriting our contact us form using the php Pear Mail package. It allows both html based emails and text based emails, and displays the relevant version based on the end recipients broswer capabilities.

I have the html version working perfect, however the text based version spits out the whole message without line breaks. Since some of the computers in our building only except text emails (due to security) it needs to be laid out so that it is legible. I've searched around and tried various options but the emails are still arriving without breaks.

So as an example:

A User Inputs the following message using a textarea on the php form:

Hi there,

Great website, need help with such and such though.

Regards

Bob


The email message gets collected and included in a html message. Then a duplicate text based message is made like so (Code so far):

Code: [Select]
$plaintxt = '-----------------------------------------' . "\n";
$plaintxt .= Website Enquiry' . "\n";
$plaintxt .= '-----------------------------------------' . "\n";
$plaintxt .= 'A visitor to our website has submitted the following enquiry:' . "\n\n";
$plaintxt .= 'Name: ' . $visitor_name . "\n";
$plaintxt .= 'Company Name: ' . $visitor_companyname . "\n";
$plaintxt .= 'Email Address: ' .  $visitor_email . "\n";
$plaintxt .= 'Telephone Number: ' . $message_telephone . "\n\n";
$plaintxt .= 'Subject of Enquiry: ' . $msg_subject . "\n";
$plaintxt .= 'Enquiry: ' . "\n\n";
$plaintxt .= $message_body . "\n\n";
$plaintxt .= '-----------------------------------------' . "\n\n";
$plaintxt .= 'User IP Address:' . $ip . "\n";
$plaintxt .= 'User Browser Info:' . $httpagent . "\n";
$plaintxt .= 'Date/Time Submitted:' . $time . "\n";

$crlf = "\n";
$headers = array('From' => $contact_from_email, 'Return-Path' => $contact_from, 'Subject' => $subject, 'To' => $contact_to);
       
// Creating the Mime message
$mime = new Mail_mime($crlf);
       
// Setting the body of the email
$mime->setTXTBody($htmlmessage); //Text version of the email
$mime->setHTMLBody($plaintxt); // HTML version of the email

 "\n"; - These were suggested by users on the pear mail manual.

Then once sent and opened you'd expect to see:

Quote

      -----------------------------------------
      Website Enquiry
      -----------------------------------------
      A visitor to our website has submitted the following enquiry:
      Name: Bob
      Company Name: Someplace Ltd
      Email Address: bob@someplace.com
      Telephone Number: 01234 567890
      Subject of Enquiry: help
      Enquiry:

      Hi there,

      Great website, need help with such and such though.

      Regards

                Bob

      -----------------------------------------
      User IP Address: 123.456.789.012
      User Browser Info: Mozilla
      Date/Time Submitted: 29th September 2011 09:56



However when opened in all the email applications I have (Outlook, Gmail, Live Mail, Hotmail, Yahoo) it looks like this:

Quote

-----------------------------------------Website Enquiry-----------------------------------------A visitor to our website has submitted the following enquiry:Name: BobCompany Name: Someplace LtdEmail Address: bob@someplace.comTelephone Number: 01234 567890Subject of Enquiry: helpEnquiry: Hi there,Great website, need help with such and such though.RegardsBob-----------------------------------------User IP Address: 123.456.789.012User Browser Info: MozillaDate/Time Submitted: 29th September 2011 09:56



Yet if you look at the source of the email. The line breaks are there. Am I missing something?

My PHP code is generating XML with a blank first line before the  <?xml version="1.0" ?>

see http://urbanbees.co.uk/maps/phpsqlajax_genxml3.php

I have been told this is the reason why my map is not showing the markers in chrome and FF but it is OK in IE8. see http://urbanbees.co.uk/maps/map_of_hive_locations_update.htm  You'll either see markers or not depending on your broswer.

How do I change the code to not generate this first blank line.

Here is the php code.
<?php
require("phpsqlajax_dbinfo.php");
// Start XML file, create parent node
$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers");
$parnode = $dom->appendChild($node);
// Opens a connection to a MySQL server
$connection=mysql_connect (localhost, $username, $password);
if (!$connection) {  die('Not connected : ' . mysql_error());}
// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}
// Select all the rows in the markers table
$query = "SELECT * FROM markers WHERE 1";
$result = mysql_query($query);
if (!$result) {   
  die('Invalid query: ' . mysql_error());
} 
header("Content-type: text/xml"); 
// Iterate through the rows, adding XML nodes for each
while ($row = @mysql_fetch_assoc($result)){   
  // ADD TO XML DOCUMENT NODE   
  $node = $dom->createElement("marker");   
  $newnode = $parnode->appendChild($node);   
  $newnode->setAttribute("name",$row['name']);
  $newnode->setAttribute("address", $row['address']);   
  $newnode->setAttribute("lat", $row['lat']);   
  $newnode->setAttribute("lng", $row['lng']);   
  $newnode->setAttribute("type", $row['type']);
} 
echo $dom->saveXML();
?>