Menu
Community /Pin to ProfileBookmark
@NogDogNov 29.2010 — #Actually, you can have multiple rows in one insert statement:
So what you can do is build up an array of value clauses, then implode() them with a comma.
Enter multiple rows into a database
I am creating a script that will allow employees to enter their billing codes online. I have several drop downs with the same codes and a text area next to each for the quantity. Foe example the employee may need to bill 1 x JC 415, 3 x JC452 and so on. These each need to go into a seperate row. i.e. jc415 – 1 into one row and then jc452 – 3 in another and so forth. Also if the employee does not enter data I need it not enter that. for example there are 15 drop downs. Maybe the employee uses 1 of the drop downs I do not need the other 14 to enter any data. I am attaching a photo of this. Any help would be appreciated.
[url]http://parkwoodtech.com/images/codes.jpg
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogNov 29.2010 — #Actually, you can have multiple rows in one insert statement:<i>
</i>INSERT INTO table (col1, col2, col3) VALUES
('foo', 'bar', 'fubar'),
('manny', 'moe', 'jack'),
('red', 'green', 'blue)
So what you can do is build up an array of value clauses, then implode() them with a comma.
[code=php]
$values = array();
foreach($something as $thing) {
$values[] = sprintf(
"('%s', '%s', '%s')",
mysql_real_escape_string($thing[0]),
mysql_real_escape_string($thing[1]),
mysql_real_escape_string($thing[2])
);
}
$sql = "INSERT INTO table_name (col1, col2, col3) VALUES " . implode(",", $values);
[/code]