I have a basic question regarding linking an intranet web page to our SQL DB. My aim is to have a simple set of pages for users within the company to log various billing info to a locally hosted SQL database. I know SQL quite well, but my web design skills are very out of date. I want to know the easiest/best method/language to write the web pages in. For the moment I am happy for the pages to be pretty basic as long as I can write key info to the DB and from another page run a query on the info in the DB.
I would just like some advice what I should be looking at here. Should it be ASP or PHP or CSHTML or whatever? I am running 2008 R2 servers with IIS and SQL 2008. PCs are all Win 7 Pro. I am happy to install other modules if needed, but I'm just looking for any advice I can get. I'm not a natural programmer or web designer, but if I can find a simple template to read or write to the DB, I'll just copy and mod each page as needed. Also, if you have any suggested helpful websites, books, resources, videos etc, I would welcome the help.
Thanks in advance.