[tpeck]

I hope this is the right place to ask.

I am trying to implement (or pay someone else to start implementing) a storage solution for data entered into a medium size web of pages.

The pages can either be stored on a local network or hosted on the internet. Either way, some sort of data collection process is required. I understand mySQL is the way to do it on a website online. (I use several mySQLs already on my own website - just a basic user). I am not sure about the intranet. Would mySQL still work?

The scenarios are these:

CASE A: say, 10 users on a network accessing a local bunch of pages (intranet).

They login and their individual state persists each time they login because of a local storage system.

CASE B: users from anywhere access an internet website.

They login and their individual state persists each time they login because of a *local* storage system.

CASE C: users from anywhere access an internet website.

They login and their individual state persists each time they login because of a server-side storage system.

Can anybody advise where I should be heading? I don't really want two sets of the pages (there are 100s of them) one for online and one for the intranet.

I don't really know where to begin. I have been dabbling with localStorage and jstorage (lawnchair etc.) but it seems there are security issues with these methods.

Any advice is welcome.