php - foreach 数据库中的数据未更新

Question

在我的本地服务器中，该脚本运行良好。当我实时上传此脚本时，它无法正常工作。

它只向数据库插入 126 行数据，但我需要一次至少上传 500 行。

<?php
include 'database-config.php';
foreach($_POST['classroll'] as $row=>$classroll)
{
    $sclassroll = $classroll; 
    $mark = $_POST['mark'][$row];
    $type = $_POST['rtype'];
    $session = $_POST['rsession'];
    $department = $_POST['rdepartment'];
    $examtype = $_POST['rextype'];
    $examyear = $_POST['rexyear'];
    $examsubject = $_POST['rexmarksubject'];

$stmt = $dbh->prepare("INSERT INTO exammarks(studnettype, studentsession, studentdepartment, studentclassroll, examtype, examyear, examsubjec, exammarks) VALUES (:studnettype, :studentsession, :studentdepartment, :studentclassroll, :examtype, :examyear, :examsubjec, :exammarks)");

  $stmt->bindParam('studnettype', $type);
  $stmt->bindParam('studentsession', $session);
  $stmt->bindParam('studentdepartment', $department);
  $stmt->bindParam('studentclassroll', $sclassroll);
  $stmt->bindParam('examtype', $examtype);
  $stmt->bindParam('examyear', $examyear);
  $stmt->bindParam('examsubjec', $examsubject);
  $stmt->bindParam('exammarks', $mark);


$stmt->execute();
}
header('Location: ../home.php');
?>

Answer 1

实时服务器上的 exammarks 表定义可能包含本地主机服务器上不存在的唯一索引。如果确实如此，您的某些 INSERT 操作可能会失败。

您向我们展示的代码不会检查错误。显然，当您的程序处理高值(value)数据(例如学生考试结果)时，您应该检查错误。

试试这个:

if( !$stmt->execute()) {
    print_r( $arr = $stmt->errorInfo() );
}
else {
    /* INSERT statement completed correctly */
}