PHP/PostgreSQL Array Problem

exarkun_uk

Hi,
I have a problem with populating a PostgreSQL Array with the contents of a PHP Array.

My PHP Array is in a while loop as follows:

while($x = each($one))
{
for ($row = 0; $row < count($iteration); $row++){
echo $x[1];
}
}
This code is part of a script to create checkboxes dependant on the number of rows in a particular table, and this works okay.

The problem I have is trying to insert the values of the checkbox into a postgres Array.

I have followed the sal_emp example on the postgres site, and from the backend, I can submit an insert as follows:

insert into job_contact(job_contact_id, job_sheet_id, contact_id) values (nextval('jc_seq'),'119','{100,200,300,400}');

The problem I have is that PHP will not allow me to do this, do I have to delimit the curly braces? or create some sort of loop on the insert statement? Apologies for lengthly post, any help greatly appreciated.

Matt.

tednugent

Matt-

Did you ever get your PostgreSQL array/PHP problem figured out? I'm having the same damn problem and have been frustrated for about the last week trying to populate my array field. Thanks for whatever light you can shed on the situation.

-Jay

exarkun_uk

No sorry. What I ended up doing was using the PHP loop to create a seperate insert with a unique id for each row, so what I would do is for each iteration repeat the job_id number, so that they are effectively grouped together, then when I read the loop back in, I just use where jobsheet_id='<whatever the number is>'. This does actually work very well, although it is not very elegant. Let me know if anyone else answers your question, because I am quite frustrated that I works fine backend, but not through PHP.

regards

Matt

tednugent

Matt-

I'm digging what you said about your PHP loop to bypass the need for an array, but I'm a little fuzzy on the details. Do you think I could see some sample code? Thanks for your help, by the way.

-Jay aka TedNugent

exarkun_uk

First of all, I used 2 different html/php forms. The first one drawing out the checkboxes. this contained amongst other stuff the following code:
$iteration=1;
if ($one)
{
while($x = each($one))
{
for($row = 0; $row < count($iteration);$row++){
echo"<INPUT TYPE=\"hidden\" name=\"one[ ]\" value=\"%s\">";
echo "the ".$x[1]." checkbox was checked";

this will loop through the array 'one' and draw the boxes, next part of code in the same document posts to a dummy page the creates the insert loop.
//--
printf("<FORM METHOD=\"GET\" ACTION =\"dummy.php\">");
printf("<INPUT TYPE=\"submit\" name=\"submit_dummy\" value=\"add to db\"");
}
}else{
echo "Nothing selected";
}

this is the contents of the dummy page:
$iteration=1;
if($one)
{
while($x = each($one))
{
for ($row = 0; $row < count($iteration);$row++){
$res="INSERT INTO table(field1,field2,field3)VALUES (NEXTVAL('the_seq'),'$var1',' ".$x[1]." ')";
//--put db conn stuff below here, then close the loop off.
}
}
}
Hope this works for you. let me know how you get on.

thanks

Matt