Prepare a database table for server behaviors Dreamweaver and PHP


show more Preparing a database table for server behaviors 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 ...

Preparing a database table for server behaviors

After preparing your custom forms for data management, the next step is to make sure your database structure matches the requirements of your forms. I'm going to go to phpMyAdmin for this step. If you're working with WampServer, open the Administration menu from the system tray icon and choose phpMyAdmin. If you're working with MAMP on Mac OS X, go to the MAMP homepage and click phpMyAdmin from there. Then go to the explorecalifornia database and from there, to the explorers table.

Then click Structure, at the top. This screen shows you everything you need to know about the structure of your database. For variable character fields, it'll show you how wide the fields are. It'll show you what data types are being used, for instance, the dob column is a date field, and most importantly for this exercise, it will show you which columns you can leave null, or empty, and which columns require values. It's very common for there to be mismatches between the database structur...

Preparing a database table for server behaviors
Video duration: 3m 3s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Preparing a database table for server behaviors 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 ...