PHP JSON Insert in the Database for each found Data

Question

I am using Facebook API to get the Facebook Pages a user administers on Facebook.

Have a look here:

https://graph.facebook.com/100000901920184/accounts/&access_token=217662841620006|20de00ae16afeb68d32319d8.1-100000901920184|BCz2UJbFylKY_eG969GlBR4loqo

What I need to do is to insert in the Database EACH Facebook Page that is found.

The DB will be structured in this way:

-ID (autoincrement)
-PageName (the name of the Page)
-PageID (the ID of the page 
-access_token (the Access Token of the Page)
-OwnerID (this is the user ID I will grab from another function I have)

So now do not mind this is for Facebook API. Just think you have those data to grab and you need to insert in the DB the above values for EACH Fan page.

This can be done with JSON but I really do not know how to grab that data, organize the Data and Insert it in the DB for Each Page.

Can you help me please?

Mihai Iorga · Accepted Answer · 2011-08-04 08:50:34Z

1

$file = json_decode(file_get_contents('https://graph.facebook.com/100000901920184/accounts/&access_token=217662841620006%7C20de00ae16afeb68d32319d8.1-100000901920184%7CBCz2UJbFylKY_eG969GlBR4loqo'));

foreach($file->data as $row){
    $query = "INSERT INTO `table`(`ID`, `PageName`, `PageID`, `access_token`, `OwnerID`) VALUES (0, '".$row->name."', '".$row->id."', '".$row->access_token."', '".getOwnerIdFunction()."')";
    // run Query;
}

answered Aug 4, 2011 at 8:50

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP JSON Insert in the Database for each found Data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related