PHP - Count Facebook Shares And Display In A Text Form?

I would like to pull in Facebook reviews from my Facebook page and display them on a page on my website but am new to doing that so just seeing if there is any sample code I can get from somewhere to have a look at please?

I have got a page access token from Facebook developers but unsure what the coding would be like to pull the reviews in

I have a mysql table that holds data for cars - each car has it's own ID, name, and year. Some cars are repeated.

Example: (ID - year - car name)
0001 - 2009 - Honda Civic
0002 - 2008 - Toyota Prius
0003 - 2009 - Honda Civic
0004 - 2008 - Toyota Prius
0005 - 2008 - Toyota Prius
0006 - 2007 - Honda Civic

How would I count how many of the same type of cars I have in that table and then display the quantity next to the car name? Like for the above example it would be:

2009 Honda Civic: 2
2007 Honda Civic: 1
2008 Toyota Prius: 3

Thanks in advance for any help  :D

I made the basic function to count the number of left count and right count. However now i need to display then number of additions to a tree according to their joining date. I stuck here. can someone please show me the logic to do this ?

I know i need to use UNION for sql because date of joining and tree structure are in different tables.

Sql tables-

Member table -(doj is date of join)


Tree table-


Basic Code-
Code: [Select]
<?php 
function tree_count($node)   //Function to calculate count;$node is first lchild or first rchild.
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'" ;
 // $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'             should i do something like this ?
 //           UNION SELECT member_id FROM member WHERE id_sponsor=".$node." AND doj BETWEEN '".$from."' AND '".$to."'" ;
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count += tree_count($array['lchild']);
      
    } 
    if(!empty($array['rchild']))
    {
       $count += tree_count($array['rchild']);
       
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }  
?>

Hello,

Have a question that i hope some one can help me answer.

I have started creating a facebook app that will translate lovepoems.

The problem im having is that facebook redirects everything wrong, which makes my life a living hell. So what i thought is it's possible to while submitting the form and the user gets redirected to the facebook allow app page, wait with submitting the form or maybe bring the post id with me and then post the content to the db liked to the post from a different page.

simply so i don't have to make the accept form and then go to the actual content?


So I'm using Wordpress as default CMS system if that helps.

This is the code.

Code: [Select]
<?php
/*
Template Name: Febuary Love testing app 
*/
?>

<SCRIPT LANGUAGE="JavaScript">
<!-- Original:  Wayne Nolting (w.nolting@home.com) -->

<!-- This script and many more are available free online at -->
<!-- The JavaScript Source!! http://javascript.internet.com -->

<!-- Begin
function verify() {
var themessage = "You are required to complete the following fields: ";
if (document.form.title.value=="") {
themessage = themessage + " - Title";
}
if (document.form.description.value=="") {
themessage = themessage + " -  Poem";
}
if (document.form.post_tags.value=="") {
themessage = themessage + " -  Keywords";
}
//alert if fields are empty and cancel form submit
if (themessage == "You are required to complete the following fields: ") {
document.form.submit();
}
else {
alert(themessage);
return false;
   }
}
//  End -->
</script>

<?php
add_filter('fb_php_sdk_load','your_filter');
function your_filter($array)
{
    $array[] = '2.1.2'; //exact version number you need
    return $array;
}

$facebook = new Facebook(array(
'appId' => '179200268852090',
'secret' => '3b62bc6b207e4038aa56a28bfc5ed368',
'cookie' => true,  

));

$session = $facebook->getUser();

if (!empty($session))
{
try{
$user = $facebook->getUser();
$user = $facebook->api('/me');
}
catch (Exception $e){
}


if (!empty($user))
{
 
}
else
die ("An error occured");
}
else{
$loginUrl = $facebook->getLoginUrl(array(
    'canvas' => 1,
    'fbconnect' => 0,
    'scope' => 'offline_access, publish_stream'
));
echo "<a href='".$loginUrl."'>Click </a> to add the Copypanther Facebook application";
} 
?>

<?php
$user = $facebook->getUser();
if($user){
    $access_token = $facebook->getAccessToken();

}
?>


