- PHP
- Intermediate
About this Course
In this course we'll delve into the full spectrum of database interactions. Whether the application is an e-commerce, or social network site, or even a todo app on your phone, the data needs to change over time. CRUD is an acronym that refers to the four main operations that you'd want to perform on data in a database: Create, Read, Update, Delete.
What you'll learn
- PHP Data Objects (PDO)
- Creating / Adding Record
- Reading / Selecting Records
- Updating / Editing Records
- Deleting / Removing Records
- Accepting User Data
Project Setup
In this course we'll be creating a time tracker to keep track of the time spent on projects. We'll use the PHP Data Object to give us all the attributes and actions we need to interact with the database.
5 stepsCreating Records
The first two CRUD operations are the ones we perform most often on a database. Creating the record and Reading the record. We'll examine how PDO allows us to safely complete these operation on a database and how we handle user data.
10 stepsReading and Writing Reports
One of the great features of having data in a database is the ability to report on that data. Filtering data for different situations and performing calculations on that data. We'll discover how to use this feature to make our time tracker much more useful.
9 stepsUpdating and Deleting Records
Mistakes happen. Requirements change. We'll explore ways to handle these changes when it comes to our application and databases in general.
7 stepsTeacher
-
Alena Holligan
After starting out in fine art and moving into graphic design, Alena found her passion for programming over 15 years ago and has never looked back. Alena enjoys community and is excited to introduce people to the wonderful world of PHP and the Portland Tech Community.
When not at her computer, Alena enjoys exploring Portland with her friends and family, including her 3 young children. She also enjoys the Symphony, Cooking, Books, Yarn and Yoga.