Em Andamento

PHP application for our sites

We have a list of domains.

We look for a script who display results (Stats value, Keywords rank, PR) for each domains:

This is the list of task that the script have to do for each domains and Per month : (The script must be deal when a year is over it start to store data in a new table.)

- Get the Google Pagerank and store it in the database.

- Get the Stats visit value and the stats Pages value from a webpage, available on the web but protected by .htaccess. (I’ll give you the Url when bid has won) and store it in the database. (This page is a result from Webdruid, so it could be easy to parse it to get the right data).

- Get the rank In Google and Yahoo for each keywords and store it in the database.

The script could be split in 2 parts :

1st part : The displaying result !

In a html table it must display all domains name with them associated values : Pagerank value, keywords position, statistic values

This html table could be classified by domains, Pagerank value, keywords position, statistic values. This html table can be displayed by Month too...

A button on the page must generate a popup ( or something else)who contains a Chart (Jpgrah or Flash charts)with selected domain to compare the evolution per month.

E.g :

On the page, we've choosen 3 domains to compare. We click on a button to generate the chart and in a popup we have by default, the pagerank evolution by month.

On the chart, we can switch between the evolution of Pagerank, keywords position, statistics values for the 3 domains selected.

2nd part : the backoffice

Manage the domain name list (Add/modify, delete, View all)

Manage the keywords list (Add/modify, delete, View all)

Button to launch the script manually.

Export /import data from file.

One mysql database who contains:

Table for : Domains names, url domains, small snapshot from the main page

Table for : keywords

Table for : data à pagerank for each Domains name, per month and per Year.

Table for : data à Keywords ranks (google and Yahoo) for each keywords and per Domains name, per month and per Year.

Table for : data à stats parsed from a webpage protected by .htaccess (Visits, Pages) for each Domains name, per month and per Year.

( It’s an example for the Mysql database structure and if you think there’s a better way , don’t hesitate.)

Please feel free to ask any questions about it.

Regards

Habilidades: Processamento de dados, PHP, SEO

Ver mais: switch domain name, split page html, sites google c, ranks statistics, questions of data structure, php per, parts database example, mysql database for free, mysql database application, list of data structure, list of available domain names, google sites script, get web statistics, free pr sites, evolution of web, evolution of the web, e value, data structure questions, application of list in data structure, application of data structure in c, application of data structure, html snapshot, google classified, webpage php, statistics task

Acerca do Empregador:
( 1 comentário ) Nice, France

ID do Projeto: #129205