php mysql表格循环,如何在php和mysql中使用数组和for循环更新表列？

for ($key=0; $key < count($_POST['marks']); $key++) {

$from_marks = $_POST['from'][$key];

$get_marks = $_POST['marks'][$key];

//echo $from_marks." ";

if($get_marks > $from_marks){

// header("location: ../../pages/marks.php?over=err");

// break;

echo "Cant add more marks
";

}

else{

echo $get_marks."
";

$update_marks_query = $db->prepare(

"UPDATE sc_marks SET get_marks='"

.$get_marks

."' WHERE _sid='$sc_foreign_id' AND exam_type='$select_exam_type' ");

$update_marks_query -> execute();

}

}

当我执行代码时出现问题,我在表的每一行中获得了最后一个获取的值.

更新后的数据结果：

解决方法:

include "./connection/config.php";

if(isset($_POST['btn_update_marks'])){

$sc_foreign_id = $_POST['sc_foreign_id'];

$select_exam_type = $_POST['select_exam_type'];

for($key=0; $key

$from_marks = $_POST['from'][$key];

$get_marks = $_POST['marks'][$key];

echo $from_marks." ";

if($get_marks > $from_marks){

// header("location: ../../pages/marks.php?over=err");

// break;

echo "Marks Vadhu Chhe
";

}

else{

echo $get_marks."
";

$update_marks_query = $db->query("UPDATE sc_marks SET get_marks='".$get_marks."' WHERE _sid='$sc_foreign_id' AND exam_type='$select_exam_type' ");

}

// else{

// $update_marks_query = $db->prepare("UPDATE sc_marks SET get_marks='$get_marks' WHERE _sid='$sc_foreign_id' ");

// $update_done = $update_marks_query -> execute();

// }

}

// if($update_done){

// echo "Successfully Updated";

// header("location: ../../pages/marks.php?add-marks=yes");

// }

// else{

// echo "Error";

// header("location: ../../pages/marks.php?add-marks=error");

// }

}

?>

标签：php,arrays,mysql,for-loop

来源： https://codeday.me/bug/20190623/1272049.html