Project overview

A compact showcase for a PHP customer-record workflow.

FlowLedger presents a small full-stack pattern: collect customer data in a form, validate it in PHP, insert it into MySQL with prepared statements, and review stored records in a listing screen. The public site documents the implementation cleanly, while the local backend in this repo remains executable.

View workflows Review backend code

Frontend Static HTML, CSS, and light JavaScript for GitHub Pages deployment.

Backend PHP handlers with centralized connection setup and safer inserts.

Data MySQL schema for customer records with a direct form-to-table mapping.

Stack

The repo is organized around one clear implementation path.

Input layer

The customer form captures ID, names, gender, contact details, and address data in a shape that matches the database schema directly.

HTML5 CSS3

Server layer

The backend validates required fields, normalizes input, and writes through prepared statements instead of raw interpolated SQL.

PHP mysqli

Storage layer

A single customer table keeps the demo focused and makes the insert and list workflows easy to inspect in code and in SQL.

MySQL SQL schema

Repository layout

`site/`

The public-facing GitHub Pages build. It explains the workflows, structure, and code without relying on a server runtime.

`backend/`

The local PHP/MySQL demo, including a connection helper, a create handler, a listing page, a schema file, and notes.

`legacy/`

The original imported files. They are kept for reference but removed from the published project surface.

`README.md`

The handoff document for deployment and local setup, written for someone reviewing or running the project later.

Source archive

Original bookstore asset from the first version of the repository — Original repository asset retained as part of the project history.

Book image retained from the original prototype — The current project no longer presents a bookstore UI, but the earlier source material is still acknowledged.