Forum Moderators: phranque

Message Too Old, No Replies

Need to upload fresh data for multiable users

Without using a database such has mysql, etc...

         

casey133

5:10 am on Nov 18, 2004 (gmt 0)

10+ Year Member



Hey guys, i help a client run a billing company. he has about 20-30 customers that go online and look at and track their current status such as payment due, schools name, just easy stuff. ok her eis what he wants to do:

Change the information the customers view using Excel or another app in the microsoft office pack

upload it to the website

but he doesnt want to use any databases such as sql/cgp/php, just very basic updating here

here is the only way i can think of, see if this will work:

make a "mini-site" for each customer based on the same theme and layout.

use excel, etc... to write in the new data and save as web page

save webpage to that customers folder and just link to it from their mini site/members area.

will this work or is there a more robust way ot uploading and or linking this data, remember... cant use any databases or scripting.

thanks

encyclo

4:02 pm on Nov 18, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If it is very basic information, then yes you can save an Excel spreadsheet as HTML and upload it. But, how are you going to secure that data? That is the most important part of the job, as your client is liable if the protection is inadequate and a third-party gets hold of his customers' personal financial information. He will be sued out of business if client records are exposed on the internet. In many jurisdictions, he risks jail, and you might too.

So in this situation, the most important part is not the management of the information itself, but the access control. Simply "hiding" it (security by obscurity) is totally useless: you need to have a robust authentification system with verified login / strong passwords, on a secure server (https). For that, you are going to need server-side scripting and perhaps a database for the login names/passwords, etc. - there is simply no alternative, no shortcuts.

casey133

4:23 pm on Nov 18, 2004 (gmt 0)

10+ Year Member



should have put this in my first post... he does use a secure login, its hosted on his server as is his webpage. he just wantes to be able to upload easy to that secure part of the members area.