How to create a FrontEnd website for a database within SQL Server 2005
Question
Wednesday, January 14, 2015 6:35 PM
Hello All,
I am fairly new to SQL and I am looking on step by step instructions on how to create a Front End Website for a database within SQL server 2005. I am looking just to create the front end to display some information from one specific table within that database in a cleaned up format. This front end will only recieve information from the SQL database, but users will not be able to add any information to it. I was going to use Visual Studio 2005 but the New/Website will not show under File. Any help would be great.
Thanks,
Andrew
All replies (9)
Wednesday, January 14, 2015 6:59 PM ✅Answered
Hello,
The following stored will show you how to convert table data into HTML.
http://www.symantec.com/connect/sites/default/files/spCustomTable2HTML.zip (Unzip it)
That stored procedure is part of the following Symantec article:
http://www.symantec.com/connect/downloads/sql-stored-procedure-convert-sql-table-html-v10
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
Wednesday, January 14, 2015 10:03 PM ✅Answered
You will probably want to venture into either ASP or PHP to get this done right.
Setting up a simple script to fetch data, parse it and display the results as a HTML page is fairly simple.
You'll need a webserver (apache is free), a server side language (PHP is free too) and your SQL server.
Once everything is installed, try this:
http://php.net/manual/en/function.sqlsrv-connect.php
Thursday, January 15, 2015 5:04 AM ✅Answered
Great! Thank you! Reading through this it looks like what I need. One last question once converted is there instructions on how how to make sure that website updates with information everytime the database updates information?
Thanks,
Information displayed in a web page need to refresh so that updated information are displayed in the web page. It is sometime not practical to refresh a web page manually all the time or at regular interval. However we can add a meta tag in the html to refresh the page automatically at regular interval. i.e, refreshing the page in 30 sec.
<meta http-equiv="refresh" content="30">
Regards, RSingh
Thursday, January 15, 2015 7:29 AM ✅Answered
What about using Visual Studio or IIS?
Sure, you can use the free Microsoft Visual Studio Community 2013 Edition to create a ASP.NET web solution which will provide "real-time" Access to your data.
Olaf Helper
Thursday, January 15, 2015 2:09 PM ✅Answered
Using visual studio would be the ASP side of the equation. ASP is not free, which is why I advised PHP. If it's available to you, and you'd prefer to use it, go for it! The same applies to IIS - It's microsoft's web server, not free.
Thursday, January 15, 2015 10:14 PM ✅Answered
IIS (webserver) and Visual Studio (development) are microsoft products, which have a license cost.
Apache (webserver) and PHP (engine) are both open source solutions without a license cost. You'll typcial do much of your development in text editor (conTEXT is a good one).
PHP does not have wizards, although there are many, many plugins and extensions that can make coding in it easier.
Wednesday, January 14, 2015 9:29 PM
Great! Thank you! Reading through this it looks like what I need. One last question once converted is there instructions on how how to make sure that website updates with information everytime the database updates information?
Thanks,
Wednesday, January 14, 2015 10:10 PM
What about using Visual Studio or IIS?
Thursday, January 15, 2015 9:38 PM
so a website can be built in PHP or IIS also for free? Is there some type of wizard?