Hi,
I have YahooBoss search result XML pages that I call with an URL like this:
[login to view URL]
Result format will be like this: [login to view URL]
I want, when I run that XML url, SOME items to be inserted in my database, this way:
<abstract> ---> to be inserted as plain text in "desc_itm" field on table.
<title> ---> to be inserted as plain text in "title_itm" field.
<terms> ---> to be inserted in "keyterms_itm" field, comma separated.
<url> ---> to be inserted in "url_itm" field.
<size> --> to be inserted in "size_itm" field.
Notice that url_itm is UNIQUE in database. So, the INSERT should only UPDATED that record if it already exist or Skip insertion.
Here I paste the real table dump
CREATE TABLE IF NOT EXISTS `item_itm` (
`title_itm` varchar(200) NOT NULL,
`desc_itm` varchar(255) NOT NULL,
`url_itm` varchar(1000) NOT NULL,
`keyword_itm` varchar(200) NOT NULL,
`id_itm` int(10) unsigned NOT NULL auto_increment,
`views_itm` int(11) NOT NULL,
`size_itm` int(11) NOT NULL,
`keyterms_itm` varchar(255) NOT NULL,
PRIMARY KEY (`id_itm`),
UNIQUE KEY `url_itm` (`url_itm`),
KEY `id_itm` (`id_itm`),
KEY `idxname` (`keyword_itm`),
FULLTEXT KEY `idxitname` (`title_itm`),
FULLTEXT KEY `idxdesc` (`desc_itm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
I offer up to $40 for this work. Please bid only if you can start right now.