我有一个带有“添加联系人”部分的表单,在单击该表单时,它会向表单添加另外一行,并带有3个输入框. (jfiddle上的代码段:http://jsfiddle.net/fmdx/cYxYP/)
HTML
1. Name: , Institution: , Method:
这是要插入的PHP / MYSQL:
if (isset($_POST['submit_val'])) {
foreach ($_POST['copiestoname'] as $key=>$value) {
$copiestoname = mysql_real_escape_string($value);
mysql_query("INSERT INTO copiesto (name) VALUES ('$copiestoname')") or die(mysql_error());
echo "Completed";
}
echo "" . count($_POST['copiestoname']) . " Names Added
";
mysql_close();
}
数据库中的表为:
Table Name: copiesto
+-------------+-------------+-------------+---------+
| index | name | institution | method |
+-------------+-------------+-------------+---------+
我将如何扩展当前的MYSQL代码以接受来自其他2个数组的条目,并在该循环中将其数据输入到同一MYSQL行中?