title: Purchase Order entry screen and database design - PHP, db
body: <p>I'm developing a php/mysql purchase order system and need some advice on how to approach the user interface. I'm learning and figuring things out as I go.</p>
  
  <p>So when a user is entering line items into a purchase order it seems like right now they would be entering the item and quantity into a form text field and pressing the submit button. Then my php would sanitize and process the item into the database tables. </p>
  
  <p>The php would then send out a new page with the updated line item. </p>
  
  <p>It seems to me that this is fine for a basic method but there should be more elegant solutions. I haven't learned much javascript yet but I can imagine a script that would prompt a php script to do the sanitization and insertion and respond with the new position item and cost. This is beyond my abilities right now but I would be interested to know if that's the direction I should head.</p>
  
  <p>Thanks for your help!</p>