Grabb data from Facebook - create a script php script
Budget: $30 – $250 USD
This script has to read url in table called "primary"
And if less then 450 friends in facebook
Then record in table "secondary" this value
# Nom Type Interclassement Attributs Null Valeur par défaut Commentaires Extra
1 id int(200) Non Aucun(e) AUTO_INCREMENT
2 id_url int(200) Non Aucun(e)
3 howmanyfriends int(200) Non Aucun(e)
4 url_friend varchar(220) utf8_general_ci Non Aucun(e)
5 name varchar(200) utf8_general_ci Non Aucun(e)
6 Score = 1 for all int(200) Non Aucun(e)
7 Picture_name varchar(200) utf8_general_ci Non Aucun(e)
8 Pourcentage =empty now int(200) Non Aucun(e)
There is some firends who arrive more then one time but writte it in more then one line
- Step 2
An other script …
Will count id unique in secondaire and feed it in tertaire table
Id autoincrement
id_url unique
howmanyfriends number of friend
url_friend
name
Score = count how many occurrence of this person
Picture_name
Pourcentage = (score / howmanyfriends) x 100
And if less then 450 friends in facebook
Then record in table "secondary" this value
# Nom Type Interclassement Attributs Null Valeur par défaut Commentaires Extra
1 id int(200) Non Aucun(e) AUTO_INCREMENT
2 id_url int(200) Non Aucun(e)
3 howmanyfriends int(200) Non Aucun(e)
4 url_friend varchar(220) utf8_general_ci Non Aucun(e)
5 name varchar(200) utf8_general_ci Non Aucun(e)
6 Score = 1 for all int(200) Non Aucun(e)
7 Picture_name varchar(200) utf8_general_ci Non Aucun(e)
8 Pourcentage =empty now int(200) Non Aucun(e)
There is some firends who arrive more then one time but writte it in more then one line
- Step 2
An other script …
Will count id unique in secondaire and feed it in tertaire table
Id autoincrement
id_url unique
howmanyfriends number of friend
url_friend
name
Score = count how many occurrence of this person
Picture_name
Pourcentage = (score / howmanyfriends) x 100
Related categories:
PHP