MySQL commit and rollback

Question

Hi Friends I develop a webpage in that i face this problem. please see below.

In user table i have following fields:

• Userid
• password
• Address
• phone
• Email

In service table i have the following fields:

• Ser_name
• ser_id
• USER_Refid

All these are in same page in php.

When i add values in service table it stores under the same USER_Refid name .

For example the user xxxx is going to add service means the USER_Refid field contain the same name for all services .

My problem is when the user add values in services table and forgot to add the values in user table means i want to delete the values that inserted by that particular user . Please help me to solve this , Thanks in advance.

Answer 1

If your tables are InnoDB, you can a FOREIGN KEY constraint to your service table:

ALTER TABLE service_table ADD CONSTRAINT fk_service_user_refid FOREIGN KEY (USER_refid) REFERENCES user_table (USER_id)

To add the values into services, create a memory table with a session id, populate it with your services, and when the user clicks Save, do the following:

• Create an entry for your user in the user_table
• Move the entries from the temporary table into the service_table.