mysql获取单选按钮置,PHP / MySQL：如何在数据库中保存或插入选定的单选按钮？...

I have a table having n rows. Each row has a name [came from an Excel file] and 2 sets of radio buttons. How should I save or insert the selected radio buttons in a database?

The structure of my database is: id, name, vote_for_mayor, vote_for_vmayor

Here's my php code.

echo '

Submit

list($cols,) = $xlsx->dimension();

$var=0;

$var1=0;

foreach( $xlsx->rows() as $k => $r) {

$var++;

$var1++;

'.$k.''.( (isset($r[0])) ? $r[0] : ' ' ).' //names

}

';

解决方案

Change the HTML to:

Then when processing the form, the variables $_POST['vote'] and $_POST['vote1'] will be arrays containing the value of the radio button on each row. You can loop through them and insert them into the database.