PHP - Extracting A Value From A Page Of Text...

Hi

I'm learning php and trying to write a script to extract registration information from a large text file. Sadly my meagre knowledge of php is letting me down a bit. It's a case of knowing what you want the script to do but not having the knowlege of how to 'say it'.

So i was hoping that if I posted my code here someone could either give me a few pointers on where i am going wrong or suggest  a better way.

The text file data luckily has a recurring format as follows (for brevity i've only included one entry, which contains made up information):



From:   bella_done@yahoo.co.uk
Sent:   02 February 2011 22:50
To:   Jonny tum, patsy fells, dingly bongo
Subject:   Subject: Fun Run 2010

Categories:   Fun Run

Name: Bella Donna
 Address: 14 brondle avenue
 Postcode: cd83 1rg
 Phone: 0287343510
 Email: bella_don@yahoo.co.uk
 DOB: 15/11/1945
 Half or Full: Full fun run
 How did you hear: Took part in 2010

As you can see the data has a convenient boundary at the 'from' field and the colon (or so it occurred to me) so I created my script as follows:



// the string being analysed
$the_string = "
From:

bella_done@yahoo.co.uk
Sent:

02 February 2011 22:50
To:

Jonny tum, patsy fells, dingly bongo
Subject:

Subject: Fun Run 2010

Categories:

Fun Run

Name: Bella Donna 
 Address: 14 brondle avenue 
 Postcode: cd83 1rg 
 Phone: 0287343510 
 Email: bella_don@yahoo.co.uk 
 DOB: 15/11/1945 
 Half or Full: Full fun run 
 How did you hear: Took part in 2010";

// remove all formatting to work with a clean string

$clean_string = strip_tags($the_string);



// remove form field entries from the data and replace with commas and a ZZZ boundary

$remove_fields = array("Categories:" => "","Name:" => ",","Address:" => ",","Postcode:" => ",","Phone:" => 

",","Email:" => ",","DOB:" => ",","Half or Full:" => ",","How did you hear:" => ",","From:" => "ZZZ","Sent:" => 

",","To:" => ",",  );


$new_string = strtr("$clean_string",$remove_fields);


// split the data at the boundary ZZZ

$string_to_array = explode("ZZZ", $new_string);

$new_string2 = implode("</br>",$string_to_array);

echo $new_string2; 




$myFile = "address_list.csv";
 $fh = fopen($myFile, 'w') or die("can't open file");
 $stringData = $new_string2;
 fwrite($fh, $stringData);
 fclose($fh);




One major problem is when i write the new data to a csv file the csv contains spacings that cause it to be reproduced in a column form rather than as separate fields for each comma boundary.

So can anyone suggest either

a) a better way of extracting the data from the text file (doesn't need to be 100% clean and perfect)

b) How can i stop the spaces in the csv (i thought i would have fixed this when i stripped the tags from the string at the start??).

Any help would be greatly received by a newbie phper.

It's my first shot at performing anything moderately taxing so if I've made some blaring oversites I would very much welcome your wisdom!

Thank you

Drongo

I have html files in which, there are lines of urls starting with http:// (simple text, not hyperlink) without a tag. What is the simplest way to extract them?
 

I have a bunch of pdf's and I want to extract text from the last page of every pdf. I have a function to count the number of pages in each pdf.

Does anyone know of a way that I could extract file from a specified file and page number.
example:   getData('example.pdf', 54);

Hi people, I really hope you guys can help me out today. I'm just a newbe at php and i'm having real trouble.

Bassically all I want to do is have a user type in a company name in a html form.

If what the user types in the form matches the company name in my php script i want the user to be sent to another page on my site.

If what the user types in the form doesnt match the company name in my php script i want the user to be sent to a differnt page like an error page for example.

this is my html form:

Code: [Select]
<form id="form1" name="form1" method="post" action="form_test.php">
  <p>company name:
    <input type="text" name="company_name" id="company_name" />
  </p>
  <p>
    <input type="submit" name="button" id="button" value="Submit" />
  </p>
</form>
And this is the php code I'm trying to process the information on:

Code: [Select]
<?php

$comp_name = abc;

if(isset ($_POST["company_name"])){
 if($_POST["company_name"] == $comp_name){

     header("Location: http://www.hotmail.com");
exit();
 }

else{
   header("Location: http://www.yahoo.com");
exit();   
 }
}
?>
The thing is i'm getting this error when i test it:
Warning: Cannot modify header information - headers already sent by (output started at D:\Sites\killerphp.com\form_test.php:10) in D:\Sites\killerphp.com\form_test.php on line 17

Please can some one help me out, i'm sure this is just basic stuff but i just cant get it to work 

Cheers.

Folks,

I want to extract certain portion form URL.

Exmaple:
Quote

http://abc.com/this-is-test.html


Output should be
Quote

this-is-test


Another Example
Quote

http://abc.com/this-is-yet-another-test.html

Output should be
Quote

this-is-yet-another-test


I am not sure how it can be done with preg_match() and regex or something like that...

Can someone help me with this please?

Cheers
Natasha

$example "Q: Example? A:"

Let's assume that I'd like to display $example but exclude "Q:" and "A:", how would I do that?

hey guys i need to extract all the IP's of a string and loop them for more operations but for some reason i only get the first one

<?php

