Hi all,
i am completely new with xml feeds. I create some adultsites and i like to use the magicparser with the affiliate xml feeds. This is one xml feed: {link saved} .
Can someone explane how to work with this so it;s visible on my website?
second question: how to use this all in mysql?
Maybe someone want to help me to setup one feed, if nessecary i like to pay for it!!
regards,
Chris
Hi david,
Tnx for your answer!!
I try to read about MySql but it's most in english. my english is good enough to read the language but the technical things are difficult.
I have an administration tool , it's phpmyadmin serverversion: 5.0.15 .
The feeds are updated and i like to show them on my website(s). I don't know if it's possible to save the feed in the database and when there's no new news that the old news is randomly showed on the website?
I'm going to try what you described above and let you know!
Cheers,
Chris
Hi Chris,
No problem - let me know how you get on just reading the feed, then if you want I will try and help with your MySQL code.
Cheers,
David.
Hi David,
I tested it and yes this is the url: {link saved} it works now.
I want include the "testing.php" in my .html pages with the the other info from the xml-feed.
It would be great if you want to help me with the mysql code, here is some code to connect to a NEW dbase:
------------------
{code saved}
------------------
If you need more details please let me know,
Regards,
Chris
Hi David,
Did you receive the latest message with the mysql info?
regards,
Chris
Hi Chris,
Yes - thanks for that. I did try to email you regarding this but maybe you are not receiving email to the address registered on the forum...
Can you send one to me (reply to your reg code email is the easiest way) and i'll pick it up from there...
Cheers,
David.
Hi David,
I just replyed to you with my reg code email,
cheers,
Chris
Thanks, Chris - i'll follow up by email shortly....
Cheers,
David.
Hello Chris,
Thank you for your interest in Magic Parser. The script can easily process the XML from the feed in your email. Here is an example, basic script that would display the title (titel) and description (verhaal) for each record in that feed:
<?php
header("Content-Type: text/html; charset=iso-8859-1");
require("MagicParser.php");
function myRecordHandler($record)
{
print "<h1>".$record["TITEL"]."</h1>";
print "<p>".$record["VERHAAL"]."</p>";
}
$url = "{link saved}";
MagicParser_parse($url,"myRecordHandler","xml|FEED/EPISODE/")
?>
(replace {link saved} with the URL you posted in your original message)
How you would go about loading this in MySQL and then displaying the results on your website depends mostly on how you want to present the information. Have you done any MySQL development work before? Do you have an administration tool available to you, for example phpMyAdmin where you can create databases and tables for PHP to use?
Cheers,
David.