Environment:
Linux,Java,Apache,PHP (AMAZON EC2)

It should run in Linux CRON. If the modified date in the website_profile table is more than 24 hrs from current time then that particular URL must be fetched and the same should be executed.

CREATE TABLE `website_profile` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(1024) NOT NULL default ,
`modified_date` varchar(20) NOT NULL default 1970-01-01,
PRIMARY KEY (`id`)
);

insert into website_profile(url) values(http://www.mac-spyware.com);
insert into website_profile(url) values(http://www.jawaharprasad.com);

CREATE TABLE `website_score` (
`sid` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL,
`url` varchar(1024) NOT NULL default ,
`page_title` varchar(255) default ,
`page_keywords` varchar(1024) default ,
`onpage_score` decimal(12,2),
`modified_date` varchar(20) NOT NULL default 1970-01-01,
PRIMARY KEY (`sid`)
);

DATA OUTPUT EXPECTED IN website_score table:

`id`: The id from the id field in `website_profile` table (id of the Main Site URL)
`url`: Sub pages of the main site
`page_title`: The content between the READ_CONTENT_FROM_HERE – Strip the length to max 255 characters.
`page_keywords`: – Strip the length to max 1024 characters. If there is no META KEYWORDS tag, generate top keywords (1 word keyword, 2 word phrase, 3 word phrase) – 2 keywords from each and update it in the table.
`onpage_score`: The java code should then send the `url, `page_keywords` to a Web URL API (example: http://www.xxxxx.com/api.php) through POST and it returns the XML file with the score of say, 95.6 . Insert this score into the field. Assume any XML output and later it can be changed.

Id | URL | Page_Title | Page_Keywords
1 | http://www.example1.com/ | Title here | keyword 1,kw 2
1 | http://example1.com/abc.shtml | Title here| keyword 1,kw 2
…
….
….
….
2 | http://www.example2.com/ | Title here |
2 | http://www.example2.com/about/ | Title Here |

Tags: can check duplicate keywords, can meta title tag change dynamically, check competitive keywords, check please script, com, default, meta site service provider, null, play check please copy script, sample meta discription tag, seo check position keywords php script, table, title, url, varchar, vietnamese translate check please, vietnamese words check please