PHP - Csv Line Break With Php

hi,

i am using a database to populate a webpage with text. How do I make a function to add line breaks to the text?

an example page I want to use it on it
http://www.stayneartheairport.com/bandb.php?id=11084507&airport=manchester

You can see the two text areas of description and facilities have no paragraphs or other formatting.

I want the code to scan the text - and if there is say <br> - it will remove it an replace it with a line break.

I am extracting data from one of the sites.I would join these sentences separated by , (comma). The solution that comes to my head is by inserting the text in the file and then using file functions.However, i  was wondering if i can use str_replace here . Can anyone please point me in the right direction.

Code: [Select]
      Hospital 30-Day Death (Mortality) Rates from Heart Attack: 15.2% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Heart Attack: % (Number of Cases Too Small*)
   
      Hospital 30-Day Death (Mortality) Rates from Heart Failu 10.5% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Heart Failu 29.9% (Worse than U.S. National Rate)
   
      Hospital 30-Day Death (Mortality) Rates from Pneumonia: 9.8% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Pneumonia: 20.6% (No different than U.S. National Rate)

Hello, I have this XML file I am parsing and I have hit a small formatting issue that I can't seem to get around.    Here is what the the output of the RSS looks like. 

<description><![CDATA[<div style='text-align:left;'>Exit ramp closed. <br/><b>Current Status:</b> Open<br/><b>Affected Lanes:</b> Exit Ramp<br/><b>Dates:</b> Wednesday, May 28 - Thursday, May 29<br/><b>Days Closed:</b> <font color='#808080'>S</font><font color='#808080'>M</font><font color='#808080'>T</font><font color='#FF0000'><b>W</b></font><font color='#FF0000'><b>T</b></font><font color='#808080'>F</font><font color='#808080'>S</font>&nbsp;&nbsp;&nbsp;20:00 PM - 6:00 AM</div>]]></description>

Notice at the first is "Exit ramp closed." There is nothing before it but, for some weird reason when I parse it. It is on a new line like so, notice it should be up there with "Incident" but, it is dropped down below it. 

Incident:
Exit ramp closed. 
Current Status: Open
Affected Lanes: Exit Ramp
Dates: Wednesday, May 28 - Thursday, May 29
Days Closed: SMTWTFS   20:00 PM - 6:00 AM

This is how it is formated in the td cell. 

<td style='{$td2Style}'><strong>Incident:</strong> {$incident_data_desc}</td>\n";

So as you can see above, there is nothing before it that would cause it to break to a new line both in the table or in the RSS.    So how can I remove that first return only is that is on the same line with it and not below it.    I have tried this and a couple of other things like trim with no luck.   

$description         = $item->description;
    $incident_data_desc  = str_replace("\r", '', $description );

Note, I only need that first one removed, the others are fine. I can do it but it will remove all the breaks and I only want to remove that first one that is causing the line to be on a new line.    Any suggestions?   -Thanks

how do I make this form here have a limit on the value's name, then it moves to the next line?

Code: [Select]
<form action=\"reply.php?com_id=$com_id\" method=\"post\">
<font color='brown'><u><input type=\"submit\" name ='submit' class=\"link\" value='$title'></u></font>
</form>

I am having problems with these slashes. They keep showing up when I echo data....
The code is to update a field in a mysql database table.

Here is my code:
Code: [Select]
$query = mysql_query("SELECT * FROM `bus` WHERE username='$username'");
$row = mysql_fetch_array($query);
$bio = $row['about'];
$bio = str_replace("<br />","\r\n",$bio);



if(isset($_POST['submit'])){
if(empty($errors)){
if($password == $pass){

$about1 = mysql_real_escape_string($_POST["about"]);
$about1 = str_replace("\r\n","<br />",$about1);

mysql_query("UPDATE bus SET about='$about1' WHERE username='$username'");

}else{$errors[] = 'Incorrect Password';}
}
}

When I run this and put:
About: 
I'm very tired today
It's been very hard

I get the about1 string as: I\\\'m very tired today\r\nIt\\\'s been very hard

Why???

what im trying to do is take a youtube embed code find the URL code for that video and remove all other parts of the code keeping only the URL of the video
after i get the URL by it self then replace the http://www.youtube.com/ part of the URL with http://i2.ytimg.com/vi/

to do this i know that i need something like this to get the URL of the video
http://www.youtube.com/((?:v|cp)/[A-Za-z0-9\-_=]+)
but how to only return just the URL is something idk how to do

then use str_replace http://www.youtube.com/(?:v|cp)/" with  http://i2.ytimg.com/vi/

so in the end im asking if anyone know how to remove all other codes i dont want  and only keep the URL


this may have to be done using "regex" im not sure as i dont know to much about regex and what it can do but does sound like it would help lol

