Setting up the database


show more Setting up the database provides you with in-depth training on Developer. Taught by David Powers as part of the Code Clinic: PHP show less
please wait ...

Setting up the database

Before diving into the PHP side of this project, let's take a look at how the raw data will be stored in a database. I'm using MySQL and phpMyAdmin, but you can use the database of your choice. Instead of going through the database setup step by step, I'll focus on the decisions I made and why. By the way, if you need help with creating database tables and user accounts in MySQL, take a look a my course, Up and Running with phpMyAdmin in the lynda.com online training library.

I decided to create a separate database called pendoreille. So let's take a look at that by clicking the pendoreille link on the left here. And it contains two tables. The first table, environmental data, contains the measurements from 2001 to early 2014. The second one, serialized data, only goes up to May 2010 and if I zoom in a little and if we look at the size over here on the right hand side, you can see why I abandoned the serialized data table.

Although it contains less data, it's nearly four times the si...

Setting up the database
Video duration: 4m 55s 4h 44m Intermediate Updated Dec 16, 2014

Viewers:

Setting up the database provides you with in-depth training on Developer. Taught by David Powers as part of the Code Clinic: PHP

Subject:
Developer
Software:
PHP
Author:
please wait ...