ScrewLooseSalad Posted April 9, 2013 Share Posted April 9, 2013 I've now made a php application for organising company stock, however, the company has stock stored offsite, and just acquired a new supplier that's now holding stock; as this is likely to happen again I don't want to add another column manually and add in the code myself, I need to put this ability into the app; my concern is whether allowing a php app to make columns is wise. Are there any common security risks associated with this privilege? Is there another tactic people take or am I able to add this ability in safely? Perhaps as an admin user on the app? Quote Link to comment https://forums.phpfreaks.com/topic/276708-mysql-stratedgy-for-a-customisable-database/ Share on other sites More sharing options...
mac_gyver Posted April 9, 2013 Share Posted April 9, 2013 your "stock" table should have a "location" column that holds the id of the location the stock is at. you should have a "location" table that you simply add a row to with a new id (auto-increment) and the new location details any time you need to add a location. Quote Link to comment https://forums.phpfreaks.com/topic/276708-mysql-stratedgy-for-a-customisable-database/#findComment-1423653 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.