Skip to main content
November 26, 2012
Question

Can you save to file and edit file?

  • November 26, 2012
  • 2 replies
  • 1698 views

I have this problem with a dummy site i'm working on (for learning purposes) and i have 20 form text fields with an "add extra field" button. They are for entering sales of products, but the problem i'm having is that i use a DB, but come to realize that anything greater then 20 entries won't work if i want to use a DB. So i was wondering if you can save the information given from the form fields onto a file of some sort (like excel or pdf), but later on if i want to make a change to an entry on that file would it be possible to recall the file and make the changes accordingly without rewriting the entire thing?

Hope that makes sense. thx

    This topic has been closed for replies.

    2 replies

    Inspiring
    November 26, 2012

    What happens on the 21st entry?

    November 26, 2012

    Sorry the error i speak of is something else, but what it actually does is only insert the first 20 since the db only has room for 20. So now i don't know how to compensate for the extra items for the form.

    Sorry for the mix up. Writing code at 3am is never good.

    Carl Von Stetten
    Brainiac
    November 26, 2012

    Dan Bracuk wrote:

    Do not alter your table by adding more columns.  Your initial db design was a mistake.  Adding more columns is simply changing the details of that mistake.

    You make a mistake and attribute 20 properties to an Order. You discover later an order is best described by 28 properties. Do you solve this by renaming the new properties orderItems?


    I don't believe that the OP was talking about properties of the order, but items included in the order (at least that was the impression I got from the previous entries on this thread).

    -Carl V.

    BKBK
    Community Expert
    November 26, 2012

    You intend to moonwalk back in time, mate. Databases were invented for just the purpose you describe. Some, like MySQL, have free versions.