我试图用一个表单在while循环中插入多行,但是似乎不能正常工作。我想插入多个名为"weight“的值。Like值30、20、15、10、5以及剩余的emp_id和task_id。
page1.php
$sql = mysql_query("SELECT
task_tbl.task_id,
task_tbl.task_name,
task_tbl.task_sem,
task_tbl.task_yr,
task_tbl.post_id,
post_tbl.post_id,
post_tbl.post_name AS ppost_name
FROM
task_tbl
LEFT JOIN
post_tbl
ON
task_tbl.post_id = post_tbl.post_id
WHERE
task_sem = '$sem'
AND
task_yr = '$yr'
ORDER BY
task_id ASC");
echo '<form action = "upds_peval.php" name = "add" method = "post">';
while($row = mysql_fetch_assoc($sql)){
echo "<br/>";
echo "<b>Employee ID No.:</b>";
echo '<input size = "2" type = "text" name = "emp_id'.$id.'" value = "';
echo $_POST['emp_id'];
echo '"/>';
echo "<br/>";
echo "<b>Work/Activity ID No.:</b> ";
echo '<input size = "2" type = "text" name = "task_id'.$row['task_id'].'" value = "';
echo $row['task_id'];
echo '"/>';
echo "<br/>";
echo "<b>Work/Activity:</b> ";
echo $row['task_name'];
echo "<br/>";
echo "<b>Weight:</b> ";
echo '<input size = "1" type="text" name="weight" value = ""/>';
echo "%";
echo "<br/>";
}
echo '<input type="submit" name="submit" value="ADD"/>';
echo "</form>"; 输出将如下所示:
员工ID号: 1001工作/活动ID号: 2002工作/活动:监督计算机的维护和故障排除重量:__%
员工ID号: 1001工作/活动ID号: 2003工作/活动:监督软件安装和维护权重:__%
员工ID号: 1001工作/活动ID号: 2004工作/活动:维护、监控和排除虚拟终端故障重量:__%
提交
page2.php
mysql_connect ("localhost", "root","") or die (mysql_error());
mysql_select_db ("emp_db0");
if(isset($_POST['submit'])){
$_POST['weight'];
$vals=implode(",",$_POST);
error_reporting(E_ALL ^ E_NOTICE);
mysql_query("INSERT INTO peval_tbl(weight,task_id,emp_id) VALUES('$vals')");
echo "<br/>";
echo "You have successfully added work/activities!";
echo "<br/>";
}发布于 2013-05-02 09:55:39
好的,根据我对你的问题的印象,你想要一个可扩展的表单,这样你就可以在一个名称中访问它的所有实例?
表单示例的第一个实例:
<input size = "2" type = "text" name = "emp_id[]" value = "1">
<input size = "2" type = "text" name = "task_id[]" value = "5001">
<input size = "2" type = "text" name = "weight[]" value = "50">第二个实例示例:
<input size = "2" type = "text" name = "emp_id[]" value = "2">
<input size = "2" type = "text" name = "task_id[]" value = "5003">
<input size = "2" type = "text" name = "weight[]" value = "30">这将把你的帖子转换成数组
要访问:
$var_emp_id = $_POST["emp_id"];
$var_task_id = $_POST["task_id"];
$var_weight_id = $_POST["weight"];使用循环来访问这些变量。要访问emp_id u的第一个实例,请使用:
$var_emp_id[0]; //will output 1
$var_emp_id[1]; //will output 2
$var_task_id[0]; //will output 5001
$var_task_id[1]; //will output 5003要将其插入到数据库中,请执行以下操作:
for ($i = 0; $i <= count($var_emp_id); $i++){
mysql_query("INSERT INTO peval_tbl(weight,task_id,emp_id) VALUES('$weight[$i]','$var_task_id[$i]','$var_emp_id[$i]')");
}发布于 2013-05-02 09:07:55
您对$_POST数组的寻址不正确,因此不要重新编码您的脚本,请尝试执行以下操作。
将这一行添加到page2.php中的代码中的mysql_connect之前
echo '<pre>' . print_r($_POST,true) . '</pre>';这将转储post数组的漂亮打印,这样您就可以看到数据是如何到达$_POST的。
发布于 2017-10-18 02:27:49
$sql = "select * from login where nombre !='carlos'";
$result = $conn->query($sql);
$index = 1;
while($row = mysqli_fetch_array($result)){
$valor = $row["nombre"];
$valor2 = $row["apellido"];
$insertsql= "insert into lista (`dato1`,`dato2`)values ('$valor', now())";
// mysql_query($insertsql);
$conn->query($insertsql);
$index++;
}http://www.baulphp.com/insertar-multiples-registros-ciclo-while-php/
https://stackoverflow.com/questions/16328765
复制相似问题