How to Add Data in PHPMyAdmin Dreamweaver and PHP


show more Adding data in phpMyAdmin provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL show less
please wait ...

Adding data in phpMyAdmin

Once you've defined a database structure, you can add data to the database through phpMyAdmin. For this demonstration, I'll use the database structure that I've already created in a previous video. The name of the database is mydatabase. From the homepage of phpMyAdmin, I'll click into the database. The database has a single table, named people. Some of the icons will be disabled. The Browse and Search icons are both disabled currently, because the table doesn't have any data.

To insert some data, click the Insert link, the fourth icon from the left. You're taken to a screen where you can insert multiple rows. I'm going to add data for the firstName and lastName columns. I won't add data for the Id column, because that's an auto incrementing primary key. I'll click into the firstName, and type a value of Davey, and the lastName will be Jones. Then I can click Go immediately, or I can click down into fields in the second data entry form and insert multip...

Adding data in phpMyAdmin
Video duration: 2m 46s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Adding data in phpMyAdmin provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL

Subjects:
Business Developer Web
Software:
Dreamweaver
Author:
please wait ...