php - AngularJs + PHP 插入数据在第一个表中有效，但在第二个表中无效

Question

我很难理解为什么在第一个表中插入数据时在第二个表中插入数据不是“插入”。

controller.js

$scope.addStudent = function(student){

    var data {
       firstName: student.firstName,
       gFirstName: student.firstName
    };

    $http.put("php/students/addStudent.php",data).then(function(response){
        console.log(response);
    });
}

addStudent.php

<?php 
   include("../../connection.php");
   $data = json_decode(file_get_contents("php://input"));
   $firstName = $data->firstName;
   $gFirstName = $data->gFirstName;

   $q = "INSERT INTO tblstudents (firstName) VALUES ('$firstName')";
   $db->query($q);
   $r = "INSERT INTO tblparents (firstName) VALUES ('$gFirstName')";
   $db->query($r);
?>

我刚刚添加了 $r 查询，认为它会按我预期的方式工作，但它并没有按我预期的方式工作。没有数据被插入到表 tblparents 中，而表 tblstudents 数据则正常插入。

connection.php

<?php 
   header("Cache-Control: no-cache, must-revalidate"); 
   $db = new PDO("mysql:host=localhost;dbname=myDB","root","");
?>

Answer 1

我确实尝试了@aynber 在我上面的问题的评论中所说的内容。感谢他。也感谢这个link of another related question.

这是我更新的addStudent.php

<?php 
  include("../../connection.php");  

    $data = json_decode(file_get_contents("php://input"));
    $firstName = $data->firstName;
    $gFirstName = $data->gFirstName;

    try {
    $db->exec("SET CHARACTER SET utf8");    
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "
    INSERT INTO `tblstudents`(`firstName`) VALUES (:firstName);
    INSERT INTO `tblguardians`(`firstName`) VALUES (:gFirstName);
    ";

    $statement = $db->prepare($sql);
    $statement->bindValue(":firstName", $firstName);
    $statement->bindValue(":gFirstName", $gFirstName);

    $result = $statement->execute();

    }
    catch(PDOException $e) {
       echo $e->getMessage();
    }

    echo json_encode($result);

?>