Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

CRUD Operations with PHP

Well done!

You have completed CRUD Operations with PHP!

Sign up for Treehouse Back to Library
Preview
Video Player
00:00
00:00
00:00
  1. 2x 2x
  2. 1.75x 1.75x
  3. 1.5x 1.5x
  4. 1.25x 1.25x
  5. 1.1x 1.1x
  6. 1x 1x
  7. 0.75x 0.75x
  8. 0.5x 0.5x
Use Up/Down Arrow keys to increase or decrease volume.

Totaling Time

3:39 with Alena Holligan

Without organizing and filtering the data, it's difficult to even see WHAT you have, let alone make that data useful. We'll write our first report that calculates how much time we've spent on tasks

[MUSIC] 0:00
Imagine walking into a library full of books. 0:04
Hundreds of thousands of books. 0:08
To those of us who like books, this is starting to sound pretty great. 0:10
Now imagine that those books are just randomly placed on shelves. 0:14
What a let down. 0:19
How will you ever find what you're looking for or even know that they have it? 0:19
The same is true for databases. 0:24
Without organizing and filtering the data, 0:27
it's difficult to even see what you have, let alone make use of that data. 0:29
Reports allow us to use that data to write a story. 0:35
A report may describe your site's visitors and which pages are the most popular. 0:39
Reports can help you forecast inventory 0:44
by telling how many products have been purchased in the last six months. 0:47
Reports can also give us the information we need to bill clients for our time. 0:52
In the next few videos, we'll read data from our database and 0:56
organize that data to create several different reports. 1:00
We'll start by setting up a table to display the Task Information and 1:04
summarize the time spent by including a grand total at the end. 1:08
Let's take a look at the starting point. 1:12
In a browser when we choose Reports, we see a table with a grand total. 1:15
We need to add the actual grand total and 1:20
the rest of the report information from our database. 1:23
So let's get started. 1:25
Back in workspaces, open reports.php. 1:27
Let's add opening and closing PHP tags right after the opening table tag. 1:31
We know we're going to need a total for the grand total. 1:43
So let's start with a variable named Total, and set it equal to 0. 1:46
Now we need to loop through each of our tasks, and add the time to our total. 1:51
We've done this loop before so it should look familiar. 1:55
foreach (get_task_list() as $item). 1:59
Now we want to $total += 2:08
$item['time']. 2:13
And finally, we can use that total for our grand total. 2:18
echo $total. 2:25
Let's view this in the browser again. 2:28
Great, we have a total. 2:32
Now let's show where that total came from. 2:33
Back in our foreach loop, let's add a new table row. 2:36
Then add cells for the task details. 2:49
Title, date and time. 3:13
Let's go back to the browser and check this out. 3:17
Now we see a list of all our tasks along with that grand total. 3:21
This is pretty much just like our task list page with more details. 3:26
It doesn't give us too much of an insight into our data. 3:30
In the next few videos, 3:33
we'll organize our data into more informative and useful reports. 3:35