Insert Into Multiple Tables

TKB

I have the following tables/fields, how can I make the insertion into 1? Now as I have the code into different querries there is nothing added in mysql.

Thank you in advance for your help.

mysql_query ("INSERT INTO categories (CategoryName)
VALUES
('$_POST[CategoryName]')");

<?php
mysql_query ("INSERT INTO insurancecharges (InsuranceType)
VALUES
('$_POST[InsuranceType]')");

<?php
mysql_query ("INSERT INTO packaging (PackagingType)
VALUES
('$_POST[PackagingType]')");
?>

<?php
mysql_query ("INSERT INTO products (ProductUnits)
VALUES
('$_POST[ProductUnits]')");
?>

<?php
mysql_query ("INSERT INTO transportationcharges (TransportationUnit)
VALUES
('$_POST[TransportationUnit]')");
?>

planetsim

Im pretty sure with MySQL you can only do the one insert. I havent tried with postgres but its probably more doable than MySQL. Also is there a reason why you are only inserting to one field in each of the tables? Is this data related in anyway. Also you should validate your data, do a search on SQL Injections to see what you need to do.

TKB

Ok, will search SQL injections.

Thanks.

liquorvicar

Yes, mysql_query only allows you to process one query. You can process multiple queries with the MySQLi extension

rincewind456

You could reduce your use of mysql_query to just the one by doing this

mysql_query ("
INSERT INTO categories (CategoryName)
VALUES ('$_POST[CategoryName]');
INSERT INTO insurancecharges (InsuranceType)
VALUES ('$_POST[InsuranceType]');
INSERT INTO packaging (PackagingType)
VALUES ('$_POST[PackagingType]');
INSERT INTO products (ProductUnits)
VALUES ('$_POST[ProductUnits]');
INSERT INTO transportationcharges (TransportationUnit)
VALUES ('$_POST[TransportationUnit]')");

And check out [man]mysql_real_escape_string/man for protecting your database.

liquorvicar

No, rincewind456, I'm afraid that won't work. mysql_query() will only process one query at a time - and queries sent to mysql_query() shouldn't have the trailing semi-colon.

rincewind456

You're right about the first part I should have said use [man]mysqli_multi_query/man.

However you're wrong on the second part the "trailing" semi-colon as you call it is a delimiter in sql.

liquorvicar

Yes, the semicolon is the delimiter in SQL but in PHP's implementation of it's MySQL interface, it shouldn't be added to the query.
According to the PHP manual for mysql_query()

query

A SQL query

The query string should not end with a semicolon. [/QUOTE]

rincewind456

OK as I explained I should have said you can do this

mysqli_multi_query(" 
INSERT INTO categories (CategoryName) 
VALUES ('$_POST[CategoryName]'); 
INSERT INTO insurancecharges (InsuranceType) 
VALUES ('$_POST[InsuranceType]'); 
INSERT INTO packaging (PackagingType) 
VALUES ('$_POST[PackagingType]'); 
INSERT INTO products (ProductUnits) 
VALUES ('$_POST[ProductUnits]'); 
INSERT INTO transportationcharges (TransportationUnit) 
VALUES ('$_POST[TransportationUnit]')");