Advertisement
Guest User

Untitled

a guest
Jul 30th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.99 KB | None | 0 0
  1. <?php
  2.     require_once('fb_test.php');
  3.  
  4.     define('FACEBOOK_APP_ID', 'blabla');
  5.     define('FACEBOOK_SECRET', 'blubblub');
  6.  
  7.     $facebook = new Facebook(array(
  8.       'appId'  => FACEBOOK_APP_ID,
  9.       'secret' => FACEBOOK_SECRET,
  10.       'cookie' => true,
  11.     ));
  12.  
  13.     $id = "136786223053705"; // ID der Facebook-Gruppe
  14.  
  15.     $result = $facebook->api(array(
  16.         'method' => 'fql.query',
  17.         'query' => 'select fan_count from page where page_id = '.$id.';'
  18.     ));
  19.  
  20.     $fb_fans = $result[0]['fan_count'];
  21.  
  22.     echo $fb_fans;
  23.  
  24.     $mysqlhost='adsad';
  25.     $mysqluser='asdsadasd';
  26.     $mysqlpassword='asdsadsad';
  27.     $mysqldatabase='asdsadasd';  
  28.  
  29.     $db = mysql_connect($mysqlhost, $mysqluser, $mysqlpassword);
  30.  
  31.     mysql_select_db($mysqldatabase);
  32.  
  33.     mysql_query("SET CHARACTER SET 'utf8'");
  34.  
  35.     if(!$db)
  36.         die ("db error");
  37.  
  38.     $sql = "INSERT INTO  `fb-test`.`log` (
  39.         `datetime` ,
  40.         `id` ,
  41.         `size`
  42.         )
  43.         VALUES (
  44.  
  45.         CURRENT_TIMESTAMP ,  '".$id."',  '".$fb_fans."'
  46.         );";
  47.  
  48.     mysql_query($sql);
  49.  
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement