I have an HTML page with a from in it that calls a PHP CGI when the user hits submit. In the form is a select box with a size="5" multiple name="Key" statement.
phpinfo() shows that his is properly passing the select as Key to the PHP CGI . An I can get the data $_POST('Key') and process it in the PHP program.
Where my problem starts is trying to pass the Array of keys to a PostgreSQL function through a pg_prepare / pg_execute combination.
$return_cde = pg_prepare($conn, "SendKeys", 'select web.sendKeys($1, $2, $3)');
$return_cde = pg_execute($conn, "SendKeys", array($_POST('Pin'), $userData, $current_user->user_login));
I have tried changing the prepare and execute a dozen different ways an received a dozen differ errors.
The PostgreSQL function looks like this --
CREATE OR REPLACE FUNCTION web.sendKeys(web_targets_ integer, web_test_ text, web_user_ text) RETURNS integer As
value integer := NULL;
TIA -- Fir any direction anyone can offer --