// Put fetched actions for each POI into an associative array.
  The returned values are assigned to $$poi[actions].
  //
  // Arguments:
  // poi ; The POI handler.
  // db ; The database connection handler.
  //
  // Returns:
  // array ; An array of received actions for this POI.
  //
  function Getactions( $$poi, db ) {
  // A new table called “ACTION_Table” is created to store actions,
  // each action has a field called
  // “poiID” which shows the POI id that this action belongs to.
  // The SQL statement returns actions which have the same poiID as the
  // id of $$poi (poi[‘id’]).
          $$sql_actions = db->prepare( “ SELECT label,
          uri,
          autoTriggerRange,
          autoTriggerOnly,
          contentType,
          method,
          activityType,
          params,
          closeBiw,
          showActivity,
          activityMessage
          FROM ACTION_Table
          WHERE poiID = :id “ );
  
          // Binds the named parameter markers “:id” to the specified
          // parameter values “$$poi[‘id’]”.
          sql_actions->bindParam( ‘:id’, $$poi[‘id’], PDO::PARAM_INT );
  
          // Use PDO::execute() to execute the prepared statement sql_actions.
          
          $$sql_actions->execute();
          // Iterator for the poi[“actions”] array.
          $$count = 0;
          // Fetch all the poi actions.
          actions = $$sql_actions->fetchAll( PDO::FETCH_ASSOC );
          /* Process the actions result */
          // if $$actions array is empty, return empty array.
                  if ( empty( actions ) ) {
                          $$poi[“actions”] = array();
                  }//if
          else {
  
                  // Put each action information into poi[“actions”] array.
                  foreach ( $$actions as action ) {
                  // Assign each action to $$poi[“actions”] array.
                  poi[“actions”][$$count] = action;
                  // put ‘params’ into an array of strings
                  $$paramsArray = array();
                  
                  if ( substr_count( action[‘params’],’,’ ) ) {
                          $$paramsArray = explode( “,”, action[‘params’] );
                  }//if
                  else if( strlen( $$action[‘params’] ) ) {
                          paramsArray[0] = $$action[‘params’];
                  }
                  
                  poi[“actions”][$$count][‘params’] = paramsArray;
  
                  // Change ‘activityType’ to Integer.
                  $$poi[“actions”][count][‘activityType’] =
                  ChangetoInt( $$poi[“actions”][count][‘activityType’] );
  
                  // Change the values of “closeBiw” into boolean value.
                  $$poi[“actions”][count][‘closeBiw’] =
                  ChangetoBool( $$poi[“actions”][count][‘closeBiw’] );
  
                  // Change the values of “showActivity” into boolean value.
                  $$poi[“actions”][count][‘showActivity’] =
                  ChangetoBool( $$poi[“actions”][count][‘showActivity’] );
  
                  // Change ‘autoTriggerRange’ to Integer, if the value is NULL,
                  // return NULL.
                  $$poi[“actions”][count][‘autoTriggerRange’] =
                  ChangetoInt( $$poi[“actions”][count][‘autoTriggerRange’] );
                  
                  // Change the values of “autoTriggerOnly” into boolean value,
                  // if the value is NULL, return NULL.
                  $$poi[“actions”][count][‘autoTriggerOnly’] =
                  ChangetoBool( $$poi[“actions”][count][‘autoTriggerOnly’] );
                  $$count++;
                  }// foreach
                  }//else
          return poi[“actions”];
  }//Getactions
  
  //Convert a TinyInt value to a boolean value TRUE or FALSE
  // Arguments:
  // value_Tinyint ; The Tinyint value (0 or 1) of a key in the database.
  // Returns:
  // value_Bool ; The boolean value, return ‘TRUE’ when Tinyint is 1.
  // Return ‘FALSE’ when Tinyint is 0.
  //
  function ChangetoBool( $$value_Tinyint ) {
          if ( value_Tinyint == 1 )
                  $$value_Bool = TRUE;
          else
                  value_Bool = FALSE;
          return $$value_Bool;
  }//ChangetoBool