Class File

class crud extends dbConfig{

    public function insert_pegawai(){

        $nip    = htmlentities($_POST['nip']);
        $nama   = htmlentities($_POST['nmPeg']);
        $gol    = htmlentities($_POST['golPEg']);
        $gender = htmlentities($_POST['jkPeg']);

        $cekNip = $this->db->prepare("SELECT * FROM pegawai WHERE peg_nip = ?");
        $cekNip->execute(array($nip));

        if($cekNip->rowCount() > 0){
            $response = array('pesan'=>"NIP sudah digunakan");
            echo json_encode($response);
        }else{
            $sql = "INSERT INTO pegawai SET peg_nip = ?, peg_nama = ?, peg_gol = ?, peg_gender = ?";
            $stmt = $this->db->prepare($sql);
            $stmt->bindParam(1, $nip);
            $stmt->bindParam(2, $nama);
            $stmt->bindParam(3, $gol);
            $stmt->bindParam(4, $gender);
            $stmt->execute();
            /*ambil AUTO INCREMENT terakhir dari tabel pegawai*/
            $query = "SELECT LAST_INSERT_ID()";
            $stmt1 = $this->db->prepare($query);
            $stmt1->execute();
            while($r = $stmt1->fetch(PDO::FETCH_LAZY)){
                $ID = $r[0];
            }
            /*simpan ke tabel ssh_login*/
            $statusLog = htmlentities($_POST['status']);
            $pass_u    = htmlentities($_POST['logPass']);
            $query_login = "INSERT INTO login SET login_peg = ?, login_user = ?, login_status = ?, login_pass = ?";
            $stmt2 = $this->db->prepare($query_login);
            $stmt2->bindParam(1, $ID);
            $stmt2->bindParam(2, $nip);
            $stmt2->bindParam(3, $statusLog);
            $stmt2->bindParam(4, password_hash($pass_u, PASSWORD_DEFAULT));
            $stmt2->execute();
            $response = array('pesan'=>"sukses simpan data");
            echo json_encode($response);
        } /*End If*/
    }

}