My objective is to create an online Inventory management program for multiple business company. But i've got stuck in the database create.
I have created a database in phpmyadmin named "stock" with tables "users" and "stock". So when multiple users register to my site, one should only gain access to his unique "stock" table in the database.
How can i do that? shoudl I create multiple tables "stock" and assign every user_ID to it. I cannot have only 1 tale "stock" to multiple users, it won't work
Please give me a solution for that thanks! :D
A responce will be appreciated