the data below would be customers MENU for their products DATABASE, I would need to add "Categories id" into the equation also.
this would be [url removed, login to view] Where I would have a MENU ADDED, Next to the REVIEW BUTTON.
With CodeIgniter can you grab the products modules from, Controllers, models, views and helpers from that listing site that has products? and add Controllers, models, views and helpers to whizbiz code? I have an updated version with Database tables requirements completed below.
or I have another site that's Ci a Directory Listing site that has products cureently, move controllers, helpers over to new site? [url removed, login to view]
understand this? Creating a db.
1. Table dispensaries menu
dispensaries_id | dispensaries_name | address | phone_number | etc
Then for the 5 different menus, you would need this menu tables: OR I need Categories id added?
2. Table menus
dispensaries_id | menu_id
You would also need a table for the items:
3. Table items
item_id | item_name | item_producer | item_price | item_price_1 gram | item_price_2 gram | item_price_3.5 gram | item_price_4 gram | item_price_7 gram | item_price_14 gram | item_price_28 gram
4. Now you need a table to make a relation between all of them:
dispensaries_id | menu_id | item_id
5. This is normalized, as the table that correlates them is the relation_menu_items. How you're treating them is only programming logic.
For the constraints, you need to make a foreign key relationship between those:
dispensariess.dispensaries_id and menus.dispensaries_id
relation_menu_items.dispensaries_id and dispensariess.dispensaries_id
relation_menu_items.menu_id and menus.menu_id
relation_menu_items.item_id and items.item_id
13 freelancere byder i gennemsnit $68 på dette job
next to review button a new menu item will be added which will fetch data for user products using your provided DB schema, but for codecanyoon you want same functionality there?