Best way to write a web page to link to an SQL DB to read and write infomation

Hi guys,

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.

Bob
LVL 2
Bob SampsonHead Of ITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BradyPrincipal Data EngineerCommented:
I would use a basic setup with php on the server side to do the reading/writing to your database and on the web side I would use ajax or jquery to make the calls to php. There are plenty of examples out there to get you started. Basically, the php page will connect to your localhost and select the database required.

Use php to process any requests that come from the $_POST array (That is generated automatically when parameters are sent to a php file). When you have finished processing the data you can send back a message to ajax/jquery by echo something. You process the result/message and jquery will update your page. Sorry I can't elaborate at the moment I'm in the middle of a big project.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bob SampsonHead Of ITAuthor Commented:
Hi Mark,

Thanks for taking the time to respond. I really appreciate the comment and I'll look into this and any others people suggest, but its all great help.

Thanks again.

Bob
Ray PaseurCommented:
Should it be ASP or PHP or ...
It should be whatever you're familiar with already, because the learning curve for any particular technology will be greater than the advantages of one technology over another.  That said, if you want to get started in PHP, this article can help you find a good foundation.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Bob SampsonHead Of ITAuthor Commented:
Hi Ray,

What I'm familiar with at the moment is network architecture and security. This will all be new to me, but I'm ready to spend some nights hitting the books.

Thanks for the input.

Bob
Ray PaseurCommented:
It will take some nights, but you'll be fine.  This is the sort of application that everyone new to PHP web application development writes, so there will be many examples available.  If you get a little PHP under your belt and want a jump-start, consider using a framework like Laravel.  A lot of the knobs and levers are already there in these frameworks, and you will need to write relatively little code to get a working application.

Also, if you're in an area that has a PHP user group, join up and share ideas.  Most of them are pretty helpful!
Bob SampsonHead Of ITAuthor Commented:
Excellent advice. Thanks Ray. I'll look up a local support group :)

Bob
Ray PaseurCommented:
Bob:  Where are you located?  Here are some PHP calendars:
http://php.net/cal.php

There may be opportunities for conferences, too.  Example:
https://world.phparch.com/schedule/
http://www.php.net/conferences/
Bob SampsonHead Of ITAuthor Commented:
I'm in Buckinghamshire, England.

I'll have a hunt through meetup. Also, 20 years of IT means I'm sure I can find a friendly PHP helper. Best thing about IT is how everyone is so helpful.

Bob
Jitendra PatilSr.Software EngineerCommented:
hi, Bob Sampson

If you are ok with any technology to work on then you can give a try to asp.net also it will be very helpful in web designing or windows application both, secondly there are tons of examples available on internet to give you a kick start and more over you just need copy & paste.

As you specified you are good with SQL, then what i think is ASP.net would be easy for you to tackle with the basic needs you are having right now. last but not least  you will get good result with less efforts.

you need minimum visual studio 2005 installed on your machine and you can create any kind of project with very ease.

for your reference you can try the below link
Inserting, Updating, and Deleting Data with the SqlDataSource (C#)

hope this helps.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.