• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

How to Create DB connection in HTML Pages

Hi, Expert

I Need to develop website in HTML , give me your suggestions that which script we can use for SQL Server Database connection.
0
Asrar Azmi
Asked:
Asrar Azmi
  • 2
1 Solution
 
Chris StanyonCommented:
You need a server-side script to connect, such as PHP or ASP
0
 
Chris StanyonCommented:
I don't know ASP, but in PHP, a connection string will look something like this (this is for MySQL):

$dbh = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');

Open in new window


The connection to your database is now accessible through the $dbh variable, and you can use that to perform all the CRUD operations (Create, Retrieve, Update, Delete)
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
there are countless languages out there that will connect to a database, it all depends on the scope your project and what technologies you're comfortable with.

classic asp and PHP are excellent scripting languages, while .NET provides more of an object oriented approach.

If you can give us more info, such as technologies you're familiar with or the direction you want to take your professional career in (assuming this is related), then we may be able to give you more specific answers.
0
 
RobOwner (Aidellio)Commented:
I've requested that this question be closed as follows:

Accepted answer: 250 points for ChrisStanyon's comment #a39630232
Assisted answer: 250 points for The_Big_Daddy's comment #a39630329

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now