This course will be retired on June 1, 2025.

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

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Introduction to the Project

2:20 with Alena Holligan

In this course we'll create a time tracker to keep track of the time spent on projects. In this video we'll take a look at the finished application.

To follow along, launch the workspace associated with this video, or download the project files to work on your machine. If you want to set up a local development environment, check out one of our workshops:

Mac: Local PHP Dev Environment

Windows: Local PHP Dev Environment

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    In this course, 0:00
    we'll create a time tracker to keep track of the time spent on projects. 0:01
    These projects could be personal projects like you're learning or 0:05
    doing here at Tree House, business projects that you're getting paid for, or 0:08
    charity projects where you're volunteering your time to build your portfolio. 0:12
    But no matter which type of project you're working on, 0:17
    it can be helpful to keep track of the time you're spending. 0:19
    Let's take a look at the finished application. 0:23
    The home page of our Time Tracker app gives us three options, Add Task, 0:26
    Add Project, and View Report. 0:31
    When we click Add Task, 0:34
    we're taken to a form where we must fill out all the required information. 0:36
    The projects are populated in a drop-down, and 0:40
    our date field requires a valid date and format. 0:43
    Once our time is added were taken to a task list page where we can add a new 0:53
    task, select a task to edit, Or delete a task. 0:57
    We can also access this page through the navigation 1:06
    at the top by clicking on Tasks. 1:08
    When we click Projects in the navigation, were taken to a project list page 1:11
    where we can add a new project, choose a project to edit, or delete a project. 1:16
    When we choose Add Project, 1:21
    were taken to a project page where we must fill out the required information. 1:22
    Finally, in the navigation, we have Reports. 1:30
    This takes us to a page that gives us a report for our time and allows us to 1:33
    choose different filters for the report based on Category, Project, and Date. 1:38
    This is a fairly basic application and 1:47
    there are many more features that you can add, but you can start using it right away 1:49
    to track the time that you're spending learning to program. 1:53
    As you use the application, you'll think of more features that you'd like to have. 1:57
    Adding those features is a great way to learn. 2:01
    To give you a head start, 2:04
    I've provided the shell of the project including CSS styles and forms. 2:05
    I've also included a SQLite database with all the tables and 2:09
    fields that you'll need, as well as some initial test data. 2:13
    So let's get started connecting all those pieces together. 2:16

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up