Adding Records to a Table in phpMyAdmin

To insert a new record to the table you created in the DbLab3P2, select the Insert link at the top of the page:

Click on Insert

When you click on Insert, you'll be taken to a new area. This one:

The Insert page

As you can see, our four fields are there: ID, First_Name, Surname, and Address. But look at the lengths of the textboxes under the Value. The sizes are determined by the length of the Fields. The address area is a lot bigger, because we used TINYTEXT.

To enter a new record in your table, you type your data in the textboxes under the Value heading. Go ahead and enter the following information for the Value textboxes:

ID: 1
First_Name: Test
Surname: Name
Address: 12 Test Street

Your screen should then look like this:

Values entered into the fields

Finally, click the Go button at the bottom of the screen to create the Row in your table. You will be returned to the Structure screen.

And that's it - you now have a database to work with.

In the next lab we can move on to doing just that - accessing this database with some PHP code.

Hand In on Moodle

1. A document explaining what you learned, what went well, and what problems you had.

<--Go to previous page

-- JimSkon - 2011-09-30

Topic revision: r2 - 2011-10-07 - JimSkon
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback