1
I would like to know if possible how a great e-commerce works for example, I would like to create my user and put my products for sale, in the link example:
www.loja.com.br/meunome www.loja.com.br/your name
How does this work? Does one create multiple databases or is it all done in the same table? Let’s assume it has thousands of accesses per minute, how it works?
4
It’s actually simpler than it looks. When you type in store.com.br/your name, "your name" is a unique record, as if it were an ID, but easier to record and disclose (than numbers). The developer uses a user-friendly URL to do this. Each product is then linked to each user. In the product table you can have a field called 'username', so when someone type store.com.br/somemusuario, the system should return only the products related to them.
On the access side, it depends on the server capacity. Thousands of access per minute requires a good dedicated server.
Browser other questions tagged php mysql
You are not signed in. Login or sign up in order to post.
The addresses in the URL depend very much on the policy of the company that owns the system. Often politics is shaped by technical or financial constraints. It costs less and technically it is simpler to assemble Urls that way. About data volume such as its structure, the answer is similar. It depends on the structure of the system. On a single server you can have 10 to 50 stores, for example, and as a store grows in volume data or accesses, the shopkeeper is alerted to upgrade.
– Daniel Omine