Inserting data into multiple table

houssam_ballout

Hello all,
I'd a web form, and this form must enter data to multiple tables lets say now: 2 tables, (Voucher and Customer)
CustomerID is a forgein key in Voucher Table, and Voucher Table has a voucherId in it,
how can I insert both CustomerID and its information to the Customer Table and also insert the CustomerID to the Voucher table?
Thanks in advance

MarkR

Do two inserts. If your database supports it, do them in a transaction and/or a batch. If you think it's likely that the second one will fail, you might want to put it in a transaction so you can roll the first one back.

You will need to generate a key for the customer ID - this might be automatically done by your database, in which case you'll need to determine what it is so you can use it as a FK for the other table. None of this is difficult and it's all documented in your database's documentation*

Mark

*Unless you're using something really crap.

houssam_ballout

MarkR wrote:
Do two inserts. If your database supports it, do them in a transaction and/or a batch. If you think it's likely that the second one will fail, you might want to put it in a transaction so you can roll the first one back.

You will need to generate a key for the customer ID - this might be automatically done by your database, in which case you'll need to determine what it is so you can use it as a FK for the other table. None of this is difficult and it's all documented in your database's documentation*

Mark

*Unless you're using something really crap.

ًWell, I am using mysql (WAMP),
the CustomerID is generated automatically, but how could I insert that ID into the 2nd table?

MarkR

Several methods are clearly explained in the MySQL documentation. Read it.

Mark

bradgrafelman

It's also mentioned in PHP's documentation; [man]mysql_insert_id/man.