“Buy physical, download digital, hire for the small web — all in one place, priced in plain dollars.”

Browse physical goods ↓

Physical Goods

Ships · Local pickup available

Graded, tested, photographed. Condition is in the listing — no mystery boxes. Click any listing for full details, shipping, and how to claim it.

Digital Goods

Instant download · Keep forever

Single-file HTML, theme packs, music + visualizers. Pay once, download the file, no subscription, no DRM. Click any listing for what’s inside.

Jobs Board

Fixed price · Remote

Direct listings, no recruiter cut. Price, scope, and delivery are in the listing. Click to apply — you’ll get a confirmation right here.

Help Wanted Dev Boards

Collab / Paid

Open calls for builders. If you can do vanilla JS, WebAudio, or pixel art, pick a board and reply. Click any board for what’s needed.

Backend

Local-only right now: listings are hard-coded in this file. This is the map to make it real — same tinyfiles PHP pattern: /api/bootstrap.php, json_in() / json_out(), prepared PDO. Prices in cents, no external checkout in v1.

01 / Files to create
api/market/listings.php       GET  /api/market/listings?dept=physical
api/market/listing.php        GET  /api/market/listing?id=12
api/market/orders.php         POST /api/market/orders  (physical + digital)
api/market/jobs.php            GET  /api/market/jobs?dept=jobs
api/market/apply.php           POST /api/market/apply   (job / help-wanted)
sql/market_tables.sql
cron/market_cleanup.php       CLI — close expired jobs > 90 days
02 / Database tables
-- sql/market_tables.sql
market_listings
  id INT AUTO_INCREMENT PRIMARY KEY
  dept VARCHAR(20) NOT NULL        -- physical / digital / jobs / help-wanted
  title VARCHAR(200) NOT NULL
  description TEXT NOT NULL
  price_cents INT NOT NULL         -- 0 = rev share / collab
  category VARCHAR(30) NOT NULL
  condition_text VARCHAR(80) NULL
  seller_handle VARCHAR(80) NOT NULL
  status VARCHAR(20) NOT NULL DEFAULT 'active'  -- active / sold / closed
  created_at DATETIME NOT NULL

market_orders
  id INT AUTO_INCREMENT PRIMARY KEY
  listing_id INT NOT NULL
  buyer_handle VARCHAR(80) NOT NULL
  price_cents INT NOT NULL
  fulfillment VARCHAR(20) NOT NULL  -- ship / pickup / download
  status VARCHAR(20) NOT NULL DEFAULT 'pending'
  created_at DATETIME NOT NULL

market_applications
  id INT AUTO_INCREMENT PRIMARY KEY
  listing_id INT NOT NULL
  applicant_handle VARCHAR(80) NOT NULL
  message TEXT NOT NULL
  created_at DATETIME NOT NULL
03 / Template: api/market/listings.php
<?php
// api/market/listings.php — list by dept, active only
require __DIR__ . '/../bootstrap.php';
$dept = $_GET['dept'] ?? 'physical';
$stmt = $pdo->prepare(
  "SELECT id, dept, title, description, price_cents,
          category, condition_text, seller_handle, created_at
   FROM market_listings
   WHERE dept = ? AND status = 'active'
   ORDER BY created_at DESC LIMIT 100"
);
$stmt->execute([$dept]);
json_out(['listings' => $stmt->fetchAll(PDO::FETCH_ASSOC)]);
04 / Template: api/market/orders.php
<?php
// api/market/orders.php — create order, no payment in v1
require __DIR__ . '/../bootstrap.php';
$in = json_in(); // { listing_id, buyer_handle, fulfillment }
if (!in_array($in['fulfillment'] ?? '', ['ship','pickup','download']))
  json_out(['error' => 'fulfillment required'], 400);
$stmt = $pdo->prepare(
  "SELECT price_cents, status FROM market_listings WHERE id = ?"
);
$stmt->execute([$in['listing_id']]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$row || $row['status'] !== 'active')
  json_out(['error' => 'listing not available'], 400);
$stmt = $pdo->prepare(
  "INSERT INTO market_orders
   (listing_id, buyer_handle, price_cents, fulfillment, status, created_at)
   VALUES (?, ?, ?, ?, 'pending', NOW())"
);
$stmt->execute([$in['listing_id'], $in['buyer_handle'],
  $row['price_cents'], $in['fulfillment']]);
json_out(['ok' => true]);
05 / Template: sql/market_tables.sql
CREATE TABLE IF NOT EXISTS market_listings (
  id INT AUTO_INCREMENT PRIMARY KEY,
  dept VARCHAR(20) NOT NULL,
  title VARCHAR(200) NOT NULL,
  description TEXT NOT NULL,
  price_cents INT NOT NULL,
  category VARCHAR(30) NOT NULL,
  condition_text VARCHAR(80) NULL,
  seller_handle VARCHAR(80) NOT NULL,
  status VARCHAR(20) NOT NULL DEFAULT 'active',
  created_at DATETIME NOT NULL,
  INDEX (dept, status, created_at)
);
06 / Validation & rules
// Server owns the truth. Browser submits intent only.
- Price: integer cents only. Never accept float dollars.
- Dept: must be one of physical / digital / jobs / help-wanted.
- Title: plain text, max 200 chars, strip tags.
- Description: plain text, max 2000 chars, no <img> / data:image.
- Digital: fulfillment must be 'download'. Physical: 'ship' or 'pickup'.
- Orders: only 'active' listings can be ordered. Mark 'sold' after claim.
- Jobs / Help Wanted: no orders, only applications via apply.php.
Keep it local-first: if the API is down, this page must still show the hard-coded listings above. The backend only adds real storage + ordering — it must never make the page blank.