insert data into 5 tables from a html form

insert data into 5 tables from a html form

I have a problem how to place an order for a product, and than insert the
order into 5 tables that are connected: ONE-TO-MANY,
the tables are:
CREATE TABLE IF NOT EXISTS `user` (
user_id int(10) unsigned NOT NULL AUTO_INCREMENT, type_id int(10) unsigned
NOT NULL, username varchar(50) DEFAULT NULL, password varchar(32) DEFAULT
NULL, first_name varchar(100) DEFAULT NULL, last_name varchar(100) DEFAULT
NULL, email varchar(50) DEFAULT NULL, picture varchar(200) DEFAULT NULL,
PRIMARY KEY (user_id), UNIQUE KEY user_index1780 (username), KEY
user_FKIndex1 (type_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=71 ;
CREATE TABLE IF NOT EXISTS `order` (
order_id int(11) NOT NULL AUTO_INCREMENT, time timestamp NULL DEFAULT
CURRENT_TIMESTAMP, status int(11) DEFAULT NULL, room_id int(11) NOT NULL,
user_id int(10) unsigned NOT NULL, PRIMARY KEY (order_id), KEY
fk_order_room1 (room_id), KEY fk_order_user2 (waiter_id) ) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
CREATE TABLE IF NOT EXISTS `product` (
product_id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) DEFAULT
NULL, price float DEFAULT NULL, picture varchar(500) DEFAULT NULL, PRIMARY
KEY (product_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12
;
CREATE TABLE IF NOT EXISTS `room` (
room_id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) DEFAULT NULL,
picture varchar(450) DEFAULT NULL, description text, user_id int(10)
unsigned NOT NULL, PRIMARY KEY (room_id), KEY fk_room_user1 (user_id) )
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `item_orders` (
order_id int(11) NOT NULL, product_id int(11) NOT NULL, quantity int(11)
DEFAULT NULL, PRIMARY KEY (order_id,product_id), KEY
fk_order_has_product_product1 (product_id), KEY
fk_order_has_product_order1 (order_id) ) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `type_user` (
type_id int(10) unsigned NOT NULL, name varchar(20) DEFAULT NULL, PRIMARY
KEY (type_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; . Now after iI inner
jon them to place an order for a product nothing's happening.