Hello, Actually the data will be sent to the database through a total of up to 150 separate fields. An estimation of 25,000 words will be loaded to the database through all of these 150 fields combined.
As always, I appreciate the links you have sent. I try to spend as much time as I can learning before I go asking. Basically, I am building a site that is involved with online education. The db is designed to hold up to 60 individual lesson sets within one course stored in plain text and html, though I am anticipating the average to have 20 lessons at most. Now you understand that the 25,000 words represents the average input with a top potential of around 75,000 words in the extreme. Thanks for your assistance. Bill Platt Edward Moon wrote: > > Can you give us more details on what you want to do? > > Do you want to stuff all 25,000 words into one field? > > If you need to insert a large amount of data into one database field, I > would suggest that you consider doing a file upload (via POST) in your CGI > script. > > You can upload an arbitrarily large amount of data (and it's much more > convenient for the end user to specify a file to upload than open it and > paste it into a text field in a HTML form. > > Doing file uploads is very easy if you use the CGI Perl module. See > <http://www.wiley.com/legacy/compbooks/stein/source.html> for an example > (do a search on the page for 'upload' to find the demo cgi & source code). > > To store the data into a mysql database, you'll need to get familiar with > the DBI Perl module. The DBI module enables perl scripts to query > databases (including mysql). > > You can read the CGI and DBI docs at <http://www.perldoc.com>, CGI: > <http://www.perldoc.com/cpan/CGI.html> and DBI: > <http://www.perldoc.com/cpan/DBI.html>. > > On Fri, 19 Oct 2001, Bill Platt > wrote: > > > Hello Everyone, > > > > I am curious of something. I am not even remotely knowledgable > > of PHP but have some base knowledge of Perl, so Perl is my > > language of choice. > > > > I am writing a set of scripts to send data pertinent to my > > needs to a mysql database. > > > > I am deeply concerned about running into limitations not > > precisely with the Perl itself, but with the post statement > > in the forms I am using. > > > > Best I can tell in learning Mysql, I have to send all data > > for the row at the same time and cannot post the data to the > > mysql table incrementally. Due to the outline of what I am > > working towards doing, I am breaking the data input into a > > series of baby steps and passing the data from one form to > > the next in the Post statements. My concern is that once all > > data is implemented into the table row, I am in effect loading > > nearly 25,000 words of text into the table! > > > > I sort of remember reading somewhere that the Post command in > > the HTML Form has a limitation to the amount of data it can > > pass between one form and another. I am certain that the > > 25,000 words will exceed the top limits of the Post commands? > > > > Given my situation, is there something I am missing that you > > could enlighten me about concerning passing chunks of this > > much data to the Mysql database? I have wondered if I need > > to send all of the text box data to temporary files for > > later filing in the mysql database? Is this a viable solution? > > Or am I just imagining a problem that does not exist? > > > > > > Thanks, > > > > Bill Platt _______________________________________________ Perl-Unix-Users mailing list. To unsubscribe go to http://listserv.ActiveState.com/mailman/subscribe/perl-unix-users
