PHP - Get The First Line From A Text

Hi

My problem is that text that is in my database are showing up next to each other in a line rather than on seperate lines, normally I would have just used <br> but as it's generated from my sql I don't know how to do it.

Code: [Select]
<ul id="headlines">

<?php foreach ( $results['articles'] as $article ) { ?>

<a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a>

<?php } ?>

      </ul>

Anyone have any idea? Thanks

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,

Have a text file that is being read. I want to print the contents however I want each line of the text file to appear on a new line in the browser.

So far
$str = file_get_contents('records.txt');
$lines = explode("\n", $str);
echo $lines[0];

Help appreciated

Code:

Code: [Select]
PostInfo,color-main,Newman,not-collapsed;Friends,color-main2,Top Friends,not-collapsed||Twitter,color-main2,Twitter,not-collapsed;Signature,color-main2,Signature,not-collapsed;AboutMe,color-transparent,About Me,not-collapsed

Now I want make a function like

if PostInfo = "not-collapsed" = do this/etc,


So simply, how do I extract some content out of this and then use each thing to equal to if it's 'not-collapsed' or 'collapsed' ?

Very hard but i think possible? ty

The title says it all,..well as all u can see, there are many methods to accomplish this done but not before undergoing through a heavy tasking process. For instance,
1. Open the file
2. Reads the content of the file into array.
3. Find out the desire line of text that we want to replace.
4. Make that line of text as variable and assigns with the new data(that we want to replace) as its values.
5.open another file.
6.Write the whole contents to the file opened in 5.
7. Put the contents back to the file of original.

Can anyone contributes a better way to get this done? Like replace/delete a specific line without affecting other characters or anything therein?
Thanx.

P.S
reading and using str_replace to make the alteration always ends up in giving some kind of result beyond desired after the first round of code execution.

Here's what I'm trying to do, and I am having trouble getting started with this.  It's a very simple process, but I didn't want to spend the next 6 hours in frustration, so some help getting started would be great.

Here's the purpose of the script:
1. Allow user to add a text file to a form.
2. Take the text file, add HTML code to the beginning and end of each paragraph (a single line of text, usually paragraphs would be separated by a line return)
3. Send the user an email with the HTML file attached and thank them or whatever.
4. Allow the system to throttle itself (one-at-a-time) so that many people using the site won't bog it down.  These files will probably be anywhere from 100 KB to 1,000 KB in size, usually hitting in the 300-500KB range.

Here's what I can do very easily:
1. Allow user to add a text file - very simple and straightforward.
2. Take the text file, add HTML... - this is what I need a little help figuring out.  Each paragraph needs to have <p> at the beginning and </p> at the end, and the script will also search for keywords on certain lines (section headers) and add a <align="center"> tag to that, and so forth.  I can handle the formatting rules, but making sure the loop runs correctly could be a problem.
3. Send the user an email... - very easy, I can do that myself.
4. Allow the system to throttle itself... - this could be tricky.  I was thinking a database with a TINYINT field, 0 for not processed yet, 1 for processing, 2 for processed.  Cron job checks the next one on the list to see if it needs to send it to the processor, if the file is already being processed, or can be sent to a different database (completed entries) and removed from the current queue.  The cron job would also be responsible for triggering the "Your file is converted!" email and the attachment.

Any/all help would be greatly appreciated on this.  I am going to work on the parts that I can do myself, and I'll be checking back for the discussion - in between Mountain Dew runs.

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?

I'm ok with PHP but probably not half as good as some of you guys on here.

I am basically trying to find a way to grab a line from a huge and I mean huge text file.... its basically a list of keywords I want to call by line number but without preferably going through them all before I get to that line.....otherwise couldmcrash my server obviously.

At the moment im using this

Code: [Select]
$lines = file('http://www.mysite.com/keywords.txt');

// Loop through our array, show HTML source as HTML source; and line numbers too.
foreach ($lines as $line_num => $line) {
echo "$line_num";
}
This works but im sure theres gotta be a better way of doing to save on usuage because this is putting the whole file into the memory and if I can simply say to php give me line number 97, would umm RULE....

Hope you guys can come up with a solution as your much smarter than me ty

This is a section of my code that goes and gets videos from any video site. What I’m having issues with is having it post a random title, that are all in a text file called titles.txt. What I’m wanting to accomplish is have my script go pull the video embed code, the duration, the tags, etc. Which all works fine until I get to the title part where it pulls locally from the server from the text file. I'm not an advance programmer so not sure if I am even approaching this correct way. Here is the code I have that is responsible for putting the title in. I appreciate your help.

$video = array(
‘user_id’ => $this->user_id,
‘status’ => $this->status,
‘site’ => ‘my site’,
‘id’ => ‘’,
‘embeddable’ => true,
‘url’ => ‘’,
‘titles’ => ‘’,
‘title’ => ‘’,
‘description’ => ‘’,
‘tags’ => ‘’,
‘category’ => ‘’,
‘thumbs’ => array(),
‘duration’ => 0,
‘embed’ => ‘’
);

function random_title ()
{
$titles = file (“titles.txt”, FILE_IGNORE_NEW_LINES);
$num = rand (0, intval (count ($titles) / 3)) * 3;
return ucwords($titles[$num]);
}

//Title
if(preg_match(’/title="(.*?)"/’, $match, $matches_title)) {
$video[‘title’] = random_title(). ’ - My site name’;
} else {
$this->errors[] = ‘Failed to get video title for ‘.$video[‘url’].’!’;
if (!$this->debug) continue;
else $debug_e[] = ‘TITLE’;
}

 

I have a PHP file that is executed via batch file very frequently for live updating. This is a sort of "sync" file for reading/writing to a MySQL database. I am able to get it functioning absolutely fine when executed manually via a web browser (and my echo debug lines output the expected information), yet when I run the same PHP file via the command line, it seems to just not be capable of opening any file for reading, so the equivalent variables that are correct when executed on a web browser are blank when echoed through the command line.

Is there a different way of handling reading of files when running a php script via the command line, or should it function exactly the same as when run via a browser?

For instance:

$k = "0";
$line = file("examplefile.log")[$k];
echo $line;

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

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:

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.