[Status: Learner]
I have a Table A with thousands of records. On each displayed page, only 20 rows are showing, with the following fields:
check
last_name
first_name
gr
eth
sex
id_num (a unique value)
reason
start_date
The "check" field indicates a checkbox that the user can tick. At the bottom of each page of 20 records is the select button. I want to take the unique "id_num" from the rows that are selected by the user from Table A and insert them into Table B. (Method is post.)
Checkbox input code:
$html = <input type='checkbox' name='checkbox[]'
id = '' value='<?PHP echo $aRecords [ \"id_num\" ]; ?>' />" ;
The SQL after the rows on a page are selected by the user:
include_once "db_login.php" ;
if ( isset ( $_POST [ checkbox] ) )
{
foreach ( $_POST [ 'checkbox' ] as $checkbox )
{
$sql = "INSERT INTO sap_id_select ( select_id )
VALUES ( '<???>' ) " ;
mysql_query ( $sql ) or ( "Error " . mysql_error () ) ;
}
}
Also tried, in addition to many other things:
foreach ( $_POST [ 'checkbox' ] as $checkbox )
{
$id_list = implode(',',$_POST['checkbox']);
$sql = "INSERT INTO sap_id_select ( select_id )
VALUES ( '{$id_list}' ) " ;
}
How can I get the id_num field into the $_POST array and then into Table B? Thanks for your help.