icode919 Posted May 6, 2013 Share Posted May 6, 2013 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.. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/ Share on other sites More sharing options...
icode919 Posted May 6, 2013 Author Share Posted May 6, 2013 seriously no reply ?? please don't disappoint me guys ! i hope a reply from any of PhPFreak here.. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428585 Share on other sites More sharing options...
Jessica Posted May 6, 2013 Share Posted May 6, 2013 Sites like that will have an API. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428587 Share on other sites More sharing options...
trq Posted May 6, 2013 Share Posted May 6, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428592 Share on other sites More sharing options...
icode919 Posted May 6, 2013 Author Share Posted May 6, 2013 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428593 Share on other sites More sharing options...
Jessica Posted May 6, 2013 Share Posted May 6, 2013 The same way you would save any other data to a database. What database engine do you want to use? Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428594 Share on other sites More sharing options...
icode919 Posted May 6, 2013 Author Share Posted May 6, 2013 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 ??? Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428598 Share on other sites More sharing options...
trq Posted May 6, 2013 Share Posted May 6, 2013 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? Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428601 Share on other sites More sharing options...
icode919 Posted May 6, 2013 Author Share Posted May 6, 2013 (edited) 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 Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428604 Share on other sites More sharing options...
trq Posted May 6, 2013 Share Posted May 6, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428606 Share on other sites More sharing options...
icode919 Posted May 6, 2013 Author Share Posted May 6, 2013 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428608 Share on other sites More sharing options...
trq Posted May 6, 2013 Share Posted May 6, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428612 Share on other sites More sharing options...
icode919 Posted May 7, 2013 Author Share Posted May 7, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/277702-social-networking-sites-data-database-storage/#findComment-1428779 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.