PHP - Php Script To Parse Xml-based Playlist

Hi all

I am currently in the process of scoping out a script and I am needing some help.

I have a mysql table, that has several rows, each with the following:

title | description | price | rss_url | delivery_cost | retailer_message | discount | total
---------------------------------------------------------------------------------------------------------------
Halo: Reach (XBOX 360) | Description text | 35.99 | http://www.easycontentunits.com/rss/54626/669/rss2.rss | On sale at Gameplay | 0 | 35.99
----------------------------------------------------------------------------------------------------------------------------------------------
Halo: Reach | Description text | 36.89 | http://www.easycontentunits.com/rss/54626/669/rss2.rss | On sale at Toys R Us | 0 | 36.89

What I need to do is the following:

Select each row and extract the rss_url Parse the rss_url and extract the above details from the rss feed If the details in the rss feed has changed, update the row If the actual rss feed item is no longer in the rss feed, delete it from the table.
So If the rss feed changes the first rows details in my db has the price field updated to 40.00, I need to update the row and the price field will change from 35.99 to say 40.00

If the row is no longer in the rss feed, then I need to delete it from the db.

Can anyone provide me a small snippet or any advice on how to go about doing this?

I can provide the code I'm using to actually insert the rows from the RSS feed if it helps?

Thanks

Hi

I'm not sure if this needs to be in the MySQL forum so bare with me.

I have small script which parses an RSS feed and inserts data into a table. This all works fine, but my problem now, is that I have another table, which has logos and when i parse the RSS, I'd like to be able to pass in the logo from the logos table into the RSS parse table.

The problem is the RSS feed are products, with different suppliers, so I need to somehow check which manufacturer it is and then insert the image_id from the images table.

I have a field in the main table, which has things like 'Available at Amazon' and 'Available at Play.com'

What I want is some kind of join/like clause, where I can check, for example the word 'Amazon' in one field and match it to the images table.

schema of both tables
rss_table
id, title, message, price, logos_id
1, iPad, Available at Apple, 400.00, BLANK_ID

logos
id, name, src
2, Apple, apple-logo.jpg

So you can see, any product that gets parsed that has is available at apple, needs to have the logos_id of 2, if that makes sense?

