close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Updating Multiple Records

Thread began 5/01/2014 5:36 pm by Nathon Jones Web Design | Last modified 5/05/2014 12:52 pm by Nathon Jones Web Design | 359 views | 12 replies

Jason ByrnesWebAssist

  That's not mentioned in the tutorial so, naturally, we didn't know to expect it.  



There are many form limits that are imposed by PHP. It is not possible for use to mention every one of them in our tutorials. we can help you to identify them when you do encounter them though.


  Can you clarify how many records the http://www.webassist.com/tutorials/Create-a-multiple-record-update-form tutorial is designed to work with so that we may, at least, test that it is actually working at all?  



You miss the point. It's not that there is a limit to how many records the tutorial is designed to work with, but that there _may_ be a limit imposed by the server.

One server may have settings in place that cause the limit to be 20 records, where another server may have limits to cause the limit to be 1000 records. It is a server configuration issue.

It also depends on how many column per record you are updating. for example in your case, you are updating the Price and Qty columns, so the form will need to contain and ID hidden element, and a element for the price and qty columns, that 3 elements per record. with 342 records to be updated, you need 1026 element, plus a submit button:
342 * 3 = 1026 + 1 = 1027

so, if you server uses the default 1000 form elements, you should be able to set the update page to update 332 records:
332 * 3 = 996 + 1 = 997


But again, that depends on the server configuration, and the number of columns being updated

see this page for details on post_max_size and max_input_vars settings
http://us1.php.net/manual/en/info.configuration.php

For updating text records, the 8M (8 Megabyte) default setting for the post_max_size should be fine

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...