just a question, how can I use transaction ?

[WajahatRana789]

$db->begin_transaction(); try { $db->insert('members', $data_for_tbl_members); $last_member_id = $db->getLastInsertId();

$data_for_tbl_members_detail = array( 'member_id' => $last_member_id, 'code' => 'FBC-' . $last_member_id, 'email' => $memberEmail, 'phone' => $memberPhone, 'joining_date' => $memberJoining, 'photo' => '', ); $db->insert('members_details', $data_for_tbl_members_detail);

$db->commit(); } catch (PDOException $exception) { echo $exception->getMessage(); $db->rollback(); }