O'Reilly logo

Yii Rapid Application Development Hotshot by James R. Hamilton III, Lauren J. O'Meara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Initializing the Application Database

We are going to set up a database connection in NetBeans and load in a basic schema to get you started.

Prepare for Lift Off

We have put together some tables to capture basic comic book information:

  • book
  • author
  • illustrator
  • type (serial, trade, graphic novel)
  • grade (mint, near mint, fair, poor, and so on)

Yii requires consistency in table naming: singular or plural, but not both. Singular is recommended for simplicity.

Engage Thrusters

  1. In NetBeans, go to Windows | Services.
  2. Right-click on Databases and select New Connection….
  3. You should see a MySQL driver. Click on Next.
  4. Accept the connection defaults. (Click on the Test Connection button to verify it works).
  5. Click on Finish.
  6. Right-click on MySQL Server and select Create ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required