get txt between points and store in mysql

[amit290]

How could I read a HTML document and get text between 2 points from it??

start point looks like this = <h2>Want to know more</h2>
end point looks like this = <h2>What is this course about</h2>

I want the text (html) extracted and put into a database.

Hope someone can help,

Thanks

[tserbis]

file_get_contents
preg_match
mysql_query

[Darchangel]

use what tserbis said but replace his middle step with this:

$pattern = "|$start(.*?)$end|s";
preg_match_all($pattern, $text, $matches); 

[amit290]

Thnx for the replies, but I cant figure the preg_match bit out . Can anyone do me the code so it does what I asked in the original post? please?

thnx

[loadx]

$text = '<h2>Sample</h2>';

$start = '<h2>';
$end = '</h2>';

$pattern = "|$start(.*?)$end|s";
$foo =  preg_match_all($pattern, $text, $matches); 
print_r($matches); // this is the matches array 

From the manual:

preg_match_all -- Perform a global regular expression match
Description
int preg_match_all ( string pattern, string subject, array matches [, int flags [, int offset]])


Searches subject for all matches to the regular expression given in pattern and puts them in matches in the order specified by flags.

After the first match is found, the subsequent searches are continued on from end of the last match.

flags can be a combination of the following flags (note that it doesn't make sense to use PREG_PATTERN_ORDER together with PREG_SET_ORDER):

link: http://www.php.net/preg_match_all/

[amit290]

Thnx , getting somewhere now! . When i execute the above I get output like this....

Array ( [0] => Array ( [0] => 
Course Facts
 
UCAS course codes: D400 BSc/WAg; D401 BSc/WA (with placement year)
 
Length: 3 years (4 years with placement) 
 
Entry Requirements
 
) [1] => Array ( [0] => 
UCAS course codes: D400 BSc/WAg; D401 BSc/WA (with placement year)
 
Length: 3 years (4 years with placement) 
 
) ) 

I need to just print the array of text between the start and end points.... so in this case, I would want to echo:

UCAS course codes: D400 BSc/WAg; D401 BSc/WA (with placement year)
Length: 3 years (4 years with placement)

Im not sure which array this is, or how to go about finding it. This array will need to be a string so I can insert it into database. Its there somewhere, but how do I access it? Seems like theres an array within an array.