codeseed
Sign in
Explore Projects
PHPbeginnerbackendAI generated

Basic REST API for a Notes App

Build a small REST API in plain PHP (no framework) that supports creating, listing, updating, and deleting notes, using PDO against a MySQL database and returning JSON responses. Learners practice designing REST routes manually, PDO prepared statements, and JSON request/response handling.

Estimate
~7.5h
Steps
5
Completed by
0
Proposed by
codeseed.app

PDO · MySQL

Sign in to claim this project

Project roadmap

  1. 01

    Set up routing

    ~1.5h

    Write a simple front-controller script that dispatches requests based on method and path.

  2. 02

    Connect to the database

    ~1h

    Set up a PDO connection and create a notes table.

  3. 03

    Implement CRUD endpoints

    ~2.5h

    Implement create, list, update, and delete logic using prepared statements.

  4. 04

    Return proper JSON responses

    ~1.5h

    Set correct headers and status codes, returning JSON for both success and error cases.

  5. 05

    Test with curl/Postman

    ~1h

    Manually test each endpoint and fix any edge cases with missing/invalid fields.

Resources

Ready to build this?

Get a GitHub repo and start building. Your AI reviewer checks each step as you go.

~7.5h · 5 steps

Tech stack

PDOMySQL