插入两个相关表格

Question

tbl_account
username | password | status

tbl_data
username | name | address | phone

how can i insert data into both tables with php? I tried with query

INSERT INTO tbl_account(username, password, status)
OUTPUT INSERTED.'bobo', 'Bobo Ali','Markt St. 26', '0979877'
INTO tbl_data(username, name, address, phone)
VALUES  ('bobo','bobo123','manager');

but it doesn't work at all. The process is success but the table is remain empty.

Answer 1

You will need seperate queries for inserting the same data into multiple tables.

If you are having trouble with that, the process is simple:

1. Use the query to insert the data into the first table
2. Free the last result using mysqli_free_result() (or mysql_free_result() if you are using the MySQL API.
3. Reuse the same query you used in step 1. to insert the data into the second table

Code:

<?php

INSERT INTO tbl_account(username, password, status)
VALUES ('bobo', 'Bobo Ali','Markt St. 26', '0979877');

// Free the result here

INSERT INTO tbl_data(username, name, address, phone)
VALUES  ('bobo','bobo123','manager');

// Free the result again, so you can use the query again if needed

?>