Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

RE: Answer: How can I allow the user to enter multiple rows of data?

by eak (Monk)
on Aug 07, 2000 at 20:04 UTC ( [id://26597]=note: print w/replies, xml ) Need Help??


in reply to Re: How can I allow the user to enter multiple rows of data?
in thread How can I allow the user to enter multiple rows of data?

I thought I would offer a little more cleaned up version. Cuz I have had to do this before.
for (1..10){ # using one var and letting CGI handle it print qq{ <tr> <td><input type="text" name="stuff"></td> </tr> }; } # In your script that receives the POST use CGI; my $cgi = new CGI; my @stuff = $cgi->param('stuff'); foreach my $thing (@stuff){ "INSERT INTO STUFF_HOLDER VALUES('$thing')"; }
BTW. The only other way I know how to INSERT more than one row into a table with a single SQL statement is by complimenting the INSERT with a SELECT. For example: INSERT INTO new_table SELECT * FROM old_table
  • Comment on RE: Answer: How can I allow the user to enter multiple rows of data?
  • Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://26597]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (7)
As of 2024-04-19 13:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found