[php+rss] <content:encoded> parsen

[ilovetechno]

Ik heb een script om bepaalde info uit een RSS feeds naar MySQL te schrijven. Nu lukt het me iet om de <content:encoded> te parser.

Het script:

PHP:

<?php

$connection = mysql_connect("x",
                            "x_x",
                            "x");
mysql_select_db("x", $connection);

$counter = 0;
$type = 0;
$tag = "";
$itemInfo = array();
$channelInfo = array();
function unhtmlspecialchars( $string )
    {
        $string = str_replace ( '&amp;', '&', $string );
        $string = str_replace ( ''', '\'', $string );
        $string = str_replace ( '&quot;', '\"', $string );
        $string = str_replace ( '&lt;', '<', $string );
        $string = str_replace ( '&gt;', '>', $string );
        
        return $string;
    }

function opening_element($xmlParser, $name, $attribute){


global $tag, $type;

$tag = $name;

if($name == "CHANNEL"){
$type = 1;
}
else if($name == "ITEM"){
$type = 2;
}

}//end opening element

function closing_element($xmlParser, $name){

global $tag, $type, $counter;

$tag = "";
if($name == "ITEM"){
$type = 0;
$counter++;
}
else if($name == "CHANNEL"){
$type = 0;
}
}//end closing_element

function c_data($xmlParser, $data){

global $tag, $type, $channelInfo, $itemInfo, $counter;

$data = trim(htmlspecialchars($data));

if($tag == "TITLE" || $tag == "DESCRIPTION" || $tag == "THUMB" || $tag == "LINK"){
if($type == 1){

$channelInfo[strtolower($tag)] = $data;

}//end checking channel
else if($type == 2){

$itemInfo[$counter][strtolower($tag)] .= $data;

}//end checking for item
}//end checking tag
}//end cdata funct

$xmlParser = xml_parser_create();

xml_parser_set_option($xmlParser, XML_OPTION_CASE_FOLDING, TRUE);
xml_parser_set_option($xmlParser, XML_OPTION_SKIP_WHITE, TRUE);

xml_set_element_handler($xmlParser, "opening_element", "closing_element");
xml_set_character_data_handler($xmlParser, "c_data");

$fp = file($_GET['rss']);

foreach($fp as $line){
if(!xml_parse($xmlParser, $line)){
die("Could not parse file.");
}
}

foreach($itemInfo as $items){
    $query = mysql_query("SELECT * FROM stories WHERE title = '".htmlentities($items['title'],
          ENT_QUOTES)."'") or die(mysql_error());
    $num = mysql_num_rows($query);
    if($num > 0){
        echo $items['title']." already exists!<br />";
    }
    else {
        $items2['description'] = unhtmlspecialchars ($items['description']);
        

        if (mysql_query("INSERT INTO stories VALUES('', '".htmlentities($items['title'], 
                 ENT_QUOTES)."', '".htmlentities($items2['description'], ENT_QUOTES)."', 
                  '".htmlentities($items['link'],ENT_QUOTES)."')") or die(mysql_error())){
        echo $items['title']." was added!<br />";
        }
    }
}

?>

Is er iemand die mij een beetje op weg kan helpen ?

[RobIII]

Het is in PRG niet de bedoeling dat je een topicstart maakt van 2 regels en dan 100+ regels code dumpt; we verwachten van jezelf ook wat inzet zoals je dat kunt lezen in onze Programming Beleid Quickstart. Daarnaast is dit gewoon een quickfix en daar doen we hier niet aan.

Je bent van harte welkom met een nieuw topic, maar hou dan de quickstart in acht.