Jump to content

SaranacLake

Members
  • Content Count

    63
  • Joined

  • Last visited

Community Reputation

1 Neutral

About SaranacLake

  • Rank
    Regular Member

Profile Information

  • Gender
    Male
  • Location
    New York
  • Age
    40

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. SaranacLake

    Need a dynamic Subform

    Does this website not support BBCode? (It's a real PITA to use...) > ginerjm's reply wasn't about a static form with x predefined sets of input fields. > it was about entering one line item of data at a time, submitting the data (where it would be validated, > so you can correct any errors as they occur), and then presenting an empty set of input fields for the next data item. > the already entered data items would be shown with edit/delete buttons. Okay, I follow you/him now. The problem is that I don't want to do things piecemeal because that isn't how you'd do data entry in the real world. If this was for an order, at the top of the page you would enter customer and order information, and then below that on the same screen you would enter the order details for as long as necessary. (It would be insane to enter the customer and order info, click "Submit", and then get another page to enter the 1st item out of 100 items, click "Submit" and then get a another screen to enter the 2nd of 100 items and so on!!) With just PHP, you would either have to hard-code in A LOT of blank line item fields or do what you are are ´╗┐proposing, but neither really represents how the real world works, which leads me to think I need Javascript - which i don't know.
  2. SaranacLake

    Need a dynamic Subform

    If I understand you, that is the design I am trying to avoid, i.e. a static order details form with a finite number of entry fields. Let's say this was for Walmart and not a restaurant - although the problem exists in either - and Customer A buys one banana. That is easy to design a subform for that, - I could just have 5-10 slots and I'm safe. But let's say that Customer B is buying a monthly order for their family of 15... There could be HUNDREDS of order details, and you just cannot program a static subform and *hope* there are enough slots - plus it would look sloppy. How hard is Javascript to learn? While I want to keep learning, what I do NOT want is to get stuck spending learning Javascript all summer long. If I accept this new project, I would need to turn around a working prototype in under a month, and then once I have someting that at least works, then I can more easily invest time to becoming a Javascript guru while I work on version 2.
  3. SaranacLake

    Need a dynamic Subform

    Thanks for the reply. My background is with databases, so yes, I feel very comfortable with the data model part. It's just that I have been away from programming for several years, and my web programming skills are "light" (e.g. I don't know any of the fancy Javascript stuff). When I did used to do web development, it was mostly html pages/forms and serverside PHP, although I think I even forgot how to do that! As far as the database part, just doing this on the fly, I'd likely have this... CUSTOMER - id - and so on... ORDER - id - order_date - vendor - location - subtotal - discounts - taxes ORDER_DETAILS - id - order_id - product_id - unit_sale_price - quantity PRODUCT - id - name - description - unit_price - category - and so on... What I really need help with is figuring out how to build a control for the order details that acts like a spreadsheet where you can keep adding row after row as long as the customer is ordering more items.
  4. SaranacLake

    Need a dynamic Subform

    I guess you answered one question, in that I need to handle this on the client side, right? As far as your comments above, I'm not sure I entirely understand what you mean, since I don't know Javascript. How difficult would it be to learn how to do all of this? I have a good idea in my head what I want, but am just unsure where to begin since this is on the web.
  5. SaranacLake

    Need a dynamic Subform

    I want to build a webpage where an employee can key in an order, including the order details. Building an entry form for just the order is easy enough, because it is simply one webpage with a set number of fields. And when you need to enter in a new order, you simply load a new blank form. But the order details part seems trickier, because one order can have one-to-many order details, and so I need a subform that expands as more items are entered. For instance, let's say this is in a restaurant, and a large group of people walk in. There is no telling how many items they might order, but I would need a way to let the waiter keep adding items to their bill as long as necessary. On the web, I'm not sure even where to begin with this?!
  6. SaranacLake

    Plans & Promos

    I decided to go with a m-to-m before you posted. Similar to a textbook Orders ==> Order Details <== Products set up where you have a unit_price and a sale_price, I will do the same (as you also suggest) to allow me the ability to keep track of what price I sell a subscription at to an individual.
  7. SaranacLake

    Taking the leap to MVC

    And your answer to my other questions?
  8. SaranacLake

    Taking the leap to MVC

    @requinix, What about you? Can you recommend some books or websites or other sources where I can learn world-class MVC development? And do you agree that my next step should be mastering MVC before OOP or other things?
  9. SaranacLake

    Taking the leap to MVC

    Is the Fowler book agnostic? Will it work for Python and Java as well as PHP? Do I already need to understand MVC or OOP prior to reading it? Also, can you recommend some exceptional books (or online resources) for learning *proper* MVC? Based on what I know, it seems that learning MVC before OOP would be the best way to go...
  10. SaranacLake

    Taking the leap to MVC

    I appreciate the offer, but just like any sane business person wouldn't post their business plans online, there is no way hell I am publishing the codebase for my business on the Internet - not even a "private" Git repository. My code *does* work, and I have a viable product, so it's not like I can't code. My objective moving forward is to reduce the time it takes to ship my code. (There is LOTS of room for improvement there!!) It's one thing to post sample code, and clearly I am willing to do that, but to "turn over the keys to the kingdom", even to Bill Gates or Steve Jobs ain't gonna happen! But I am still eager to learn and accept help from others, just not quite on those terms. I'm sure you can appreciate my stance?!
  11. SaranacLake

    Securing 'hidden' form values

    Okay, I see what you are saying now...
  12. SaranacLake

    Taking the leap to MVC

    @requinix, So where is a good place to start learning MVC principles? I'm sure if I Google "MVC", "MVC principles" or "MVC architecture" I will get a million hits. (And if they are anything like info on OOP, then 90% of them are garbage.) So since I don't know the "right" way to do things, then how do I know which sources are teaching me the "right" way, and which ones are taking me down a path of failure?
  13. SaranacLake

    Securing 'hidden' form values

    Why am I making things complicated? The user is on page A, then choose a membership plan in a form, and it sets a value in the session that is then used on my checkout page. Not following you...
  14. SaranacLake

    Plans & Promos

    Fair enough! Psst... I created a most excellent thread asking for help on MVC... ­čśë
  15. SaranacLake

    Plans & Promos

    I see your points, except for maybe the last thing... if the only thing that changes on a plan is a rate change, then should I create an entirely new (and basically identitcal) plan just for the rate increase from say $50/yr to $55/year? I could do this this... MEMBERSHIP_PLAN -|----|<- PRICING_HISTORY That way if the price goes up of down I'm covered and don't have to muck up my database with clone records. However, to your earlier point, if things like features change, then sure, create a new record in MEMBERSHIP_PLAN with a comment like "Platinum (Winter 2019)", "Platnum (Summer 2020)", etc. Yes or no?
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.