i have to read a single line from a csv,  its a really big file and i only need one column. i need the response to be a string ,i made a search and found the following code but i dont have any idea how to get a single line from a single string per run .

<?php
$row = 1;
//open the file
if (($handle = fopen("file.csv", "r")) !== FALSE)
{
    while (($data = fgetcsv($handle, 0, ",")) !== FALSE)
    {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++)
        {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

Edited by bores_escalovsk, 16 May 2014 - 06:38 PM.

Hi.

I want a simple textbox, that when submited, will replace very every new line, with the <br> tag.

What will happen, when it submits, it will take the contents of a textbox, add the <br> tag where a new line is suposed to be, and save the string to a MySQL Database.

I think this is the easiest way of allowing a user to edit what appears on a website when logged in, but if there is a easier way, then please tell me.

What I am trying to do, is a login page, and once logged in, you enter new text into the textbox, click submit, and on the website homepage, the main text will change to what was submitted. But if there is a new line, I think the only way in HTML to make one is to put a <br> tag, so I want the PHP to but that tag wherever there is a new line.

Sorry if I am confusing, I am not that advanced at PHP, but I would be very happy if you could supply me with the correct code. Time is running out...

If you do not understand me, please tell me

--
PHPLeader (not) 

Dear All

           Good Day, i am new to PHP (a beautiful server side scripting language). i want to send a mail with line by line message i tried with different types like by placing the things in table and using  <br /> but the thing is the tags are also visible in the message of the mail.

Here is my code:

$message1  = "Name       :".  $_REQUEST['name']."<br />";
$message1 .= "Surname    :".  $_REQUEST['surname']."<br />";
$message1 .= "Cellphone  :".  $_REQUEST['mobileno']."<br />";
$message1 .= "Telephone  :".  $_REQUEST['landno']."<br />";
$message1 .= "Fax        :".  $_REQUEST['fax']."<br />";
$message1 .= "Company    :".  $_REQUEST['company']."<br />";
$message1 .= "Email      :".  $_REQUEST['email']."<br />";
$message1 .= "Country    :".  $_REQUEST['country']."<br />";
$message1 .= "Enquity    :".  $_REQUEST['enquiry']."<br />";
$message1 .= "Date&Time  :".  $date."<br />";

For this code if try to print/echo it it is working fine it is displaying line by line, but using this variable ($message1) in the mail these <br /> are also visible.
Can any one guide me to resolve(to remove these tags from the message part) this issue.
Thanks in Advance. :confused:

How to get this echo line to display as one line?
No matter what I have done it displays as two lines.  I even tried <nobr></nobr>

Teachers Name:
John Jones

$userid = mysql_real_escape_string($_GET['user_id']);
$sql = "select * from users where `id`='$userid' ";

$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{ 
echo  "<h3>Teachers Name: </h3>" . $row["first_name"] . " " . $row["last_name"]  ;  }


Thanks for your help.

I have a script that reads a .gz file into an array and prints the name of each record but will not work on larger files. Is there a way to read 1 line at a time?
Here is the code I have so far.
Code: [Select]
<?php

if ($handle = opendir('.')) {

print "<ol>";
    
    while (false !== ($file = readdir($handle))) {
if($file != '..' && $file!="." && $file!="start_update.php" && $file!="sharons_dbinfo.inc.php" && $file!="root.php" && $file!="read_directory.php" && $file!="read_dir.php" && $file!="new_category.php" && $file!="index.php" && $file!="file_count.php" && $file!="dir_loop2.php" && $file!="dir_loop1.php" && $file!=".htaccess" && $file!="Answer.txt" && $file!="Crucial_Technology-Crucial_US_Product_Catalog_Data_Feed.txt"){
$filename = $file;
$go = filesize($filename);
if($go >= 1){
$filename2 = explode("-", $filename);
$filename2 = $filename2[0];
echo str_replace("_"," ",$filename2) . ' | Filesize is: ' . filesize($filename) . ' bytes<br>';
$gz = gzopen($filename, 'r');
$lines = gzfile($filename,10000);
foreach ($lines as $line) {
$line2 = explode(",", $line);
$line2 = str_replace("," , "-" , $line2);
    echo "<li>".str_replace("," , "-" , $line2[4])."</li><br>";
}

}
}
    }

    closedir($handle);
}
?>
</ol>

Good morning,

I passed a bunch of HTML tags over a function that delete then, keeping just the text between. The problem is, after that all the tags were replaced by line breaks. Something like this before the function:

<tr>
<td>
Text
</tr>
</td>

After the function the 4 tags were correctly removed but instead i receive just the string "Text" I receive 2 line breaks, the "Text" and other 2 line breaks, like this:



Text



In HTML code this line breaks has no tags like <br> or <p> it's just blanck lines. I need to get just the text, how can I get rid of then? I tried this and also didn't work.

$text = str_replace("/n", "", $text );

Thanks
Danilo Jr.

why is it that when i saved it adds a break tag i dont understhand heres the code i cant find it its only when i save or remove a video and save it it has a break

Code: [Select]
<?php

require "scripts/connect.php";

if($_POST['submitbtn']){

$video1 = mysql_real_escape_string(html_entity_decode($_POST['video1']));
$video2 = mysql_real_escape_string(html_entity_decode($_POST['video2']));
$video3 = mysql_real_escape_string(html_entity_decode($_POST['video3']));
$video4 = mysql_real_escape_string(html_entity_decode($_POST['video4']));

if($video1){
if($video2){
if($video3){
if($video4){

$query = mysql_query("UPDATE videos SET video1='$video1',video2='$video2',video3='$video3',video4='$video4'");

header("location: http://www.mywebsite.com/admin/editvideos");

}else
$msg = "PLEASE FILL IN";
}else
$msg = "PLEASE FILL IN";
}else
$msg = "PLEASE FILL IN";
}else
$msg = "PLEASE FILL IN";
}
mysql_close();
?>
<?php include "header.php";?>
<?php if($email){?>

<?php include "inc/nav.php"; ?>

<div id="righthomecontent">

<?php
require "scripts/connect.php";

$query = mysql_query("SELECT * FROM videos");
$rows = mysql_fetch_assoc($query);

$video1 = stripslashes($rows['video1']);
$video2 = stripslashes($rows['video2']);
$video3 = stripslashes($rows['video3']);
$video4 = stripslashes($rows['video4']);

mysql_close();
?>
<center>MUST USE THIS IN VIDEOS ?wmode=opaque"</center><br>
<center>All videos are Width='220' and Height='240'</center><br>

<form class="editvideoform" action="editvideos" method="post">
<table>
<tr>
<td></td>
<td><?php echo $msg;?></td>
</tr>
<tr>
<td>VIDEO 1</td>
<td><textarea cols=25 rows=10 name="video1"><?php echo $video1;?></textarea></td>
</tr>
<tr>
<td>VIDEO 2</td>
<td><textarea cols=25 rows=10 name="video2"><?php echo $video2;?></textarea></td>
</tr>
<tr>
<td>VIDEO 3</td>
<td><textarea cols=25 rows=10 name="video3"><?php echo $video3;?></textarea></td>
</tr>
<tr>
<td>VIDEO 4</td>
<td><textarea cols=25 rows=10 name="video4"><?php echo $video4;?></textarea></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submitbtn" value="SUBMIT" /></td>
</tr>
</table>
</form>

</div>
<?php } else 
{
echo "<center><h1>PLEASE LOGIN</h1></center>";
}
?>
<?php include "footer.php";?>

I have a chain of methods, is there anyway to end the chain half way through if some particular event happens?

Here is an example (not the best but still an example):
Code: [Select]
<?php
$age = $class->post("age")->callback(funciton(){
        global $class;
        if($class->string() < 18){
                // end the execution of the chain, doesn't execute toInt()
        }
})->toInt();
?>

Hi all,

I realised as users register themselves in the registration form, they wrote their comments and experience in the comment box which was provided

Example (this is the content which they have written)
'Sentence 1 - Abccafsafsafafasdfafasfafs

Sentence 2 - dasddsadsadsadsdaddsda'


As you can see, between Sentence 1 and 2 there is a break (space).
However when we store it in our database, and generate it out as a webpage, the break (space) is gone, and sentence 1 and 2 merged

Example
'Abccafsafsafafasdfafasfafsdasddsadsadsadsdaddsda'

My question is, how can we prevent 2 different sentences from merging? Thanks

Below is my code and attached it what has been generated after we have posted it in webpage


Code: [Select]
cho '<div id="panel3">';
echo '<table>';
/***Tutor's Comments***/
echo'<div id="tutor_comments">';
echo '<br/><tr><td class="row_header">Tutor\'s Comments</td></tr>';
if (!empty($row2['tutor_comments'])) {
echo '<tr><td>' . $row2['tutor_comments'] . '<br/><br/></td></tr>';
}
/***Tutor's Commitments***/
echo '<tr><td class="row_header">Tutor\'s Commitment</td></tr>';
if (!empty($row2['tutor_commitment'])) {
echo '<tr><td>' . $row2['tutor_commitment'] . '<br/><br/></td></tr>';
}
/***Admin_comments***/
echo '<tr><td class="row_header">Admin\'s Comments</td></tr>';
if (!empty($row2['admin_comments'])) {
echo '<tr><td>' . $row2['admin_comments'] . '<br/><br/></td></tr>';
}

echo '</table>'; //End of Panel 3's table
echo '</div>'; //End of tutor_comments DIV