Forum d'entraide PHPFrance

Bonjour,

Quand j'utilise l'API facebook avec foreach pour poster un message sur plusieurs murs, le foreach ne marchent pas tant que le code de l'envoi est au sein de la boucle, une fois je le mets ailleurs, le code marche bien:

// selectionner tous les utilisateurs
$select_Afb = 'SELECT user_id, account_type, access_token FROM fb_users';
// code

// recuperer leurs donnees
foreach($result_Afb as $Akey=>$Aval)
        {        
            $user_id = $Aval['user_id'];
            $account_type = $Aval['account_type'];
            $access_token = $Aval['access_token'];
         
echo $user_id.'<br />';
// du code
$facebook->api('/'.$user_id.'/feed', 'post', $attachments);
} // end foreach

l'echo sur user_id affiche un seul, alors que j'ai 3, quand je mets $facebook->api() en dehors de foreach(), il affiche tous les user_id, merci si vous avez une idee sur ca

salut,


peux tu poster le code complet (c'est à dire les lignes qui manque entre la construction de la requête et le foreach) ?

a priori il n'y a pas de raison pour que le user_id ne chance pas.

@+

voici le code complet:

<?php

include 'facebookLib.php';
include 'config.php';

// get application appID and appSecret
  $config = array(
    'appId' => $AppID,
    'secret' => $AppSec,
  );

  // initiate facebook config
$facebook = new Facebook($config);

$sqlPost = 'SELECT * FROM fb_posts WHERE action = "0" ORDER BY p_id ASC LIMIT 1';
//echo $sqlPost;
$reqPost = $connexion->query($sqlPost); 
$resultPost = $reqPost->fetchAll();
$total_comPost = count($resultPost);

    // check if anything to post
	if($total_comPost)
	{
        foreach($resultPost as $kPost=>$vPost)
        {
          $p_id = $vPost['p_id'];
          $p_type = $vPost['p_type'];
          $p_message = $vPost['p_message'];
          $p_title = $vPost['p_title'];
          $p_description = $vPost['p_description'];
          $p_caption = $vPost['p_caption'];
          $p_picture = $vPost['p_picture'];
          $p_link = $vPost['p_link'];
          
        } // end foreach($resultPost as $kPost=>$vPost)
        
        // select all users to post to
        $select_Afb = 'SELECT user_id, account_type, access_token FROM fb_users';
        //echo $select_Afb.'<br />';
        $req_Afb = $connexion->query($select_Afb);
        $result_Afb = $req_Afb->fetchAll();
        $total_Afb = count($result_Afb);
        //echo $total_Afb.'<br />';
        
        
        foreach($result_Afb as $Akey=>$Aval)
        {        
            $user_id = $Aval['user_id'];
            $account_type = $Aval['account_type'];
            $access_token = $Aval['access_token'];
            
            // if it is a page
            if($account_type == 2) // we need to add access_token
            {
                $attachments = array(
                'access_token' => $access_token,
                'type' => $p_type,
                'message' => $p_message,
                'name' => $p_title,
                'description' => $p_description,
                'caption' => $p_caption,
                'picture' => $p_picture,
                'link' => $p_link,
        
                );
            }
            else
            { // normal user
                $attachments = array(
                'type' => $p_type,
                'message' => $p_message,
                'name' => $p_title,
                'description' => $p_description,
                'caption' => $p_caption,
                'picture' => $p_picture,
                'link' => $p_link,
                );
            } // end if($account_type == 2)
            
            
    $ret_obj = $facebook->api('/'.$user_id.'/feed', 'post', $attachments);
    $facebook->api('/'.$user_id.'/feed', 'post', $attachments);
            
    } // end foreach($result_Afb as $key=>$val)
      
  } // end if($total_comPost)

?>