Ad:

PHP Discussion Thread
Unsolved
Views: 3839

Mar 20th, 2008

PHP/MySql - Inserting Multiple Records

Expand Post »

I want to insert records into multiple tables at one go, I am doing this in the following way, is this the correct way of doing? If not, what is the better way?

PHP Syntax (Toggle Plain Text)
mysql_query("insert into table1 values('abc')");
mysql_query("insert into table2 values('ttt')");
mysql_query("insert into table3 values('5t6')");
mysql_query("insert into table4 values('ghy')");
mysql_query("insert into table5 values('gfd')");
mysql_query("insert into table1 values('abc')");
mysql_query("insert into table2 values('ttt')");
mysql_query("insert into table3 values('5t6')");
mysql_query("insert into table4 values('ghy')");
mysql_query("insert into table5 values('gfd')");

Please help

Thanx

cancer10

Reputation Points: 58

Solved Threads: 1

Posting Whiz in Training

Offline

234 posts
since Dec 2004

Permalink

Mar 20th, 2008

Re: PHP/MySql - Inserting Multiple Records

Yep. This is correct. But, its a good practice to have column name in your insert query. And also, Dont execute your query directly. Store the query in a variable and then execute it. This way, if you encounter any problem, you can easily print the query for manual testing.
ie.,

php Syntax (Toggle Plain Text)
$query = "insert into table1 (col1) values ('ttt')";
mysql_query($query);
$query = "insert into table1 (col1) values ('ttt')";
mysql_query($query);

Cheers,
Naveen

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jul 3rd, 2010

Re: PHP/MySql - Inserting Multiple Records

i think better be like this :

PHP Syntax (Toggle Plain Text)
$query = "INSERT INTO table1 (col1)
          VALUES
          ('abc'),('ttt'), ('5t6'), ('gfd')";
mysql_query ($query,$connction);
$query = "INSERT INTO table1 (col1)
          VALUES
          ('abc'),('ttt'), ('5t6'), ('gfd')";
mysql_query ($query,$connction);

sxz52

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2010

Permalink

Jul 5th, 2010

Re: PHP/MySql - Inserting Multiple Records

Considered all tables are in a single database:

PHP Syntax (Toggle Plain Text)
$query = "insert into table1 (col1) values ('data')";
mysql_query($query);
$query = "insert into table2 (col1) values ('data')";
mysql_query($query);
$query = "insert into table3 (col1) values ('data')";
mysql_query($query);
$query = "insert into table4 (col1) values ('data')";
mysql_query($query);
$query = "insert into table1 (col1) values ('data')";
mysql_query($query);
$query = "insert into table2 (col1) values ('data')";
mysql_query($query);
$query = "insert into table3 (col1) values ('data')";
mysql_query($query);
$query = "insert into table4 (col1) values ('data')";
mysql_query($query);

rajarajan07

Reputation Points: 167

Solved Threads: 239

Nearly a Posting Virtuoso

Offline

1,445 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: finding a match

Next Thread in PHP Forum Timeline: Which function is used to add text in array from a text file?

DaniWeb Message

Cancel Changes

User Name
Password