html 插入两个php,JavaScript – 通过PHP从HTML表单插入数据库多个选项

我有下拉列表，选择任何值后添加新行与一些字段，示例如下图所示：

我有insert.php将值插入到MySQL数据库中。但有问题，只有第一行的值被插入数据库。

PHP看起来像：

foreach($_POST['CertificateType'] as $key => $val){

$CertificateType = $val;

$CertificateType = $_POST['CertificateType'][$key];

$STCWCode = $_POST['STCWCode'][$key];

$CertNo = $_POST['CertNo'][$key];

$FromCert = $_POST['FromCert'][$key];

$ToCert = $_POST['ToCert'][$key];

$CertificateType = mysqli_real_escape_string($link, $CertificateType);

$STCWCode = mysqli_real_escape_string($link, $STCWCode);

$CertNo = mysqli_real_escape_string($link, $CertNo);

$FromCert = mysqli_real_escape_string($link, $FromCert);

$ToCert = mysqli_real_escape_string($link, $ToCert);

$sql3 = "INSERT INTO Tbl (

CertificateType

,UserId

,STCWCode

,CertNo

,FromCert

,ToCert

,DateCreated

) VALUES (

'$CertificateType',

'$UserID',

'$STCWCode',

'$CertNo',

'$FromCert',

'$ToCert',

now())";

if(mysqli_query($link, $sql3)){

echo "Resume created successfully.";

} else{

echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}

}

HTML看起来像：

4. Licenses & Certificates

• Select certificates

  One

  Two

  Three

• • Name

• • STCW Code

• • Cert. No

• • Place of Issue

• • Date of Issue

• • Date of Expire

Javascript代码可以在JS FIDDLE查看

我创建了JS FIDDLE以检查表单的那部分。你有想法如何解决它？