multiple tables update options

[ragrawal]

hello all.

I am wondering is there any good way to update multiple tables which all dependent on each other. For example here is my database structure

Table 1: pid, first_name, mi, last_name
Table 2: phoneid, pid, phone number // phone number table
Table 3: hid, address // home address table
Table 4: hid, pid // joiner table between person and home address

If there is a form from which I take all the input what's the best way to store all this information in php and then update in appropriate table. I checked some othe forum topics and found out that associative array can help in optimizing the code. I am not sure how it can be employed.

Further once i recieve data how should I write an optimize php code that can take all the data and upload it in mysql data

Looking for quick replies
Thank you

[jheitz]

Your code will be passing via POST or GET all the variables to another PHP file (or the same one...). On that PHP file I would call a Stored Procedure passing all the arguments. Then, on the Stored Procedure itself you take care of creating the data on the relevant tables.

This has several advantages in my view:

1) Only 1 call to the RDBMS
2) Within the Stored Procedure you can control any errors and do not make any changes if any error is found...

[ragrawal]

Hello.

Thanks for you comment. I was thinking is there any Object Oriented way to do this. That is can I create a class for each table and write some methods in a generic way that allow to update as well as retrieve data. I looked for such tutorial but never found one.

Regards,

[jheitz]

To be honest, I am quite new to PHP and have not yet explored its OO capabilities. It still feels strange to me to use OO in a web scripting language (can't see that many benefits to be honest, but it might be me being too much of a newbie in this arena).