Flex: How to pass these parameters to my PHP remote service?

Consider the following query which works in MySql:

SELECT r.restaurantId, name, city FROM restaurant AS r,
restaurant_restaurant_category AS c
WHERE r.restaurantId = c.restaurantId AND categoryId IN (6, 10)
GROUP BY restaurantId, name, city, phone ORDER BY name

This is the method on the remote service (PHP) I am trying to call:

public function getRestaurantsByCategories($categories) {
$stmt = mysqli_prepare($this->connection,
"SELECT r.restaurantId, name, city FROM restaurant AS r,
restaurant_restaurant_category AS c
WHERE r.restaurantId=c.restaurantId AND categoryId IN (?)
GROUP BY restaurantId, na开发者_如何学Pythonme, city, phone ORDER BY name");
// some other stuff here
}

I've have successfully connected to this remote service from the Flex Data services. What I cannot figure out is how to execute the above query from within Flex. E.g. I've tried

var array1:Array = new Array();
array1[0] = 6;
array1[1] = 10;

and I've tried

var string1:String = new String("6,10");

calling the remote function like so

remoteService.getRestaurantsByCategories(array1);

or so

remoteService.getRestaurantsByCategories(string1);

and so

remoteService.getRestaurantsByCategories(array1.join(","));

but all of these only return matches for categoryId=6.

What's the right way to pass the parameters to PHP so that the query gets executed for both categoryIds?

Thanks for any help, folks.

---

You're not using any kind of remoting framework like AMFPHP or ZendAMF. It's impossible to call a PHP function from the outside since it's out of scope. When a PHP script runs, it runs whatever is in the outside of the functions which could then call the functions themselves.

Still, I recommend you use AMFPHP or ZendPHP to do this part.

---

Have you tried the following:

1. try to set in flex/as3 var string1:String = new String(" 6 , 10 "); instead of just "6,10". It may be possible that your string is converted to other type... like int("6,10") ~= 6.

2. Have you tried to force a cast to string on $categories ?

3. Have you put a trace/echo on the $categories value in php? do you get 6,10 ?

4. Can you try to replace the query with:

   public function getRestaurantsByCategories($categories) 
   {
       $stmt = mysqli_prepare($this->connection,
          "SELECT r.restaurantId, name, city FROM restaurant AS r,
          restaurant_restaurant_category AS c
          WHERE r.restaurantId=c.restaurantId AND categoryId IN ($categosies)
          GROUP BY restaurantId, name, city, phone ORDER BY name");
       // some other stuff here
   }