如果第二个查询不起作用，则删除或撤消第一个查询

2022-01-15 00:00:00 mariadb php mysql

我对此感到困惑.有什么方法可以测试所有查询是否正常工作并且不返回错误?如果是这样，执行它们或返回一些东西.

im confused about this. Is there any way like to test if all queries are working and not returning erros? if so execute them or return something.

我正在构建一个注册方法，它有 2 个部分:登录信息(用户名、密码)和通常的员工信息(姓名、电子邮件等).

I am building a signup method, this have 2 parts: loginInfo(username, password) and the usual Employee info (name, email, etc..).

signup 方法将 Employee 信息插入到 employee 表中，然后它获取 PRIMARY 键并将其与 loginInfo 一起插入到 login 表中

The signup method inserts the Employee info into employee table, then it gets the PRIMARY key and insert it alongside with the loginInfo in the login table

login 表有一个 UNIQUE 列，这应该在重复时返回错误.问题是插入的 employee 信息没有 login 信息.

the login table has an UNIQUE column, this should return error on duplicated. The problem is that the employee info are inserted without a login information.

我该如何解决这个问题?

How can i solve this problem?

我的代码:

public function signUp($personInfo, $employeeInfo, $loginCredit){
    try {
        $stmt = $this->pdo->prepare("INSERT 
            INTO `$this->employeeTable`
                (`name`, `birthDay`, `phnNmb`, `email`, `address`, `idnNmb`, `insNmb`, `bankInfo`)
            VALUES
                (?, ?, ?, ?, ?, ?, ?, ?);
        ");

        $stmt->execute([
            $personInfo["name"],
            $employeeInfo["birthDay"],
            $personInfo["phnNmb"],
            $personInfo["email"],
            json_encode($employeeInfo["address"]),
            $employeeInfo["idnNmb"],
            $employeeInfo["insNmb"],
            json_encode($employeeInfo["bankInfo"])
        ]);

        $employeeId = $this->pdo->lastInsertId();

        $insertloginCredit = $this->pdo->prepare("INSERT INTO `$this->loginTable` (`empId`, `userName`, `userPass`) VALUES ($employeeId, ?, ?);");
        $insertloginCredit->execute($loginCredit["userName"], md5($loginCredit["userPass"]));

        echo "done";

    } catch (PDOException $err) {
        die($err->getMessage());
    }
}

推荐答案

您在此处查找的内容称为事务.PDO 文档有一些对它们的解释.总之，您需要执行以下操作.

What you're looking for here is called a transaction. The PDO docs have some explanation on them. In summary, you'd want to do the following.

try{
  $this->pdo->beginTransaction();
  $stmt1 = $this->pdo->prepare(...);
  $stmt1->execute(...);
  $stmt2 = $this->pdo->prepare(...);
  $stmt2->execute(...);
  $this->pdo->commit();
} catch (PDOException $e) {
  $this->pdo->rollBack();
}

rollBack 函数会将数据库恢复到调用 beginTransaction 时的状态.

The rollBack function will restore the database to the state it was in when beginTransaction was called.

相关文章