Using HTML to insert data into an SQL server table

Question

A little background info: I am using Netbeans IDE 7.3, I have an SQL server running and I am trying to create a html application to insert data into the connected sql server/database structure.

I hope that made enough sense to see what I'm asking.

My question: I simply want to create a page on the HTML application which asks a user to enter information about a person such as their first name, last name, address, phone number, etc.

I want it to appear in this manner to the user:

First Name: [text area]

Last Name: [text area]

etc....

Then at bottom I want a submit button. At this point the information in the fields above would be sent to the "person" table in the database with each column/attribute filled with the appropriate information above.

A new row is created in the table at this point.

How can this be done? Examples of code would be great if you know of any.

Thanks in advance.

Juan Pablo Rinaldi · Accepted Answer · 2013-05-06 23:57:22Z

4

That cannot be done with HTML alone, you'll need a scripting language like PHP to do the job.

answered May 6, 2013 at 23:57

Juan Pablo Rinaldi

3,5161 gold badge23 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BrianH Over a year ago

Just to clarify, you need a server-side scripting language. You can build the form in HTML, then submit it with HTML or javascript, but that only gets the data to the web-server. SQL servers are their own piece of software and do not directly communicate with a client (browser). So you need PHP, ASP, JSP, or some similar server-side technology to handle connecting to the database itself.

What have you tried · Accepted Answer · 2013-05-06 23:58:24Z

0

Build a form and use PHP to process it (or some other scripting language, I use PHP):

<form method="post" action="path_to_script.php">
    <label for="username">Username:</label>
    <input type="text" name="username" />
</form>

PHP:

    if(isset($_POST['username'])){
        $username = $_POST['username'];
    }

    // Use $username as a parameter in your query

$stmt = $yourDatabaseConnection->prepare("INSERT INTO yourTableHere (usernameColumn) VALUES (:username)");
$stmt->bindParam(':username', $username);

$stmt->execute();

Learn more about prepared statements here

answered May 6, 2013 at 23:58

What have you tried

11.2k4 gold badges35 silver badges45 bronze badges

Collectives™ on Stack Overflow

Using HTML to insert data into an SQL server table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related