social networking sites data + database storage

[icode919]

hello guys,

             i am not an expert to PHP, but still..

 

Well, i want to know how to fetch public available data from social network sites like: facebook, twitter, google+ etc.

 

with help of cookies and then save them same time to database.....

 

is it possible ?

 

and if YES ! Then please guide me up.

 

Thanks a lot..   

[icode919]

seriously no reply ??

 

please don't disappoint me guys ! i hope a reply from any of PhPFreak here..

[Jessica]

Sites like that will have an API.

[trq]

Indeed. Those API's also have documentation.

 

The reason your question hasn't had a look in is because you have obviously made little effort to research the topic yourself.

 

You need to be specific about where it is exactly you are stuck.

[icode919]

ok.. let me describe more..

 

i have read nearly lot how to get details from social network sites using there API's.

 

but i don't understand how to save them to db.. got me ? i can get data if i only wanna see... but i wanna store them to db once my cookie fetch any data on the device.

 

now is that better explanation ?

[Jessica]

The same way you would save any other data to a database. What database engine do you want to use?

[icode919]

i am using PHP as coding language, and MySQL as database.

 

 

I have no experience with storing cookie data in database..

 

is it as simple as it

???

[trq]

Where are you getting the term "cookie data" from? It doesn't really make any sense in the context of this topic.

 

Anyway, do you know how to connect to and query a database? All you need do is execute an INSERT statement that stores the data you have.

 

What format is your data in?

[icode919]

data will be in format like:

 

https://graph.facebook.com/userid

  "id": "100000028881959",   "name": "username",   "first_name": "name",   "last_name": "last",   "link": "https://www.facebook.com/uid",   "username": "uid",   "gender": "male",   "locale": "en_US"

then similar for Twitter / Google+

 

that is the cookie data i am talking about..

never had experienced with storing cookie data to database..

Edited May 6, 2013 by icode919

[trq]

The data you have has nothing at all to do with cookies.

 

Anyway, I would suggest making a table that replicates this structure. From there it would be simple to write an INSERT query to store your data.

[icode919]

Yes, ok !

 

so you mean in the page we add that script which fetch these details we simply call INSERT query and save that data to db ??

 

is that how it will work ?

[trq]

so you mean in the page we add that script which fetch these details we simply call INSERT query and save that data to db ??

If I understand you correctly yes.

[icode919]

is there any tutorial out there to learn about that how to integrate Graph API and other sites API in normal PHP project and then at same time involve INSERT query to store data received in db.