Checkbox record selection

bruceg

I would like to use checkboxes, to pass certain records from one script to another. Here is an example:

CK ID DESC COUNT

[] 123 TEST 23
[] 132 TEST2 45
[] 133 TEST3 46
[x] 134 TEST4 47
[x] 135 TEST5 48

where [x] is a checkbox that is checked.

The data above is derived from an ODBC datasource, and I would like users to check only the data which should be passed to the next script for inclusion into a MySQL db.

How do I get the entire record (i.e. ID, DESC, COUNT) passed to the next script as variables? Or, what is the best way to accomplish this?

Thanks for any help..

Bruce

Anon

You would have to store the extra info as hidden fields.

Mark.

Bruce Garlock wrote:

I would like to use checkboxes, to pass certain records from one script to another. Here is an example:

CK ID DESC COUNT

[] 123 TEST 23
[] 132 TEST2 45
[] 133 TEST3 46
[x] 134 TEST4 47
[x] 135 TEST5 48

where [x] is a checkbox that is checked.

The data above is derived from an ODBC datasource, and I would like users to check only the data which should be passed to the next script for inclusion into a MySQL db.

How do I get the entire record (i.e. ID, DESC, COUNT) passed to the next script as variables? Or, what is the best way to accomplish this?

Thanks for any help..

Bruce

bruceg

Could you give a quick example? I'm not sure what you mean.

Thanks..

bruceg

The following is an example of how I get the output, and I would like to pass only the records that have checks next to them, to the next script:

while (odbc_fetch_row($cur)) {
$job_id = odbc_result($cur, "job_id");
$desc = odbc_result($cur, "desc");
$count = odbc_result($cur, "count");

print"<TR>
<TD><FONT SIZE=$font_size><input type=\"checkbox\" name=\"chk_array[]\" value=\"$job_id\"></TD>
<TD><FONT SIZE=$font_size><A HREF=\"jobshow.php?jobnum=$job_id\">$job_id</A></TD>
<TD><FONT SIZE=$font_size><A HREF=\"jobshow.php?jobnum=$job_id\">$desc</A></TD>

   <TD><FONT SIZE=$font_size><A HREF=\"jobshow.php?jobnum=$job_id\">$count</A></TD>

</tr>
";

}

khaine

oh right that way be a bit difficult. What you could do is to pass the record key as the checkbox value then you can requery the database to extract what you want. If you do want to pass the info via the html page you will end up passing all the fields to the script. or store them as a session variable.

Mark.

Anon

Remember that PHP will only receive variables from checkboxes that are checked. If you list them and they don't get checked, then they won't exist on the receiving end.

In your example code, let's say you had three checkboxes with the following values: A, B and C. The checkbox name is "chk_array[]" as you have it and let's say the user selects A and C.

On the receiving script it will have an array called "chk_array" with the following values:

chk_array[0] = 'A'
chk_array[1] = 'C'

You could easily run through the array with the numerous methods of traversing arrays (I'm partial to the list/each functions).

John Cornett

bruceg

I guess that's kind of what I'm looking for. My ultimate goal, is to display the same records in the new script, that the user selects from the previous script. It looks like I can do this by getting the record ID from the checkbox array, and looping through and doing another query on the db. Maybe there is an easier way?