adwfun Posted November 18, 2006 Share Posted November 18, 2006 Hi all, I need a form to request users to enter information such as Company Name, Address, Tel, Contact, etc.. and their branches info if they have any. i.e. If they have a headquarter and several branches, I need all their info.How do I proceed to build the form that the Company has the option to add unlimited branches info so that I can store them in MySQL database ? And the Company is able to review all the entry before posting, preferably in a format such as a spreadsheet ? Anyone, please give me a direction ?I am using PHP & MySQLThanks. Link to comment https://forums.phpfreaks.com/topic/27661-data-entry-to-form/ Share on other sites More sharing options...
trq Posted November 18, 2006 Share Posted November 18, 2006 The form itself is built using html, and if you'd like to add more fields dynamically for each branch then Javascript aswell.As for the database. Ide have two tables, one called clients, and one client_branches. clients would store all the users data aswell as a client id, then in the client_branches table you could have a row for every branch the client has. In this row you would store the client id (from the client table), thus tying the two tables together. Link to comment https://forums.phpfreaks.com/topic/27661-data-entry-to-form/#findComment-126517 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.