Proof of concept — JSON-based Customer Relationship Management (CRM) system
*********************************************************************************************************************************
Please note that there is not yet any schema validation for the JSON. If invalid JSON is entered,
the program will throw an error. However, editing the JSON is intended only for the admin;
users work with forms.
*********************************************************************************************************************************
Hi everyone,
I’ve just finished a zero-install prototype that manages all customer IT data (servers, clients, printers, software, TeamViewer, memos, photos) in a single PHP file — no database required.
Stack:
PHP 7/8 + 1 folder per customer (JSON + assets)
Login via one-time password
CRUD in the browser: full edit, block edit, or convenient form view
Audit log + CSV/JSON export + quality check (missing IPs, stale entries, …)
Why JSON instead of SQL?
Runs immediately on XAMPP/shared hosting
Git diffs remain readable
Schema is easy to extend — ideal for rapid prototyping
If it grows later, you can transfer the JSON schema 1:1 to SQLite/MySQL/DBF.
Code: just upload and start clicking.
Feedback, bugs, and extensions welcome here!
Live test here: https://clipper2web.com/wartung/
Description: https://clipper2web.com/wartung//doc.html
*********************************************************************************************************************************
Please note that there is not yet any schema validation for the JSON. If invalid JSON is entered,
the program will throw an error. However, editing the JSON is intended only for the admin;
users work with forms.
*********************************************************************************************************************************
Hi everyone,
I’ve just finished a zero-install prototype that manages all customer IT data (servers, clients, printers, software, TeamViewer, memos, photos) in a single PHP file — no database required.
Stack:
PHP 7/8 + 1 folder per customer (JSON + assets)
Login via one-time password
CRUD in the browser: full edit, block edit, or convenient form view
Audit log + CSV/JSON export + quality check (missing IPs, stale entries, …)
Why JSON instead of SQL?
Runs immediately on XAMPP/shared hosting
Git diffs remain readable
Schema is easy to extend — ideal for rapid prototyping
If it grows later, you can transfer the JSON schema 1:1 to SQLite/MySQL/DBF.
Code: just upload and start clicking.
Feedback, bugs, and extensions welcome here!
Live test here: https://clipper2web.com/wartung/
Description: https://clipper2web.com/wartung//doc.html