您不需要绑定变量。香港专业教育学院以前用类似的代码做到这一点。很难说出什么问题了。您是否有例外-如果是这样？
我唯一看到的错误是您在循环中进行了准备…应该更像是：
try { $conn = new PDO("mysql:host=$host;dbname=$dbName", $un, $pw); echo 'Connected to database<br>'; $sql = "INSERT INTO studentData (originallyAddedOn, inputMethod, studentFirst, studentLast, studentStreet, studentCity, studentState, studentZip, studentDOB, studentGender, studentGrade, schoolName, schoolStreet, schoolCity, schoolState, schoolZip, schoolContactName, schoolContactTitle, schoolContactEmail, schoolContactPhone) VALUES (:originallyAddedOn, :inputMethod, :studentFirst, :studentLast, :studentStreet, :studentCity, :studentState, :studentZip, :studentDOB, :studentGender, :studentGrade, :schoolName, :schoolStreet, :schoolCity, :schoolState, :schoolZip, :schoolContactName, :schoolContactTitle, :schoolContactEmail, :schoolContactPhone)"; // prepare once... exceute many :-) $q = $conn->prepare($sql); foreach($studentDataArray as $student) { $q->execute($yourDataArray); // do other stuff if needed }} catch(PDOException $e) { echo $e->getMessage();}