<?php
if( 'POST' == $_SERVER['REQUEST_METHOD'] && !empty( $_POST['action'] ) &&  $_POST['action'] == "new_post") {

// Do some minor form validation to make sure there is content
if (isset ($_POST['title'])) {
$title =  $_POST['title'];
} else {
echo 'Please enter the Poem name';
}
if (isset ($_POST['description'])) {
$description = $_POST['description'];
} else {
echo 'Please enter some notes';
}

$tags = $_POST['post_tags'];
$access_token = $_POST['access_token'];
$user = $_POST['user'];

// ADD THE FORM INPUT TO $new_post ARRAY
$new_post = array(
'post_title' => $title,
'post_content' => $description,
'post_category' => array($_POST['cat']),  // Usable for custom taxonomies too
'tags_input' => array($tags),
'post_status' => 'draft',           // Choose: publish, preview, future, draft, etc.
'post_type' => 'post',  //'post',page' or use a custom post type if you want to
'access_token' => $access_token,
'user' => $user,
);

//SAVE THE POST
$pid = wp_insert_post($new_post);
add_post_meta($pid, 'access_token', $access_token, true);
add_post_meta($pid, 'user', $user, true);

    //SET OUR TAGS UP PROPERLY
wp_set_post_tags($pid, $_POST['post_tags']);

//REDIRECT TO THE NEW POST ON SAVE
$link = get_permalink( $pid );
wp_redirect('http://www.ngee.se');

} // END THE IF STATEMENT THAT STARTED THE WHOLE FORM

//POST THE POST YO
do_action('wp_insert_post', 'wp_insert_post');

get_header(); ?>


<?php if ( have_posts() ) while ( have_posts() ) : the_post(); ?>


                    <div class="form-content">
                        <?php the_content(); ?>

<!-- WINE RATING FORM -->

<div class="wpcf7">
<h2>Share some February Love!</h2>
<p>Although the 14th of February might and should be dedicated to your loved one, we think that friends, bosses and coworkers deserve some affection, too. So between the 1st and 13th of February we will translate a poem or message from you to them <em>for free</em></p>
<form id="new_post" name="new_post" method="post" action="" class="wpcf7-form" enctype="multipart/form-data">
<!-- post name -->
<fieldset name="name">
<label for="title">Love poem name:</label>
<input type="text" id="title" value="" tabindex="5" name="title" />
</fieldset>

<!-- post Category -->
<fieldset class="category">
<label for="cat">Translate to:</label>
<?php wp_dropdown_categories( 'tab_index=10&taxonomy=category&hide_empty=0' ); ?>
</fieldset>

<!-- post Content -->
<fieldset class="content">
<label for="description">Love poem:</label>
<textarea id="description" tabindex="15" name="description" cols="80" rows="10"></textarea>
</fieldset>

<!-- post tags -->
<fieldset class="tags">
<label for="post_tags">Keywords (comma separated):</label>
<input type="text" value="" tabindex="35" name="post_tags" id="post_tags" />
</fieldset>
<SCRIPT LANGUAGE="JavaScript">
function testResults (form) {
var TestVar = form.submit();
}
</SCRIPT>
<fieldset class="submit">
<input type=button value="Send" value="Send" tabindex="40" id="submit" name="submit" onclick="verify();">
</fieldset>

<fieldset class="access_token">
<label for="access_token"></label>
<input type="text" value="<?php echo $access_token;?>" id="access_token" name="access_token"/>
</feildset>

<fieldset class="user">
<label for="user"></label>
<input type="text" value="<?php echo $user;?>" id="user" name="user" />
</feildset>

<input type="hidden" name="action" value="new_post" />
<?php wp_nonce_field( 'new-post' ); ?>
</form>
</div> <!-- END WPCF7 -->

                        <?php wp_link_pages( array( 'before' => '<div class="page-link">' . __( 'Pages:', 'twentyten' ), 'after' => '</div>' ) ); ?>
                        <?php edit_post_link( __( 'Edit', 'twentyten' ), '<span class="edit-link">', '</span>' ); ?>
                    </div><!-- .entry-content -->
                </div><!-- #post-## -->

<?php endwhile; // end of the loop. ?>

<?php get_footer(); ?>

Any one have any idea about how i can solve this problem ?

Answers most appreciated!

Best Regards
GrundeLL


EDIT ***

I'm using facebook PHP SDK

I want to write a guessing game that gives a user four tries to guess a number between 1 and 10.
The problem is that every time the user hits submit, count is reset to zero and 1 is added. Please help.
Here is my code:

<html>
<head>
<title>Guessing Game </title>
</head>
<h1>Guessing Game </h1>
   <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   <input type="hidden" name="count" value="<?php $count++; ?>" />
   <p><input type="text" name="guess" /></p>
   <p><input type="submit" value="Guess" /></p>
   </form>
   
</body>
</html>   

<?php
   
   $random = rand(1,10);
   $guess = $_POST['guess'];
      
   if ($guess >= 10)
   {
      echo"Guess has to be lower than 10";
   }
   elseif  (isset($guess) && ($guess <= 1))
   {
      echo "Guess has to be higher than 1";
   }
   else
   {
                  
         if ($guess == $random)
         {
            echo "Congratulations. You Win!!!!";
            $count = 4;
            
         }
         elseif (isset($guess) && ($guess != $random))
         {
            echo "Try again";
         
                  
            $count++;
            
         }
         elseif (($count == 4) && ($guess != $random))
         {
            echo "Game Over. You Lose!!!";
         }
         
      }
   
   
?>