$string = '80.37.14.13 80.37.14.14 80.37.14.15';
preg_match("/\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}/", $string, $matches);

foreach ($matches as $ip){
    echo "$ip<br>";
}

?>

The string is not really seperated by spaces ... it can actualy be messy and have ips rapped arround a lot of code. The regex works because i do get the first one ...

What did i miss?

I have an RSS feed, with alot of data of lottery numbers.

the feed itself is : http://www.alllotto.com/rss/NY/latest.rss

The item i am interested in is:

Quote

<item>
                   <title>Take 5</title>
                 <description>2011-08-27: 4, 10, 16, 17, 31</description>
                   <guid isPermaLink="false">USA-New-York-Take-5-2011-08-27</guid>
                 </item>



How could I output those to varibles?

thanks

Joe

Hey guys i have a array i made and im wanting to grab a random value out of the array.
The only way i can see to do this looking at the list of array functions is i need to random a key first?
and then return the value assigned to the random key i just generated?
I only see a function that lets me do the opposite. array_search()

so now that i have generated a random key how do I grab just the value from the array using the random key. or is there a function i can just random value?

$explode_names = explode(" ", $planet_names);

$random_key_name = (array_rand($explode_names, 1));


echo $random_key_name;

I usually only do design work, but a client wanted a log in system to his website, so I decided to do it.

I set everything up correctly, and users can sign up, login, and log out. However, he wants to be informed when a user logs into his site.

So say (user x) wants logs in, my client wants to receive an email with all of (user x)'s account information. How do I pull a row from mysql based on the login information provided?

My database is has 7 columns: user, pass, name, address, state, phone, email

I'm *attempting* to write a script that will take a paste of data from a user and when it's submitted it will drop certain parts of the data into databases and be available for recall later. I have the MySQL sorta out I think but I can't test until I get this part done.

Basically people will paste a copied paste (CTRL A, CTRL C and go to my form and just hit CTRL V). It will contain a bunch of data I want to drop in the database but in different areas, like the following example the items in bold are the items I want to grab.

First Name: Lincoln
Last Name: Coe
Address: 1234 Easy St, Perfectville, PV 00000
Telephone: 0000000000

Hi there

I need to extract data from some XML. I have found a few sites that explain that part to me, however there is a section of the data which I need to extract and am not sure how to go about it. Below is an extract of the XML, the section I am trying to extract is highlighted in red (it is essentially a text message being sent I am trying to get the contents of the sms/text message):

 <usa_smpp_host>THTTP</usa_smpp_host>
 <short_message>id:660352946 sub:001 dlvrd:001 submit date:1102081032 done date:1102081035 stat:DELIVRD err:000 text:Test SMS message</short_message>
 <dest_addr_npi>1</dest_addr_npi>

Any assistance would be appreciated. Have played around quite a bit but have not managed to figure it out yet.

thanks

HI guys,

I'm quite new to php, and I'm really struggling to get this right. I just cant get it to work properly.

Im trying to extract email from a list of URLS. I have currently got it to work with 1 URL at a time, but I am needing to as to how I can pass multiple URLS at once, either from a csv or just pasting them into the input.
any help would be much appriciated. here is my current code:

Quote

<?php



$the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : '';
?>

<form method="post">
  Please enter full URL of the page to parse (including http://):<br />
  <textarea name="url" cols="100" rows="10"><?php echo $the_url;  ?></textarea>
  <br />

  <input type="submit" value="Get Emails" />
</form>

<?php
if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) {
  // fetch data from specified url
  $text = file_get_contents($_REQUEST['url']);
}
elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) {
  // get text from text area
  $text = $_REQUEST['text'];
}

// parse emails
if (!empty($text)) {
  $res = preg_match_all(
    "/[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}/i",
    $text,
    $matches
  );

  if ($res) {
    foreach(array_unique($matches[0]) as $email) {
      echo $email . "<br />";
    }
  }
  else {
    echo "No emails found.";
  }
}

?>

Hi, not sure if this is posted in the right place (think it should be in the Regex section  ) but hopefully someone can help me out a bit.

I have the following string for example which is stored in a variable called $var.

Quote

This is a reference [ref=17][/ref] number


I wish to extract only the number after the equals sign and store it as a variable. So I am using the following code to do so:

$ref_num = preg_replace("/.*?\[ref\=(.*?)\]\[\/ref\].*?/is", "$1", $var);

The only problem is, I can omit the text before the integer and the tags themselves but I still get the text after the [/ref] section and I cannot get rid of it. It seems my .*? placed after it doesn't work like it does at the beginning.

Can anyone offer any help at all, it will be greatly appreciated - I'm fairly new to using Preg_replace so I still don't know how best to form Regular Expressions.

Thanks, Dan


EDIT-
I have found a workaround which I will post below - however I would still like to solve it the way I planned originally which is the way I posted here. Here's what I did - because I know the integer is never going to be more than 5 characters long, I used the replace from before but added a substring like so.

$ref = substr(preg_replace("/.*?\[ref\=(.*?)\]\[\/ref\]/is", "$1", $var),0,5);

This grabbed the first 5 characters whether it was a number or not, then I used this to strip any non-numerical characters. Finally I added an intval to convert it to an integer rather than a string.

$ref = intval(preg_replace ('/[^\d\s]/', '', $ref));