From the course: Database Foundations: Application Development

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Add data to a table with form controls

Add data to a table with form controls

From the course: Database Foundations: Application Development

Start my 1-month free trial Buy for my team

Add data to a table with form controls

“

- [Instructor] Using form controls, we can allow end users to add new rows of data to the database, without them having to know anything about how relational databases work or how our specific database is structured. Query_4 includes some form controls that accept user input. We have four text boxes and one selection list. Let's add a new row to the database. For the skew I'll fill in SOAP001. The product name is Olive Oil Bath Soap. We'll put it into the Bath and Beauty products category. The size is eight ounces and the price is 599. Let's press the Run Query button and the page returns the message that our row is inserted and it confirms the values that we submitted. And if you go back and then scroll up to query number three, we can run a select query against everything in the bath and beauty products category. And at the bottom, we should see our new product that we just entered. So our form is working. Let's go…

Contents