Function in a Function?

[szym9341]

I am working through some internet examples and was wondering how to get the below script to work... I can get the example to work just fine when separated. Please help...

This give me an error: Call to a member function on a non-object

function process_data($values){
$sql = "INSERT INTO tb_activities SET activity = '".$values["activity"]."'";
    if ($result = $connector->query($insertQuery)){
      echo '<center><b>Activity has been added to the database!</b></center><br>';
    }else{
      exit('<center>Sorry, there was an error saving the Activity to the database</center>');
    }
}

This works fine:

function process_data($values){
$sql = "INSERT INTO tb_activities SET activity = '".$values["activity"]."'";
$result = mysql_query($sql);
    if (!$result) {    

        error('A database error occurred in processing your '.
              'submission.\\nIf this error persists, please '.
              'contact [email][e-mail][/email].');
    }  else {
    echo "You did it!";
    }
}

This works fine when not in the process function:

$sql = "INSERT INTO tb_activities SET activity = '".$values["activity"]."'";
    if ($result = $connector->query($insertQuery)){
      echo '<center><b>Activity has been added to the database!</b></center><br>';
    }else{
      exit('<center>Sorry, there was an error saving the Activity to the database</center>');
    }

[eoghain]

It is an issue of scoping. When you enter a function you get a whole new clean scope to work in. In your first example you are trying to access a variable that is in the global scope inside of a function scope.

Here is an example of scoping:

<?php
   $a = 'This is $a in global scope';

   function printA()
   {
      $a = 'This is $a in function scope';
      print $a . "<br> \n";
   }

   function printGlobalA()
   {
      global $a;
      print $a . "<br>\n";
   }

   print $a . "<br>\n";
   printA();
   printGlobalA();
?>

That code when run will output:

This is $a in global scope
This is $a in function scope
This is $a in global scope

To make your code work you just need to add global $connector; to your process_data function.