PHP - Facebook Api Returns A Photo-related Error...

Okay, I'll make this short and sweet, and all side comments are irrelevant.  I'm doing this for my own happies


So using Facebook.com's API you can extract all of a specific user's friends in an array.  Well I'm making a array check to see who on that users friend list was removed or deleted them that week using array_dif(); in this method:

1) User allows the application
2) Application catches the user's friends_id's in an array and stores them // this is where i'm having trouble, i'll come back to it
3) User then waits a few days and notices their friend count is no longer 400, it's now 399!
4) User logs into my application, and checks the previously uploaded array against their current array of friends.

Okay now to the part i'm struggling with is, what would you do?  Should i store them each uniquely in a database? Because some users have 4,000+ friends and that gets quite strenuous.  OR! Should i save them into a txt file unique to that person's user_id.

I kind of like the 2nd option, however it's less ( to my newbish mind ) customizable versus the sql_queries. 

Once again, i'd like to reiterate, i don't care that this is again Facebooks terms of service, it's for my own personal gain and just enjoy taking on projects in my spare time that force my brain to work hard.

That's all, hope you excuse the typos and poor grammar.  Typed this pretty quickly, any questions - feel free to ask!

Hello again!

I've been trying out new things (well, new for me) in php again.  This time I decided to try a real challenge and make a forum system.  A friend suggested I use a class for all database functionalities.  i was reluctant at first, but decided if I was going to try using classes for the first time, it might as well be with this.  With some guiding help, I set up the files and gave it a visual once over to check for errors.  Nothing seemed out of place, but when I loaded the page to try it out, I got this error:

Quote

Fatal error: Call to a member function query() on a non-object in /home/ck9/public_html/planning/forumbuild/list.php on line 20



I didn't see anything out of line, so I consulted my friend about it.  He made a few small adjustment suggestions, but nothing fixed the issue.  I then bugged my host about it, and he couldn't find anything wrong either.  Both people are highly experienced in php, so when they say it SHOULD be working I am left rather confused.

Here is list.php:
Code: [Select]
<?php
 include("db.class.php");
 include("db.config.php");

 $db = new databaseConnection($config['user'],$config['pass'],$config['database']);
 $g = $_GET['g'];
 $s = $_GET['s'];
 $t = $_GET['t'];

 function tablestart($a = '1')
  {
   global $db;

   echo "<table border='" . $a . "' cellpadding='10' cellspacing='0' align='center' width='80%' style='color: #C0C0C0'>\n";
  }
 function contents($table, $a, $b = '1', $c = '1')
  {
   global $db;

   $db->query("SELECT * FROM $table");

   while($row = $db->fetch_array())
    {
     if($row['level'] <= $_SESSION['ulevel'])
      {
       echo "<tr><td width='5%'><!--indicator--></td><td width='80%'><a href='index.php?pg=h&g='" . $row['g'];
       if(($a > '1') && ($row['g'] == $b))
        {
         echo "&s=" . $row['s'];
         if(($a > '2') && ($row['s'] == $c))
          {
           echo "&t=" . $row['t'];
          }
        }
      }
     echo "' style='color: #C0C0C0 ; text-decoration: none'><font size='4'>" . $row['name'] . "</font><br /><fpnt size='3'>" . $row['desc'] . "</td><td width='15%'><!--last update--></td></tr>\n";
    }
  }

 if(empty($_SESSION['ulevel']))
  {
   $_SESSION['ulevel'] = '0';
   echo "<font color='#CC0000'><center>You need to register to post in these forums.</center></font><br />\n";
  }

 if(empty($g))
  {
   tablestart();
   contents('group', '1');
   echo "</table>\n";
  }
 elseif(empty($s))
  {
   tablestart();
   contents('section', '2', $g);
   echo "</table>\n";
  }
 elseif(empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td><!--new topic--></td></tr>\n</table>\n";
   tablestart();
   contents('topic', '3', $g, $s);
   echo "</table>\n";
  }
 elseif(!empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td><!--new topic and reply--></td></tr>\n</table>\n";
   $data = file_get_contents('topics/g' . $g . 's' . $s . 't' . $t . '.txt');
   $post = explode("<!--p-->", $data);
   $length = count($post);
   tablestart('1');
   for($z = '0'; $z < $length; $z ++)
    {
     $i = '0';
     $cont = explode("<!--e-->", $post[$pos]);
     echo "<tr><td><b>" . $cont[$i] . "</b><br /><!--future additions--></td><td>\n<table width='100%' style='font-size: xx-small'>\n<tr><td height='3' width='75%'>";
     $i ++;
     echo "Posted on" . $cont[$i] . "</td><td height='3' width='25%'><!--future additions--></td></tr><tr><td width='100%'>";
     $i ++;
     echo $cont[$i] . "</td></tr></table></td></tr>\n";
    }
   echo "</table>\n";
  }
?>
My aim here was to have a single page to display the groups, sections, topics, and posts in order to keep database calls where I could find them easily.

and here is the class file:

Code: [Select]
<?php
class databaseConnection
 {
  protected $link;
  protected $lastResult;
  function databaseConnection($user,$pass,$database)
   {
    $this->link = mysql_connect("localhost",$user,$pass);
    if( !$this->link )
     {
      die('Vital information missing.');
     }
    else
     {
      mysql_select_db($database,$this->link) or die('could not find database: ' . mysql_error());
     }
   }
  function query($query)
   {
    $this->lastresult = mysql_query($query) or die('MySQL error: ' . mysql_error());
    return $this->lastresult;
   }
  function fetch_array($result = false)
   {
    if(!$result)
     {
      return mysql_fetch_array($this->lastresult);
     }
    else
     {
      return mysql_fetch_array($result);
     }
   }
 }
?>
I have tried everything from adjusting the php tags to putting the class directly in the page.

The config file just provides the user, pass, and which database to connect to.  I've checked it's formatting a few times just in case.

not for certain this is a PHP issue, but on every page of my site, at the bottom, this error displays. Doesn't affect any of the code execution as far as I can tell, but it's annoying. Anyone else seen this?

Code: [Select]
Error in my_thread_global_end(): 1 threads didn't exit

friends if an array returns results as Array() how could i set an error message to it? i tried to do a if statement to the $variable but not working

httpd-2.2.17-win32-x86-openssl-0.9.8o
php-5.3.6-Win32-VC9-x86
mysql-5.5.11-win32

PHP code:

$dbcnx = mysql_connect('localhost','root','admin');

Error message:

No connection could be made because the target machine actively refused it.

I used mysql.exe -u root -p to verify that mysql is working and using the right username and password.

Any ideas how to fix it?

Thanks,

Richard