How to link SQL and HTML

[Jared]

How can I link a html website to SQL, is it necessary to use PHP or can you do it directly?

 

[Danilo P. Condes Jr.]

You need to apply some scripting language to connect you webpages into sql database. You can use PHP or JavaScript. I prefer PHP.

 

[Parth_Munjpara]

How can I link a html website to SQL, is it necessary to use PHP or can you do it directly?

Set connection=CreateObject("ADODB.Connection")
Set Recordset=CreateObject("ADODB.Recordset")
ConnString="DRIVER={SQL Server};SERVER=*YourSQLserverNameHere*;UID=*YourUserIdHere*;PWD=*YourpasswordHere*;DATABASE=*YourDBNameHere*"
Connection.Open ConnString