Below is a small snippet of my code (it isn't brilliant but works)

I just need to then need to find the corresponding image to the manufacturer

<?php

$test = $_POST['post_title'];

$articles = array();
$easy_url = $_POST["url"];

$rawFeed = file_get_contents($easy_url);
$xml = new SimpleXmlElement($rawFeed);

$channel = array();
$channel['title']       = $xml->channel->title;
$channel['link']        = $xml->channel->link;
$channel['description'] = $xml->channel->description;

foreach ($xml->channel->item as $item)
{
        $article = array();
        $article['title'] = $item->title;
        $article['link'] = $item->link;
        $article['description'] = (string) trim($item->description);

preg_match_all('/&#38;#xA3;([0-9.]+)/', $item->description, $results);
foreach ($results as $k => $v) {
}

$all = '&#38;#xA3;'.$v[0];
$price_stripped = str_replace($all, '', $item->description);
$desc = preg_match('/&#38;#xA3;([0-9.]+)/', $item->description);

preg_match_all('/~#&pound;([0-9.]+)/', $item->description, $discount);
foreach ($discount as $d => $disc) {
str_replace("~#&pound;","", $disc[0]);
}

preg_match_all('/&pound;([0-9.]+)/', $item->description, $delivery_cost);
foreach ($delivery_cost as $del => $deliv) {
}
   
preg_match_all('/\|(.*?)\./',$item->description,$match);           
        foreach ($match as $rel => $retail) {
  $retail[0] = str_replace("|","", $retail[0]);
}   

//$retail_logo = str_replace('On sale at', '', $retail[0]);

$connection = mysql_connect("localhost","root","password");
if (!$connection)
{
  die('Could not connect: ' . mysql_error());
}

$total = $v[0] + $deliv[0] - $disc[0];

mysql_select_db("db_test", $connection);

mysql_query("INSERT INTO rss (title,  price, retailer_message,  logo_id)
VALUES ('$item->title', '$price_stripped', '$retail[0]', '$logo_id')");

mysql_close($connection);

}

?>


Any help is appreciated.

Thanks

Hi there
I am having trouble with the code below
The difficulty is with this bit I think
('input type="submit"','value="Submit"')
Many thanks
Doug


<?php echo tep_draw_form('advanced_search',
tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT,
'', 'NONSSL', false),
'get') . tep_draw_hidden_field('search_in_description','1') .
tep_draw_input_field('keywords', TEXT_ENTER_KEYWORDS ,
'size="10" maxlength="30" onFocus="emptyMe()"
style="width: ' . (BOX_WIDTH-25) . 'px"'); ?>
<?php echo tep_hide_session_id() . ('input type="submit"','value="Submit"') . '</form>';?>

Hello, I am very new to both PHP and MYSQL but I am eager to learn.

What I want to do is write a PHP script that will parse an XML file and insert the results into a MYSQL database. I've read a bunch of guides online and I think I have the parser structure down. I created a parser using xml_parser_create(). As I understand it, I need to create functions to handle each of the three events, startTag, endTag, and contents. This is where I am not sure what to do. What do I need to tell these functions to do when these events are triggered? I know I need to connect to the MYSQL database at some point but I do not know when.

If anyone could point me in the right direction, I'd appreciate it.

I have a PHP script that has hyperlinks on that allow for the user to go to different pages, and I have managed to mainly get the hyperlinks to be button based ones, except on one of the pages, an error message appears, reading:

Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\congrats.php on line 58

However, I do not see what the problem is.

My congrats.php script is:

Code: [Select]
<!--Here, I am creating a header and title (for the webpage) with the use of the <head> and <title> HTML tags. The title given to the webpage is Login Details. I then am using the </title> and </head> HTML tags in order to stop the creation of the title and header of the webpage-->
<head><title>Login Details</title>
<link rel="stylesheet" type="text/css" a href="/rcm/stylesheet.css">
</head>
<!--Here, I am starting a PHP script-->
<?php
//Here, I am creating two variables called $loginname and $loginpassword that are being assigned the values of what is entered into and posted from the text box called name and the password box called pass in the loginform.php webpage
$loginname=$_POST['name'];
$loginpassword=$_POST['pass']; 
//Here, an IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginname and the $loginpassword variables is empty (i.e. the 'name' text box and the 'pass' password box on the loginform.php page are both left empty), then the echo keyword is being used to help write a string to inform the user that they have not entered in a username or a password and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script
              if (empty($loginname) && empty($loginpassword))
            {
                echo "You have not entered in a username or password";
                echo"<br><a href=\"loginform.php\">Click here to try to log in again</a>";
                exit();
                }
//Here, an elseif branch of the IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginname variable is empty (i.e. the 'name' text box on the loginform.php page is left empty), then the echo keyword is being used to help write a string to inform the user that they have not entered in a username and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script
            elseif (empty($loginname))
    {
        echo "You have not entered in a username";
        echo "<br><a href=\"loginform.php\">Click here to try to log in again</a>";
        exit();
        }
//Here, an elseif branch of the IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginpassword variable is empty (i.e. the 'pass' password box on the loginform.php page is left empty), then the echo keyword is being used to help write a string to inform the user that they have not entered in a password and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script

        elseif(empty($loginpassword))
        {
            echo "You have not entered in a password";
               echo"<br><a href=\"loginform.php\">Click here to try to log in again</a>";
   exit();
            }          

//Here, an elseif branch to the IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginname and the $loginpassword variables is incorrect (i.e. the 'name' text box and the 'pass' password box on the loginform.php page are both left incorrectly filled in), then the echo keyword is being used to help write a string to inform the user that they have not entered in a correct username and password and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script
 elseif (($loginname != "mrjones")&& ($loginpassword != "January"))
{
echo "You have entered an incorrect username and password";
echo"<br><a href=\"loginform.php\">Click here to try to log in again</a>";
exit();
    }
//Here, an elseif branch to the IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginname variable is incorrect and the value assigned to the $loginpassword variable is ccorrect (i.e. the 'name' text box on the loginform.php page was filled in incorrectly and the 'pass' password box on the loginform.php page was filled in correctly), then the echo keyword is being used to help write a string to inform the user that they have not entered in a correct username and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script
else if (($loginname !="mrjones") && ($loginpassword == "January"))
    {
        echo "You have entered in an incorrect username";
        echo"<br><a href=\"loginform.php\">Click here to try to log in again</a>";
exit();
        }
//Here, an elseif branch to the IF statement is being created and the empty keyword is being used to state that if the value assigned to the $loginname variable is incorrect and the value assigned to the $loginpassword variable is ccorrect (i.e. the 'name' text box on the loginform.php page was filled in correctly and the 'pass' password box on the loginform.php page was filled in incorrectly), then the echo keyword is being used to help write a string to inform the user that they have not entered in a correct password and a link back to the loginform.php page is provided to them to click on and the exit function with no arguments in the parameters is being used to exit the script
        elseif (($loginname =="mrjones") && ($loginpassword != "January"))
    {
        echo "You have entered in an incorrect password";
        echo"<br><a href=\"loginform.php\">Click here to try to log in again</a>";
exit();
        }
//Here, an else branch to the IF statement is being created so as to essentially state that if all of the other branches of the IF statement above are passed through, then it means that the user managed to successfully log on and the echo keyword is being used to help write a string congratulating the user that they managed to log in and a link is provided for them to log off and go back to the loginform.php page and the exit function with no arguments in the parameters is being used to exit the script
    else 
    {
echo "<h1>Log In Successful!</h1>"; 
<form action="amendfile2.php" method="post">
<input type="submit" value="Amend to file">
</form>
<form action="viewfile3.php" method="post">
<input type="submit" value="View Web Blog">
</form>
<form action="loginform.php" method="post">
<input type="submit" value="Click here to go to the Log In Screen">
</form>

        }
//Here, the PHP script is being ended
?>
Any help is appreciated!