write xml in mysql and read from mysql

YPLauraSJackCJ

New Member
I have some issues about xml - phpMyAdmin(mysql).In my site i have a form filling an rss link from another web site, a category(int) and subcategory(int). First 1) i want to add in my database the contents of xml of the rss! I want to do this because rss refresh is about 10 minutes.. So, if a user want to read this rss, a want to take the contents from rss through this, and not read the rss from the other web site. (like a cash memory). I did something like this:\[code\]$string = $_POST['linkrss'];$xml = simplexml_load_file($string);foreach($xml->channel->item as $entry){$stringData = http://stackoverflow.com/questions/10863453/$entry->title."\n";$string .= $stringData;$stringData = http://stackoverflow.com/questions/10863453/$entry->link."\n";$string .= $stringData;}\[/code\]and insert $string in my database..The second problem is 2) how can i read these contents? Because i see that the tags from xml does not exist..I am new in RSS and xml and could not find a clear answer!I want to solve these problems without javascript or any other open source prog. Better with php, if it can be done! Thanks a lot for your time, and please help! If there is something i did not tell for my mistake ask for details!
 
Back
Top