php - delete or undo the first query if the second query did not work

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.

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

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

thelogin table has anUNIQUE column, this should return error on duplicated. The problem is that theemployee info are inserted without alogin information.

How can i solve this problem?

My code:

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());
    }
}
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.