0

I have been thinking and trying to expand my knowledge of different tools. One thing I have never had personal experience with is getting website data that users enter, and have that loaded into a SQL Server Database. There are several tables in this database and I need a tool/advise on which is a good tool to use to have that data loaded into my data warehouse after end users enter information for different fields into the website. I am an experienced SQL user but have never needed to do this. This wouldn't be needed for any enterprise application, but more for personal use/knowledge. Can anyone provide any insight on the best tool/api they have used to make this happen. Obviously I know this can be done from sharepoint but I am looking for other ideas. Thanks in advance

0

You can obviously do it manually in PHP with any open connection, but there are so many security things you have to account for.

If your starting out your better off using a PHP framework which handles a lot of the under the hood work for you. If there's a security issue with the framework the framework maintainers will handle it.

You must validate all user inputted data to avoid hackers slipping junk or hostile things into your form.

A framework also allows you to generate a working product faster, and your not constantly worried about the fine details.

  • Thanks for the reply. Each user to the website would have their own login/pw with encryption. – Audi_boi Apr 5 at 14:49
  • Yes you can have that, I just started working with Laravel and it has the ability to have usernames and passwords. I am sure other frameworks have this ability. The password is obviously encrypted. Are you asking about encrypting more than that? – cybernard Apr 5 at 15:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.