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

What is CRUD?

1:55 with Alena Holligan

At the heart of a dynamic application is a database. The acronym CRUD refers to all of the major functions that are implemented in relational database applications - create, read, update and delete.

CRUD for Database Applications

The acronym CRUD refers to all of the major functions that are implemented in relational database applications. Each letter in the acronym can map to a standard SQL statement:

Operation SQL
Create INSERT
Read SELECT
Update UPDATE
Delete DELETE

Although a relational database provides a common persistence layer in software applications, numerous other persistence layers exist. CRUD functionality can be implemented with an object database, an XML database, flat text files, custom file formats, tape, or card, for example.

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

    [SOUND] Hi, I'm Alina. 0:00
    I'm happy that you've chosen to join me today. 0:06
    In this course, we'll delve into the full spectrum of database interactions. 0:08
    At the heart of a dynamic application is a database. 0:13
    Whether the application is an e-commerce or social network or 0:16
    even a to-do app on your phone, the data needs to change over time. 0:20
    For example, if you run an e-commerce site, you'd want to search the products, 0:24
    update stock counts, create new orders or 0:29
    new products in your database, and remove all discontinued products. 0:32
    The site is dynamic because the state changes all the time. 0:36
    CRUD is an acronym that refers to the four main operations that you'd want to perform 0:40
    on data in a database. 0:44
    First, you want to be able to create or add data to a database. 0:46
    Second, you want to read the data. 0:51
    Reading would include searching and filtering the results. 0:53
    Third, you'd want to update or edit rows of data in any of the tables. 0:57
    Finally, you need a way to delete the data or remove the data. 1:02
    These four operations, create, read, update, and 1:06
    delete are shortened to the acronym CRUD. 1:10
    In this course, we're going to focus on creating, updating, and 1:13
    deleting rows of data from our database tables. 1:17
    Each of the CRUD operations has a SQL keyword associated with it. 1:20
    If you have experience querying a database, 1:25
    you should be familiar with reading from the database using the select keyword. 1:26
    We'll also use select again to create reports for our data. 1:31
    If you haven't taken the prerequisite and 1:35
    are new to databases, I'd recommend that you go and take them now. 1:37
    We'll use Treehouse workspaces, so you can choose launch workspaces to follow along. 1:41
    Alternatively, you can download the project files as well and 1:46
    work on your own machine if you prefer. 1:50
    Next, we'll take a look at the finished project. 1:52

    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