exclude keywords from RSS search

[google]

I have a script which parses the BBC RSS feed once an hour, and drops
any stories with certain keywords into a database. I would like to ban
certain strings; at the moment the script will pick up the word "train"
but also "training"; this is giving me a lot of false positives. Can
anyone assist? I tried a couple of things but nothing that works.

Script is as follows:

<?php

$keywords = array("keyword1 ", "keyword2", "keyword3") ;
$bannedwords = array("bannedwo rd1", "bannedword 2", "bannedword 3");
$feedsource =
"http://news.bbc.co.uk/rss/newsonline_uk_e dition/uk/rss091.xml";

$db = mysql_connect(" localhost","use rname","passwor d") or
die(mysql_error ());
mysql_select_db ("database") ;

$insideitem = FALSE;
$tag = "";
$title = "";
$description = "";
$textdump = "";
$link = "";
$itemcount = FALSE;
$body1 = "";

function startElement($p arser, $name, $attrs) {
global $insideitem, $tag, $title, $description, $link;
if ($insideitem) {
$tag = $name;
} elseif ($name == "ITEM") {
$insideitem = TRUE;
}
}

function endElement($par ser, $name) {
global $insideitem, $tag, $title, $description, $link, $keywords;
$numkeywords = count($keywords );
$duplicate = FALSE;

if ($name == "ITEM") {
for($counter1=0 ; $counter1 < $numkeywords; $counter1++) {
if(stristr($tit le, $keywords[$counter1]) || strstr($descrip tion,
$keywords[$counter1])) {
$sql = "select * from tblRSSfeed";
$result = mysql_query($sq l) or die(mysql_error ());
while ($row = mysql_fetch_arr ay($result)) {
if($row[txtLink] == trim($link)) {
$duplicate = TRUE;
}
}
if($duplicate == FALSE) {
$itemcount = TRUE;
$datetime = date("Y-m-d H:i:s");
$title = trim(str_replac e("'", "\'", $title));
$description = trim(str_replac e("'", "\'", $description));
$link = trim($link);
$sql = "INSERT INTO tblRSSfeed VALUES(NULL, '$title',
'$description', '$link', '$datetime')";
mysql_query($sq l) or die(mysql_error ());
} else {
$duplicate = FALSE;
}
}
}
$title = "";
$description = "";
$link = "";
$insideitem = FALSE;
}
}

function characterData($ parser, $data) {
global $insideitem, $tag, $title, $description, $link;
if ($insideitem) {
switch ($tag) {
case "TITLE":
$title .= $data;
break;
case "DESCRIPTIO N":
$description .= $data;

break;
case "LINK":
$link .= $data;
break;
}
}
}

$xml_parser = xml_parser_crea te();
xml_set_element _handler($xml_p arser, "startEleme nt", "endElement ");
xml_set_charact er_data_handler ($xml_parser, "characterData" );
$fp = fopen("$feedsou rce","r") or die("Error reading RSS data.");
while ($data = fread($fp, 4096)) {
xml_parse($xml_ parser, $data, feof($fp)) or die(sprintf("XM L error: %s
at line %d", xml_error_strin g(xml_get_error _code($xml_pars er)),
xml_get_current _line_number($x ml_parser)));
}
fclose($fp);
xml_parser_free ($xml_parser);

?>

[Michael Phipps]

>I have a script which parses the BBC RSS feed once an hour, and drops

any stories with certain keywords into a database. I would like to ban
certain strings; at the moment the script will pick up the word "train"
but also "training"; this is giving me a lot of false positives. Can
anyone assist? I tried a couple of things but nothing that works.

Have you tried a regular expression? I had a quick glance at your code, but
couldn't see any.

PHP Manual: http://au3.php.net/regex

Michael

[GazK]

No, there is none at the moment. I must admit that, apart from an email
address checking script which I got from a tutorial site, I have
avoided regex because of its infamous complexity, but I guess an
expression for this wouldnt be that hard. I will give it a go.