Phonebuff
asked on
How do you Pass an Arrary from HTML --> PHP--> PostgreSQL fucntion.
So,
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.
I have tried changing the prepare and execute a dozen different ways an received a dozen differ errors.
The PostgreSQL function looks like this --
TIA -- Fir any direction anyone can offer --
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
$BODY$
DECLARE
value integer := NULL;
TIA -- Fir any direction anyone can offer --
ASKER
Duncan,
First off my php is runinng as a result of a form post not embedded in the html..
So ---
<form action="/cgi-bin/xxxicgi.p hp" method="post" name="FrontPage_Form1" id="pagemsg" onsubmit="return autocomplete="off" FrontPage_Form1_Validator( this)">
<select id="targetGroups" class="targetSubselect" size="5" multiple name="Key[]" width="40" style="width: 400px">
========================== ========== ========== ========== ========== ========== ========== ========
The php cgi has no problem with the array Key
$mySelected=$_POST['Key']
echo "<br>You chose:<br>\n";
foreach ($mySelected as $item)
echo $item."<br>\n";
But when I try to pass the array key to to the PostgreSQL function I get various errors depending on how and where I place the brackets or casts. But nothing seems to work ..
-------------------------- --------
First off my php is runinng as a result of a form post not embedded in the html..
So ---
<form action="/cgi-bin/xxxicgi.p
<select id="targetGroups" class="targetSubselect" size="5" multiple name="Key[]" width="40" style="width: 400px">
==========================
The php cgi has no problem with the array Key
$mySelected=$_POST['Key']
echo "<br>You chose:<br>\n";
foreach ($mySelected as $item)
echo $item."<br>\n";
But when I try to pass the array key to to the PostgreSQL function I get various errors depending on how and where I place the brackets or casts. But nothing seems to work ..
--------------------------
pg_execute has error, right ? if so, variable passing into web.sendKeys is matched or confilict.
and pg_prepare is no any error at all ?
Please put more echo statement to find out each code is error first
Duncan
and pg_prepare is no any error at all ?
Please put more echo statement to find out each code is error first
Duncan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay,
Get this --
userKey is array
userMsg is string
user_Login is string
Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: array value must start with "{" or dimension information in /home/dxxxxxxxxx/public_ht ml/xxxxxxx x/cgi-bin/ xxxxcgi.ph p on line 87
$return_cde = pg_execute($conn, "SendKeys", array($userKey, $userMsg, $current_user->user_login) );
Get this --
userKey is array
userMsg is string
user_Login is string
Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: array value must start with "{" or dimension information in /home/dxxxxxxxxx/public_ht
$return_cde = pg_execute($conn, "SendKeys", array($userKey, $userMsg, $current_user->user_login)
COuld you put $current_user->user_login as variable first ? something like that
$a=$current_user['user_log in'] //example only
echo $a //to see that is what you want
and put it into pg_execute if okay
Duncan
$a=$current_user['user_log
echo $a //to see that is what you want
and put it into pg_execute if okay
Duncan
The 'pg_execute' page only shows 3 parameters and your statement above has 5.
http://us2.php.net/manual/en/function.pg-execute.php
http://us2.php.net/manual/en/function.pg-execute.php
ASKER
Dave,
The pg_execute has 3 and the statement has 3 .. The connection, and the Reference and the array() of values to be passed. The problem is that the first element of the array is also an array. I think thinking I need to unnest it and pass it that way..
Duncan,
I am passing (or at least trying to) array(array, string, string) which is what the PostgreSQL function wants. Changing the order kind of makes a mess of some documentation and standards in a function that has been used for years within the postgresql database. Are you suggesting array(text, text, array) will make a difference ?
The pg_execute has 3 and the statement has 3 .. The connection, and the Reference and the array() of values to be passed. The problem is that the first element of the array is also an array. I think thinking I need to unnest it and pass it that way..
Duncan,
I am passing (or at least trying to) array(array, string, string) which is what the PostgreSQL function wants. Changing the order kind of makes a mess of some documentation and standards in a function that has been used for years within the postgresql database. Are you suggesting array(text, text, array) will make a difference ?
Just think about the input "->" is okay or not ,
Could you put the exact value into put pg_execute() to test pg_execute is okay on sql database ?
PostpreSql sometimes have different declaration writing syntax tolerance from mysql or other sql
Duncan
Could you put the exact value into put pg_execute() to test pg_execute is okay on sql database ?
PostpreSql sometimes have different declaration writing syntax tolerance from mysql or other sql
Duncan
I mean try simple example first and it will help to narrow down the bug,
Duncan
Duncan
ASKER
Okay,
So in this case it appears to have passed (Array, Text String, Text String) according to the tail on the postgreSQL system..
So in this case it appears to have passed (Array, Text String, Text String) according to the tail on the postgreSQL system..
$userMsgE = pg_escape_string($userMsg);
$userLoginE = pg_escape_string($current_user->user_login);
$return = pg_query($conn, "select web.sendKeys($userKey, $userMsgE, $userLoginE)");
ERROR: syntax error at or near "," at character 26
STATEMENT: select web.sendKeys(Array, ergewgrewgewgwerg / XXX, JSXXXXXX)
ASKER
The problem is passing a PHP arrary to a PostgreSQL Arrary --
I see lot's of hits with Google searches but no answers yet --
================
I see lot's of hits with Google searches but no answers yet --
================
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Correct answer for the specific question was derived elsewhere, posted here for documentation purposes.
I don't find any "?" character in your question post so I guess you need PostpreSQL and PHP tutorial at
this http://www.designmagick.com/article/9/Starting-Out/Adding-data-to-your-database, Right ?
Hope understand your question completely .If not, pls pt it out and write it in detail
Duncan