insert into 2 tables in one form

Question

I would like make INSERT INTO to two different MySQL tables. For example,

insert customer details in tblcustomer
insert customer address in tbladdress

Can I make it in

$result = mysql_query( "INSERT INTO tblcustomer( txtaccount_name,txtfirst_name,txtlast_name,txtemail ,intoffice_no,intfax,intmobile,intother_no,dtebirth_date) VALUES('$acc_name','$fname','$lname','$email', '$office','$fax_no','$mobile_no','$others_no','$date')"); $result1 = mysql_query( "INSERT INTO tbladdress( txtmailing_add,txtothers_add,txtmailing_street,txtothers_street, txtmailing_city,txtothers_city,txtmailing_state,txtothers_state, txtmailing_postcode,txtothers_postcode,txtmailing_country, txtothers_country) VALUES('$m_add','$o_add','$m_street','$o_street', '$m_city','$o_city','$m_state','$o_state', '$m_postcode','$o_postcode','$m_country', '$o_country')");

Never add php $values directly into MySQL statements, always use mysql_real_escape_string, or you'll suffer SQL injection attacks, see answers below. — Johan
– Johan, Commented Apr 17, 2011 at 0:02

Basic · Accepted Answer · 2011-04-16 15:08:50Z

1

Yes that would work, but you would have to execute two queries to the database, I suggest using PDO. It support transactions.

answered Apr 16, 2011 at 15:08

Basic

1,8665 gold badges22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Basic Over a year ago

Check here php.net/manual/en/book.pdo.php and follow the instructions, from start to finish, read carefully and you will be on your way in no time, make sure to use prepared statements as it ensures against SQL attacks, if you learn PDO well, it will greatly benefit your website in terms of almost everything.

Shakti Singh · Accepted Answer · 2011-04-16 15:09:18Z

You can insert with these queries but you should make connection between customer table and customer address table if you already did not done.

They should be connected by a foreign key or something like that if the engine is not innodb.

You should escape user input using mysql_real_escape_string

or better to use PDO.

Collectives™ on Stack Overflow

insert into 2 tables in one form

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related